Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wolf67
Starting Member
2 Posts |
 Posted - 2008-09-03 : 18:25:50
|
| I'm new to SQL and was "thrown" into getting a SQL server up and running as well as looking after the maintenance, restore procedures, etc.I was testing restoring transaction logs (through Enterprise Manager)and the first time it went well, however on subsequent attempts the message indicated the restore was successful, however in Enterprise Manager the database was "loading" and did not appear anywhere. I had to "attach" it with an attach script I found on the web. I looked up this issue and Microsoft acknowledges this is a problem but the fix is SP4 which is already installed.My T-SQL skills are quite limited and I'm trying to learn. Any ideas about this issue? All assistance would be greatly appreciated.Thank you in advance.Larry |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-09-03 : 18:32:41
|
| Did you run WITH RECOVERY on the last transaction log backup? It will stay in the "loading" state until the recovery process is done, which you specify in the RESTORE command using WITH RECOVERY. You can also do this from the GUI screen.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
|
|
|
Restore Problem SQL 2000