What's Caught in the SQL Backup net?
-
Suppose our SQL server is doing a database backup and at that very moment a browser program attempts to update the database.
Is the user change "held" and later captured by the backup or is it missed until the next trans log dump?
TIA,
Bill
-
The backup completes and the backs up any items it missed during the backup. So, your users transaction would be caught by the backup net.
Brian Knight
http://www.sqlservercentral.com/columnists/bknight
Brian Knight
Free SQL Server Training Webinars -
Bill, Im not sure where the "cutoff" point is - if you're doing tran log backups you're in good shape. If you REALLY want to be sure, you could kick all the users out, then do the backup. Probably not a popular method, but it would work!
Andy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply