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 |
|
hgorijal
Constraint Violating Yak Guru
277 Posts |
 Posted - 2004-11-09 : 02:48:54
|
I did a FULL backup on database A and restored it on database BNow I did a differential backup on A and tried to restore it on B.Here is the command RESTORE DATABASE DB_B FROM DISK = N'E:\MSSQL\MSSQL$DEV\Backup\DB_A__Differential' WITH STANDBY = N'd:\mssql\MSSQL$QA\BACKUP\UNDO_DB_B.DAT', FILE = 1, STATS = 10 But, I get the following error...Server: Msg 4306, Level 16, State 1, Line 1The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY. Restart the restore sequence, specifying WITH NORECOVERY or WITH STANDBY for all but the final step.Server: Msg 3013, Level 16, State 1, Line 1RESTORE DATABASE is terminating abnormally.What am I doing wrong... Please advice...Hemanth GorijalaExchange a Dollar, we still have ONE each._______Exchange an Idea, we both have TWO each. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-11-09 : 02:59:00
|
| 1. restore full with norecovery2. restore differential--------------------keeping it simple... |
 |
|
|
hgorijal
Constraint Violating Yak Guru
277 Posts |
Posted - 2004-11-09 : 03:51:02
|
| bummer....thanks Jen .....Hemanth GorijalaExchange a Dollar, we still have ONE each._______Exchange an Idea, we both have TWO each. |
|
|
|
|
|
|
|
|
Differential restore error..