I have a database currently showing to be in recovery. I have not been able to find a GUI method to monitor the progress (to determine when it might complete) so is there a command line T-SQL method to monitor the recovery process
Database in recovery
Transact-SQL
-
- Previous
- 1
- Project 2007 Server Cube Build Fails Connecting To Another SQL 2005 Analysis Server The MS whitepaper ¡°Requirements for using SQL Server 2005 Analysis Services with the Project Server 2007 Cube Building Service¡± shows two methods. Option 1: Create the repository by using a SQL Server 2000 Microsoft Jet database Option 2: Create the repository by creating a SQL Server 2005 database It would appear to me that you¡¯ve selected option one since you are using the share method. I¡¯ve been trying to use option two. Today I found the cause of the problem we were having. The account we were using for the SSP had limited privileges on the domain. I replaced the SSP account with an elevated account, re-tested the OLAP and the build was successful. Tag: Database in recovery
- 2
- Upload a Sql website to a host server I just want to clarify. It works fine on my local machine but I get the error if I upload it to the server and then try to run it. Will these changes make any diffeence with that Tag: Database in recovery
- 3
- SQL 2005 Transact-SQL Full Outer Self Join Thanks for the response. However, this query returns only the matching rows and non-matching rows for only one product (as if it is LEFT or RIGHT OUTER JOIN). I belive it is because of the WHERE clause. In case you are interested, the solution posted by another user (from MS team) works fine. Tag: Database in recovery
- 4
- Data entry in a datetime field. That is a better explaination - thank you. However, I can't reproduce the problem. The SQLExpress data base should allow you to enter the value as intended. It sounds like your database and/or development environment are corrupt somehow... Granted, I only tested creating a SQLEx database from within VS (full version), but the table viewer in VS allowed me to enter the date "1-2-2007" without a problem. Tag: Database in recovery
- 5
- Upgrade Hey guys - I need your help. We are using SQL Server 2000- do you think, we should upgrade to some later release of Microsoft SQL Servier or Migrate to Oracle, IBM or Sybase. I am also wondering, what do you think of Open Source MySQL and PostgreSQL. Have anyone of you using these databases. Thanks guys for your help - Mark Smith Tag: Database in recovery
- 6
- Matrix Report Not Showing All Columns Sure. No problem. Tag: Database in recovery
- 7
- Access denied starting SQL Server agent Arnie Rowland wrote: As I recall, the SQL Server Agent service must act as a member of the local admins group. The links that Madhu has referenced suggest this is counter to recommended practice... Tag: Database in recovery
- 8
- Can I/Should I turn off logging on some tempdb transactions? Presumably I can only use bulk copy load for loading from external sources. I'd like to use it for inserting the return data from a table valued UDF. Can someone explain WHY I need the transaction log in my case Tag: Database in recovery
- 9
- Released CozyRoc SSIS+ 1.1 Beta 3 Released a new beta of SSIS+ 1.1 library. It includes a new SSIS Zip Control Flow Task for compression and decompression of Zip, GZip, BZip2, Unix, Tar archives. Tag: Database in recovery
- 10
- OLAP, DTS and SQL I'm not sure if this will be of any help but the way i have been processing the cube is to call a stored procedure from my SSIS package which populates my dimension and fact tables. This initiates a SQL server job (of type SQL Server Analysis Services Command) to process the cube. The stored procedure call is as follows: EXEC msdb.dbo.sp_start_job @job_name=N'SSAS : Process Cube - Full' Within the SQL job i have a step which contains the XML to process the cube e.g. <Batch xmlns=" http://schemas.microsoft.com/analysisservices/2003/engine "> <Parallel> <Process xmlns:xsd=" http://www.w3.org/2001/XMLSchema " xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance " xmlns dl2=" http://schemas.microsoft.com/analysisservices/2003/engine/2 " xmlns dl2_2=" http://schemas.microsoft.com/analysisservices/2003/engine/2/2 "> <Object> <DatabaseID>ASCube</DatabaseID> </Object> <Type>ProcessFull</Type> <WriteBackTableCreation>UseExisting</WriteBackTableCreation> </Process> </Parallel> </Batch> This XML can be modified to include dimensions within the Process node e.g. <Process xmlns:xsd=" http://www.w3.org/2001/XMLSchema " xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance " xmlns dl2=" http://schemas.microsoft.com/analysisservices/2003/engine/2 " xmlns dl2_2=" http://schemas.microsoft.com/analysisservices/2003/engine/2/2 "> <Object> <DatabaseID>ASCube</DatabaseID> <DimensionID>Date</DimensionID> </Object> <Type>ProcessData</Type> <WriteBackTableCreation>UseExisting</WriteBackTableCreation> </Process> The stored procedure is called from an Execute SQL task within my SSIS package. This link may be of use to you, http://msdn2.microsoft.com/en-us/library/ms187199.aspx hopefully this may help, its another approach that you can look into. Cheers, Grant Tag: Database in recovery
- 11
- sp_ListFiles works differently based on the O/S level. Be sure to test "sp_ListFiles" carefully if you use it. It will fail on some versions of Windows because "DIR" returns different time formats. For example, Windows NT 5.2 (3790) does not return the required time format. "usp_Clean_Backup_Files" uses "sp_ListFiles" and that is how I came across this. Tag: Database in recovery
- 12
- rda dropping primary key index Hi, The table could have in excess of 1 million rows... I am not sure at how many it decides not to download the index/primary key constraint but it seems to be around the point where the database reaches 150mb although as stated previously the max size and max temp file size are set to 1024 mb The table structure is: Bull_id int Cow_id int Inbreeding_Value real the primary key is bull_id, cow_id I used this script to try to manually apply the index/key ALTER TABLE INBREEDING ADD CONSTRAINT PK_INBREEDING PRIMARY KEY ( COW_Id, BULL_Id ) the db was on the device at the time I did not try from the desktop the goal here is not to do this manually but to have the index be downloaded with the rda pull command Thanks a lot for your help!!! regards, eric Tag: Database in recovery
- 13
- report i need example of report, for some busines solution, do you know where i can to find it. Tag: Database in recovery
- 14
- counting all records in a database Is there an easy way to count all records in a database Tag: Database in recovery
- 15
- copy index statistics from production to development. I have a very large database that I need to be able to copy the statistics only from the production database server to my develoment environment. I need to be able to reproduce the execution plans on development without moving all the data. MS does this when they need to review the exeecution plan for large complex databases. Need help. Tag: Database in recovery
- 16
- An attempt to attach an auto-named database ....\aspnetdb.mdf failed I recently encountered this when I tried to add role management to a successfully operating user db. I had a connectionstring with a db name specified. Why should it need to autoname, or attempt to auto-attach It must not be using the connectionstring I specified for the user db. I looked at the web config and the role manager entry was as follows; <roleManager enabled="true" /> I modified it to be the following: <roleManager enabled="true" defaultProvider="SqlRoleProvider"> <providers> <clear/> <add name="SqlRoleProvider" type="System.Web.Security.SqlRoleProvider" connectionStringName="securityDB" /> </providers> </roleManager>. where securityDB was the connectionstring I was using for my DB. Made it work like a charm. Hope this helps. Tag: Database in recovery
- 1
- Next
- 1
- SQL Server Replication License Requirments I'm setting up SQL Server 2005 Replication. I have purchase a processor license for SQL Server 2005. Do I need a Windows CAL for each device that will be accessing the replication via IIS Thanks! Matt Tag: Database in recovery
- 2
- how to enable a user account I found the the status of guest account in model database is abnormal,but i don't know how to make it active. any suggestions thanks Tag: Database in recovery
- 3
- Why can't I use columns based on case down in my where clause I am writing a fairly simple sql, and I would like to write something like Code Snippet select firstname as firstname, case when firstname = 'Peter' then 'yes' else 'no' end as whatever from MyTable where whatever = 'yes' And this should then select out the rows where column number 2 is 'yes'. It doesn't work, and I have to copy the firstname = 'Peter' into the where clause. But why Tag: Database in recovery
- 4
- The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine. (System.Data) There is no option to download and install Jet drivers for XP Service Pack 2. I supposedly have the latest version already. Looking in my C:\Windows\system32 folder, I do not have the MSJET40.DLL or the MSWSTR10.DLL files. I cannot register or unregister the msjetoledb40.dll file. I get an error 'LoadLibrary("c:\windows\system32\msjetoledb40.dll") failed - The specified module could not be found.' How can I uninstall/reinstall or repair the Jet drivers Tag: Database in recovery
- 5
- Service accounts, local admin, and sysadmin question! whether it resolved or not ...pse post your solution if its not already mentioned in the previous posts... .... so that it will be helpful for others... Madhu Tag: Database in recovery
- 6
- Incorrect Totals So, if a product can have multiple prices depending on the catalog you have to know the catalog used in the purchase. In that case, does MG1 also have a direct relationship with the Catalog dimension Alternatively, can this be resolved in the DSV Could you create a named calculation in the DSV that multiplies the units by price to give you a transaction total The total seems to be additive. This might be an easier solutoin for you. Bryan Tag: Database in recovery
- 7
- Error: Subreport could not be shown. The aforementioned portal does not give me the facility to log a bug. I sign-in, navigate to the list of available connections, select SQL Server, peform a search for the error, but there is no " Submit Feedback " button at the bottom of the Search Results as described in the instructions. Tag: Database in recovery
- 8
- Converting XML Datetime to SQL Datetime The docs are misleading here. If you look carefully at the table above the quote, style 127 only work with Zulu timezone ("Z"). The workaround here is to use XQuery simple type construction. declare @t1 xml set @t1 = '<abc>2007-01-31T13:47:27.25+05:00</abc>' select @t1 . value ( 'xs:dateTime(/abc[1])' , 'datetime' ) -galex Tag: Database in recovery
- 9
- how to get YYYYMMDD formate It doesn't work when I use convert(char(2),'9',112). I still get '9' not '09'. How to use this function Thanks Tag: Database in recovery
- 10
- Comparison of SQL Server Reporting Services to Access Reports, Crystal Reports, Cognos or other options Hello SQL Server Experts, Data Analysts, and Report Writers et al: re: Reporting Options with SQL Server I wanted to propose an offshoot to the pryor thread: Would anyone take a stab at comparing Access Reports, Crystal Reports, Cognos or other options to all the Reporting Services and its components offered as part of SQL Server , especially as to extracting data from SQL Server into a report format I guess this is a far as capabilites, ease of use, limitations, and especially formatting or presentation of the end report product Thank you to all, and I hope this is a beneficial discussion to others. Hal1490 Hal9000 Tag: Database in recovery
- 11
- Changing the default database files path fails Waleed, You need to add the data and log files before you can assign the filename properties. Try the code here (I've adjusted your code): try { ServerConnection connection = new ServerConnection("localhost"); Server server = new Server(connection); if (!server.Databases.Contains("SMO_TEST")) { Database database = new Database(server, "SMO_TEST"); FileGroup fileGroup = new FileGroup(database, "PRIMARY"); database.FileGroups.Add(fileGroup); DataFile dataFile = new DataFile(fileGroup, "SMO_TEST_Data"); fileGroup.Files.Add(dataFile); dataFile.FileName = "D:\\SMO_TEST_Data.mdf"; LogFile logFile = new LogFile(database, "SMO_TEST_Log"); database.LogFiles.Add(logFile); logFile.FileName = "D:\\SMO_TEST_Log.ldf"; database.Create(); } } catch (FailedOperationException ex) { Console.WriteLine(ex.Message); } Tag: Database in recovery
- 12
- SSRS in Sharepoint, WrapperReportRenderingException/JobCanceledException for large Matrix (OLAP) reports It appears that you could be running into an ASP.Net timeout before the SharePoint method SPRequestInternalClass.OpenWebInternal is able to complete its operation. Does increasing the ASP.Net executionTimeout attribute of the httpRuntime element make any difference thanx, Prash Tag: Database in recovery
- 13
- AMO:Can any one knows hoe to rename a role and permissions to that role Hi All, I am working on AMO and vb.net.Here with this I am managing Analysis Server 2005 with AMO. My problem is , am able to create a role with role members . but when i try to rename a existing role i couldnt see any direct methods available with AMO.So what i did is first i created a role with normal procedure and then after , i am planning to drop the existing one. here when i did this i am getting some errors while dropping the role like meta data permissions are not able to drop. so could any one come across this kind of situation please help me. your help is valuable to the go further. Regards, vishweshwar.P Tag: Database in recovery
- 14
- RDA - multi table error for tracking Yes, of course you could use SubmitSQL, it can be used for any SQL statement that does not return rows (INSERT, EXEC sproc, UPDATE etc.) Tag: Database in recovery
- 15
- What is the easy way to do this?. I want this to happen on existing data. Not while inserting time. I want to trigger this, when enddt cross the server time status should change from live to expired. This should happen automatic. How can i do . Do i need to use trigger for that . enddt status 8/22/2005 7:00:00 PM expired 9/22/2005 8:30:00 PM expired 10/30/2005 7:30:00 PM live 11/22/2005 9:30:00 PM live Tag: Database in recovery
- 16
- Add SQL database - "login failed for user" error Hi I've installed 'SQL Server Express 2005 SP2'. When I select 'SQL database' from 'Add new item ' (either in Visual C# or Visual Web Developer express) I get the following errror: "Login failed for user'. My OS is Vista. I've tried reinstalling SQL Server express, but I still get the same error. Any ideas on how to fix this Thanks Jon Tag: Database in recovery
- 1
- Previous
Re: Database in recovery
Louis Davidson
If this is 2005, this might be what you need:
select der.session_id, der.command, der.status, der.percent_complete, *
from sys.dm_exec_requests as der
from sys.dm_exec_requests as der
It works for other types of commands that have known progress indicators. If not, then I really don't think it tells you. You might also check the error log to see how long it took the previous time...
Re: Database in recovery
windthorstking
Thanks Louis! It worked fine and the database eventually did recover.
