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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-17 : 08:29:16
|
| xavi writes "First , excuse me for my english.My question is :I have a bakup from one database ; this backup is a diferencial backup. Just in a moment a wont to restore this backup in a new database ; but the system give me the next error:"The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY. Restart the restore sequence , specifying WTH RECOVERY or STANDBY for all but the final step.Backup or restore operation terminating abnormally"where is the problem? I'm using SQL Server 6.5 but i have the same problem in 7.0Thanks a lot." |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2002-06-17 : 08:56:17
|
| You cannot restore a differential backup if you don't have one good full backup first.The sequence shoul be:1 apply the full db backup.2 apply the last differential backup.3 apply any transaction logs backup that you may have after the differential backup.Only at the last step you should code "with recover".HTHFranco |
 |
|
|
Soulweaver
Starting Member
18 Posts |
Posted - 2002-06-19 : 07:48:09
|
| Franco is correct, some points to remember though.1. you need the full backup of the database you wish to restore2. you only need the newest differential (you don't need any previous ones - since each successive differential contains any changes from the previous differential3. any transaction logs that need to be applied.You do the full restore with the NORECOVERY option, leaving the database in a non-finalised state (it will still say 'loading' in EM)At this point you can apply the differential. (there's no need to specify with recovery because that is the default)RegardsTiaan-----------------------Black Holes exist where God divided by Zero----------------------- |
|
|
|
swarn
Starting Member
12 Posts |
Posted - 2002-12-09 : 11:20:10
|
| Hi guysI have same problem here. I have done following steps and my restoration have not worked..1. differential backup on main sql server2. ftp on require sql server3. run differential restoration but have not worked.i have backup fine and ftp worked fine too but this restoration...where i went wrong ?? do I need two backup files (full and differential) in order to restore database on another server??thanks |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-12-09 : 11:28:26
|
| Yes.Otherwise what are you restore the differences to?Restore the full without recovery then the differential.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
restore diferencial backup