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 |
|
kid_on_the_block
Posting Yak Master
172 Posts |
 Posted - 2006-03-16 : 06:49:20
|
| Hi I have made a small mistake while restoring the DB I selected the 3rd option in the em Leave the DB read-only and able to restore additional transactional logsI have just realized that all I have is a complete back up to restore & no transaction logss...I see the Db in a Read-only state & when I try to get it online It says Error 5063 : Db is a warm standby. A warm standby db is read-onlyAlter DB statement failed.sp_dboption command failedPlease Help |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2006-03-16 : 07:05:26
|
| look at the following:restore database DATABASENAME with recoveryBTW - what you've described is one of the reasons I subscribe to doing restores via SQL - then you cannot make that kind of "ooops", and you learn while doing.HTH*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
kid_on_the_block
Posting Yak Master
172 Posts |
Posted - 2006-03-16 : 07:27:05
|
| Thanks But then when I tried using this command it said , Server: Msg 3441, Level 17, State 1, Line 1Database 'Test' (database ID 7). The RESTORE statement could not access file 'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\UNDO_Test.DAT'. Error was '2(The system cannot find the file specified.)'.Server: Msg 3013, Level 16, State 1, Line 1RESTORE DATABASE is terminating abnormally.I checked for the undo file , I believe its got deleted , is there any way , we can recover this DB Please help. |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2006-03-16 : 07:35:01
|
| Hmm - do you still have the original backup you restored from? Seems that a re-restore is the simplest route, since the DB has been in read_only, you don't lose any data...*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
kid_on_the_block
Posting Yak Master
172 Posts |
Posted - 2006-03-16 : 07:39:02
|
| You mean , Restore it again to some other DB ......Could this not be solved ????? |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2006-03-16 : 08:07:47
|
| Actually, I meant restore it again over that specific DB. This assumes you are working in a dev/test environment (your DB name implies that) - you should not be restoring in produciton unless you know exactly what you want to do.Please decsribe your sequence of events - were you restoring to a new database, or restoring over your current database?When you say "3rd option" - I take it you mena: "Leave Database read-only and able to restore additional transaction logs" ?Unless you have a very big db/have lost the backup, redoing the restore seems to me to be the right solution here - from what you've said, the database should have been in read-only mode, so nothing is lost.CiaO*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
|
|
|
|
|
get Db online