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 |
|
microsql
Starting Member
9 Posts |
 Posted - 2007-05-16 : 06:53:56
|
| I have a database which seems to have been left in a restore state. I think this happened from a failed restore. I'm now wanting to restore the database again over this one but since it is in a restore state it is not possible. How can i change the status of this database to allow me to restore over the top of it. I only found out now having tried it that updating system catalogs is not possible in SQL 2005. So does anyone know how i can update the status column on the sysdatabaes table. Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-16 : 10:05:19
|
| Try this:restore database db_name with recovery |
 |
|
|
|
|
|
Database in Restore state