problem with restore a backup in sql 2000. help me

  • Dear Members

    im have a  full backup with 87 diferentials backup in same file
    this backup are create in sql server 2000 and the file have  12 gb
    but im have this error
    ""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.
    RESTORE DATABASE is terminating abnormally."
    can  help me  to restore my database ???

    Thanks
    Almir

  • So you have 1 full backup and 87 differential backups have been taken since the full backup? If that's the case you only need to restore the full backup with norecovery and then restore the latest (or whichever you want) diff with recovery.

    Thanks

  • NorthernSoul - Friday, December 14, 2018 8:39 AM

    So you have 1 full backup and 87 differential backups have been taken since the full backup? If that's the case you only need to restore the full backup with norecovery and then restore the latest (or whichever you want) diff with recovery.

    Thanks

    Yes but i have only file
    This file have complete backup  and 87 diff backups  in same file ....

    You can help with command to restore all files?

    Thanks
    Almir

  • almirfiorio - Friday, December 14, 2018 8:55 AM

    NorthernSoul - Friday, December 14, 2018 8:39 AM

    So you have 1 full backup and 87 differential backups have been taken since the full backup? If that's the case you only need to restore the full backup with norecovery and then restore the latest (or whichever you want) diff with recovery.

    Thanks

    Yes but i have only file
    This file have complete backup  and 87 diff backups  in same file ....

    You can help with command to restore all files?

    Thanks
    Almir

    Do you mean you have a zip file with the different back ups in it?

  • I think this is what you're looking for.

    John

  • ZZartin - Friday, December 14, 2018 9:15 AM

    almirfiorio - Friday, December 14, 2018 8:55 AM

    NorthernSoul - Friday, December 14, 2018 8:39 AM

    So you have 1 full backup and 87 differential backups have been taken since the full backup? If that's the case you only need to restore the full backup with norecovery and then restore the latest (or whichever you want) diff with recovery.

    Thanks

    Yes but i have only file
    This file have complete backup  and 87 diff backups  in same file ....

    You can help with command to restore all files?

    Thanks
    Almir

    Do you mean you have a zip file with the different back ups in it?

    Nope

    Im have only .Bak with ALL backups 

    I did backup by choosing the "append to media"

    im have one backup file with one complete full backup and 87 differential bavkups

    how im can restore?

  • John Mitchell-245523 - Friday, December 14, 2018 9:41 AM

    I think this is what you're looking for.

    John

    This examples can work in sql 2000 ?

  • Well, my guess would be yes.  But you're the one with the SQL Server 2000 computer - why not try it?  You won't break anything.

    John

  • almirfiorio - Friday, December 14, 2018 12:10 PM

    John Mitchell-245523 - Friday, December 14, 2018 9:41 AM

    I think this is what you're looking for.

    John

    This examples can work in sql 2000 ?

    Yes. You have to use a file number.
    Restore full with norecovery include file number and restore a latest differential include file number.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • After you finally do get your restore to work, then you really need to look at your backup plan with the idea of quickly doing restores in the future.  Putting 87 DIF backups in the same file not only makes things a little more complicated but you're destroying the whole idea of "safety".  If that single file becomes damaged, you're screwed for restoring to a point anywhere near the current condition of the database.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    "Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 10 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply