Home Forums SQL Server 2008 SQL Server 2008 - General Getting a synchronized snapshot of several tables RE: Getting a synchronized snapshot of several tables
mark 4643
SSCommitted
Points: 1503
More actions
January 3, 2013 at 6:11 am
#1573280
Thanks for lightning fast Anthony
Looks like that will do the trick. Just need to add some stuff to manage the disk space
Seems I need to do the following
Create snapshot of orders as orders_temp
Copy the data I want
Drop orders_temp