Can I backup a database while its being updated

• 
  Yes, you can backup while users are actively using the database, and restore without any special procedures.

  petey June 06, 2008 00:55

  - 0 +
• 
  Would you be kind enough to point out where this procedure exists in the help files. I have a database (QASQL1) that gets synched every 4 mins with our website database and continuously by staff until 5.00 PM.
  
  If this is possible i would love you guys forever...don't panic this could be the end paranoia. If this is possible i'll buy another copy for the second server.
  
  Thank you

  qafoo June 09, 2008 09:37

  - 0 +
• 
  Could you please explain which procedure you are referring to?
  
  Also, re-reading my reply, I may have given impression that the database can be restored while it is actively being used. No, this is not possible. It can be backed up even while in use, but a restore requires that the database is not in use. There are exceptions to this in SQL Server 2005, where you can bring filegroups online one at a time.

  petey June 09, 2008 10:43

  - 0 +
• 
  The procedure i'm referring to is backing up whilst being used. I know that it can't be restored whilst being used.
  
  Are there any implications with this?
  
  Thank you

  qafoo June 09, 2008 16:46

  - 0 +
• 
  It's an inherent feature of SQL Server that you can take backups while the database is in use. Or do you mean something else?

  petey June 09, 2008 20:36

  - 0 +

Add comment

Please sign in to leave a comment.