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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-09-14 : 09:55:34
|
| ryan writes "I am restoring a database on my sql2005 box and the restore hangs everytime at 100%. other databases restore fine, but this database is about 5GB in size (roughly twice the size of the others). Any suggestions?Thanks in advance for your assistance,Ryan" |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-09-14 : 10:23:34
|
| I have noticed this in SQL2000 where the Log file was not being backed up (and the database Recovery model was FULL rather than SIMPLE). I think what happens is that there is a massive number of transactions to checkpoint (or whatever step becomes necessary on restore) on the new database.If that's the case either backup the TLog on the old server, or change the DB to SIMPLE, or simple truncate the TLog, and then take a new backups and restore from that. Or as you are - but sit and wait!!Kristen |
 |
|
|
|
|
|
sql 2005 restore