Re: SQL Agent restores
1998-09-17 15:25:35
Chris,
It seems that the restoration of the backups went ok into the db's that I
created. But after restarting SQL, the data in the db's was unusable. These
db backups go back 30 days, I have used over 20 of the backups with the
same result. Side note this db is used on a daily basis for accounting
purposes.
David Beardsley
Sr. Technical Programmer
Winn Dixie Stores Inc.
WWW.WINNDIXIE.COM <http://WWW.WINNDIXIE.Com>
"Good judgment comes from experience, and a lot of that comes from bad
judgment."
-----Original Message-----
From: Chris Zaremba [mailto:zaremba AT US.IBM DOT COM]
Sent: Thursday, September 17, 1998 2:46 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: SQL Agent restores
David,
>I have a server that the SQL databases crashed on. I
created a new server
>and created devices there, and restored my databases. All
revisions of my
>database backups were corrupt when I restored them.
Can you please elaborate? What do you mean when you say the
backup versions
are corrupt? Are
you unable to restore them or is the data not what you
expect after the
restore? If the latter, could it be
that the data was corrupted before the backups were taken?
Chris Zaremba
ADSM Agent Development
internet zaremba AT us.ibm DOT com
|
|
|