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

We’re setting up K2 and it requires that several databases be snapshoted before being backed up so that they are at the exact same point in time. Can I do this and how? There are a total of 14 databases that need backed up.

  • Adding rows based on a condition sql
  • sql execution latency when assign to a variable
  • How to query min and max when a column consists of different several strings
  • How to sql query only once insert on android
  • SQL Split date range
  • SQL: Count each record, starting with the oldest to newest appointment
  • One Solution collect form web for “In SQL Server 2005, can I take multiple db snapshots at the same time?”

    If you want them backed up at the exact same point in time, you could put them all into single user mode, back them up, and return them to multi-user mode.

    The recommended maximum number of DB snapshots is approximately 10, and not intended to be used quite how you are proposing to use them.

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.