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 |
|
itsarnie
Starting Member
18 Posts |
 Posted - 2010-06-08 : 13:57:49
|
| Hi I have a script to restore database. In that script I put the wrong database name and I after I realized I cancelled the query. But now I cannot do anything on that database. Its shows still restoring.Please help and tell me what to do.Regards,ArnieThanks and regardsArnie, |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-06-08 : 14:27:14
|
| You need to restore the database you restored over.If it is Full Recovery Model you can [I think] take a final "Tail" TLog backup first, and then use that as part of the restore to get back exactly the point at which your accidental restore started overwriting it |
 |
|
|
|
|
|
database restore problem