Home Forums Article Discussions Article Discussions by Author Discuss content posted by John Sansom Part 2: Why you should be using the Full Recovery Model RE: Part 2: Why you should be using the Full Recovery Model

  • September 23, 2009 at 6:25 pm

    #1057828

    Jeffrey Williams-493691 (9/21/2009)

    No, BackupExec and other utilites like that won't backup SQL Server database files that are open. SQL Server locks the files and will not allow them to be backed up.

    This should be corrected to say: BackupExec and other utilities won't backup SQL Server database files unless their SQL Server "agent" software is purchased seperately and installed. Please see: http://www.backupexecfaq.com/articles/concepts/backing-up-microsoft-sql-server.html Other enterprise backup programs have similar - ask your vendor's rep.