Have Geek Brain

In SQL Server 2005, can I take multiple db snapshots at the same time?

We are setting up K2 and the backup requires multiple databases to be photographed to be at the same point in time. Can I do it and how? A total of 14 database backups.

+1


a source to share


1 answer


If you want them to be copied at the same point in time, you can put them all in single-user mode, back up and return them to multi-user mode.



The recommended maximum number of DB snapshots is approximately 10 and is not intended to be used exactly as you suggest using them.

+3


a source






More articles:


All Articles