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 - 2002-03-13 : 08:56:08
|
| Debbie writes "if I have a backup that started at 21:00 and completed at 21:30 and have to restore it, what is the state of data in terms of time? Is it 21:00, or 21:30, or somewhere in between?" |
|
|
Jay99
468 Posts |
Posted - 2002-03-13 : 09:10:23
|
| a snapshot is taken at the start of the backup (that is what allows the db to stay online through the backup process)Jay |
 |
|
|
|
|
|
Backup and recovery