problem with restore a backup in sql 2000. help me

Question

problem with restore a backup in sql 2000. help me

almirfiorio

Say Hey Kid

Points: 665
More actions
December 14, 2018 at 8:33 am

#381031

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

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

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

NorthernSoul SSCertifiable Points: 6869 More actions · Answer 1

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 Say Hey Kid Points: 665 More actions · Answer 2

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: 30920 More actions · Answer 3

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: 148809 More actions · Answer 4

John Mitchell-245523

SSC Guru

Points: 148809

December 14, 2018 at 9:41 am

#2016338

I think this is what you're looking for.

John

almirfiorio Say Hey Kid Points: 665 More actions · Answer 5

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 Say Hey Kid Points: 665 More actions · Answer 6

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: 148809 More actions · Answer 7

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: 19026 More actions · Answer 8

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/

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 9

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.

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