Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-12-14 : 07:45:47
|
| Tahir writes "What Locking scheme SQL Server 2K uses during backup? Does is locks a table during database backup. How does it insure that backup is logically consistent? Is there a documentation I can read? I parsed through Online Books but found nothing that would answer this question.Thank you for your time." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-12-14 : 07:51:52
|
| SQL Server backups are online operations, they do not lock resources during execution. Since version 7.0, SQL Server database backups will back up the entire database plus the committed transactions in the transaction log. Restoring this backup will restore the database to its condition at the END of the backup procedure, except for uncommitted transactions.I know I have seen this documented somewhere but I can't find it Books Online. I'd suggest going through the entire section on backups under the "Administering SQL Server, Backup and Restore Operations" section in the table of contents. |
 |
|
|
|
|
|
SQL Server Locking scheme