Does SQL Server 2k bakup corrupt databases. We have a situation where we were
unable to restore a backup because sql server has backed up a corrupted
database ., Is that possible ? In SQL Server 7.0 it never backed up a corrupt
database. It will error saying the db is corrupt. Can anyone help me with
this issue.Do you have any specifics? Error messages, etc.?
Thanks,
Michael C#, MCDBA
"Disney" <Disney@.discussions.microsoft.com> wrote in message
news:245846AE-26AA-4E7A-B046-74E2C443B1E9@.microsoft.com...
> Does SQL Server 2k bakup corrupt databases. We have a situation where we
were
> unable to restore a backup because sql server has backed up a corrupted
> database ., Is that possible ? In SQL Server 7.0 it never backed up a
corrupt
> database. It will error saying the db is corrupt. Can anyone help me with
> this issue.
>|||Hi
Yes. As long as the GAM is OK, the DB should back up. Backup is there to
backup, not verify the consistency of a DB. Use DBCC on a regular basis to
ensure your DB is not corrupt.
If this occurs often, check your hardware. SQL 2000 corruption is mostly
caused by hardware problems.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Disney" <Disney@.discussions.microsoft.com> wrote in message
news:245846AE-26AA-4E7A-B046-74E2C443B1E9@.microsoft.com...
> Does SQL Server 2k bakup corrupt databases. We have a situation where we
were
> unable to restore a backup because sql server has backed up a corrupted
> database ., Is that possible ? In SQL Server 7.0 it never backed up a
corrupt
> database. It will error saying the db is corrupt. Can anyone help me with
> this issue.
>|||"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:usMUb3AAFHA.4028@.TK2MSFTNGP15.phx.gbl...
> Hi
> Yes. As long as the GAM is OK, the DB should back up. Backup is there to
> backup, not verify the consistency of a DB. Use DBCC on a regular basis to
> ensure your DB is not corrupt.
Can't remember what GAM is, but in our case, we could not backup our
database. We had a low-level disk corruption issue (invalid checksum) that
we were never able to solve. MS unfortunately was not able to provide any
work around. (I was hoping for some sort of undocumented flag that would
basically say, "ignore the problem" but apparently it does not exist.
So, I think the answer is, "it can vary".
> If this occurs often, check your hardware. SQL 2000 corruption is mostly
> caused by hardware problems.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Disney" <Disney@.discussions.microsoft.com> wrote in message
> news:245846AE-26AA-4E7A-B046-74E2C443B1E9@.microsoft.com...
> > Does SQL Server 2k bakup corrupt databases. We have a situation where we
> were
> > unable to restore a backup because sql server has backed up a corrupted
> > database ., Is that possible ? In SQL Server 7.0 it never backed up a
> corrupt
> > database. It will error saying the db is corrupt. Can anyone help me
with
> > this issue.
> >
> >
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment