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 |
|
GeneralSQL
Starting Member
10 Posts |
 Posted - 2007-09-18 : 11:39:39
|
| SQL 2000 on Windows 2003 standard.We restored a backup of a database and had used the 'Leave database nonoperational but able to restore additional transaction logs' setting. That part of the restore went fine, but the tape that had the t-log backups had been overwritten. We do not have another backup to restore so how do we turn the database operational without having to wait the 6.5 hours to re-restore the database?Any help would be greatly appreciated. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-18 : 23:27:55
|
| Just run this:restore database db_name with recovery |
 |
|
|
|
|
|
Replication - DB still 'In Load'