MS SQL
Simple Recovery Model: Regular backups of the trans log are not required as they do not grow much. Downside: If there is a failure of the DB, all changes made after the last full backup are lost; no SQL mirroring.
If recovery from failure is critical, Full Recovery Model must be used. Ensure regular backups of database & trans logs. This allows for recovery of data up to point of failure.
http://bit.ly/9wBx35
More vQuotes
Simple Recovery Model: Regular backups of the trans log are not required as they do not grow much. Downside: If there is a failure of the DB, all changes made after the last full backup are lost; no SQL mirroring.
If recovery from failure is critical, Full Recovery Model must be used. Ensure regular backups of database & trans logs. This allows for recovery of data up to point of failure.
http://bit.ly/9wBx35
More vQuotes
No comments:
Post a Comment