Angel Cat,
It was my understanding that SQL 7 and 2000 have a snapshot of the data "as
of" the end time of the databases.
If you start your backup at 6pm and users are inserting and updating, and
your database backup finishes at 6:30pm, your backup will be as of 6:30pm.
MSSQL 6.5 had a snapshot of the data at 6pm. Assuming the example above.
Oscar....
"Angel Cat" <ki***********@hotmail.com> wrote in message
news:9b**************************@posting.google.c om...
I'm exporting a large file from a large Production database (SQL).
Users are currently updating and inserting new records.
Does the export take a snapshot of the data when it starts ? or will
it freeze the database so all udpates/inserts happen after the export
completes?
Also, how do I get the delta of data that wasn't exported, if I want
to get the difference the next day?
Thank yoU!!!