problem with restore a backup in sql 2000. help me

  • almirfiorio

    Mr or Mrs. 500

    Points: 501

    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

  • NorthernSoul

    SSCertifiable

    Points: 6707

    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

  • almirfiorio

    Mr or Mrs. 500

    Points: 501

    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

  • ZZartin

    SSC-Dedicated

    Points: 30224

    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?

  • John Mitchell-245523

    SSC Guru

    Points: 148192

    I think this is what you’re looking for.

    John

  • almirfiorio

    Mr or Mrs. 500

    Points: 501

    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?

  • almirfiorio

    Mr or Mrs. 500

    Points: 501

    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 ?

  • John Mitchell-245523

    SSC Guru

    Points: 148192

    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

  • muthukkumaran Kaliyamoorthy

    SSCoach

    Points: 18856

    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 KaliyamoorthyHelping SQL DBAs and Developers >>>SqlserverBlogForum[/url]

  • Jeff Moden

    SSC Guru

    Points: 993401

    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.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems

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

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