Sql 2000 Server Differential back script help

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  October 12, 2007 at 2:08 am

  #741458

  Frank

  Please will you post the RESTORE statement your trying and the exact error message it returns.

  Thanks

  John

• Franco Carchedi

  SSC Veteran

  Points: 255

  More actions

  October 12, 2007 at 2:12 am

  #741460

  sorry here it is.

  restore statement

  ALTER DATABASE Changepoint SET SINGLE_USER WITH ROLLBACK IMMEDIATE

  restore database Changepoint from disk = 'd:\temp\changepoint_diff1.bak' WITH RECOVERY

  GO

  ALTER DATABASE changepoint SET MULTI_USER

  Error message

  Nonqualified transactions are being rolled back. Estimated rollback completion: 100%.

  Server: Msg 4306, Level 16, State 1, Line 3

  The 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 3

  RESTORE DATABASE is terminating abnormally.

  thank you.

  Frank

  I have tried it with no recovery and still get the same message.

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  October 12, 2007 at 9:06 am

  #741618

  Frank,

  As John said yesterday, you must restore a full backup before restoring a differential backup. See "How to: Restore a Full Differential Backup (Transact-SQL) " in BooksOnLine for an explanation and example.

  Greg

  Greg