October 20, 2010 at 6:34 pm
does a full backup also capture the transactions that take place while the backup is running? For example the backup starts at 2pm and ends at 4pm? will the transactions between 2pm - 4pm also be part of the full backup?
October 20, 2010 at 8:06 pm
A full backup will include as much information as possible at the time it finishes. The full backup takes into account the logs, and thus leave the DB in a transactionally consistent state. In your example, the full backup will contain a copy as of 4:00AM.
Perhaps this link will help to clarify your question:
However, for a production environment it is recommended to use a combination of Full, Differential and Transaction Log backup in the backup strategy.
October 21, 2010 at 5:33 am
What Sag999 said. It depends on what transactions get committed and written to the data file during the backup, if any.
And if your database backup is taking two hours, you might want to start rethinking your backup and restore strategy for your transactional database. If this is not a transactional (OLTP) database, but a warehouse or OLAP db, then I suggest you don't run your data feeds during backup times.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply