Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Backup and Restore Corruption question

Status
Not open for further replies.

cmdematos

IS-IT--Management
Mar 7, 2001
29
US
Hypothetically speaking, if the database corrupted, could I backup and restore the corrupted database without knowing it?

More specifically, if I run a warm backup server, and the main server gets some sort of corruption in its database, can this be transferred to the warm backup server?

What are the chances of Database Corruption?
 
Yes, as far as I know, backups don't know 'state'. Therefore, the backup doesn't KNOW the database is corrupt...it only knows that it is supposed to backup the database. So it backs up the databases current state - which may be corrupt.

-SQLBill
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top