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.

  • Repeat Event Calendar based - Database Design
  • Word count for all the words appearing in a column in SQL Server 2008
  • Eliminating duplicate values based on only one column of the table
  • Error: “OLE DB provider ”MSDASQL“ for linked server ”(null)“ returned message ” Data source name not found …"
  • VARCHAR to DECIMAL
  • Mapping one to many relationship to existing database views without keys
  • 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.