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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-03-24 : 01:11:13
|
| Dear all,i'm having one doubt since long time,what will happen if i'm taking a backup of 20 gb database, that is taking suppose two hours of time, in the mean time some users updated some tables or done some transactions. all those will be reflecting in the backup? please provide me clarity in thisthank you very muchVinodEven you learn 1%, Learn it with 100% confidence. |
|
|
PeterNeo
Constraint Violating Yak Guru
357 Posts |
Posted - 2008-03-24 : 01:43:17
|
| From BOL 2005, "Overview of Backup in SQL Server"Database backup :----------------A full backup of the whole database. Database backups represent the whole database at the time the backup finished. That means the transactions user performed ll also be included. |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-03-24 : 02:01:35
|
| thank you Mr. PeternanoVinodEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
|
|
backup doubt