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 |
|
mufasa
Yak Posting Veteran
62 Posts |
 Posted - 2005-01-12 : 09:37:50
|
Hi I needed to get some information from a back-upWe just happened to have a new SQL server that I am able to restore too.The back-up is a complete back-up.When I restored it at 9 pm last night, it said that the restore completed correctly.When I try to access the database, it says that it is loadingIt has been loading for over 12 hours.When I check the \Microsoft SQL Server\MSSQL\Data: the file is there.The database is 56 gig, how long should it take to restore??If there is something I did wrong, how can I stop the restore?ThanksMufasa |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-01-12 : 10:58:50
|
| >> how long should it take to restore??Depends on the machine and the state of the backup - maybe an hour?>> it said that the restore completed correctlyIf that's so then it should be accessible. Have a look at the event log.Try restarting the server.You can also try setting it to emergency mode to access the data.http://www.mindsdoor.net/SQLAdmin/RecoverCorruptDatabase.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Restore taking forever 14 hrs+