DOCUMENTATION: Which Microsoft SQL Server files can be skipped from a file system backup?

Article:TECH52558  |  Created: 2007-01-09  |  Updated: 2010-10-07  |  Article URL http://www.symantec.com/docs/TECH52558
Article Type
Technical Solution



Issue



Which Microsoft SQL Server files can be skipped from a file system backup?

 


Solution



To prevent Windows file system backups on a Microsoft SQL Server from exiting with a NetBackup Status Code 1 (the requested operation was partially successful), it is necessary to create an exclude list for the MS-Windows policy to exclude the database files.  

The SQL database files have three different file extensions: .mdf, .ndf, .ldf.  When creating the exclude list, be sure to exclude these three file types from the file system backup policy.
 



Legacy ID



289855


Article URL http://www.symantec.com/docs/TECH52558


Terms of use for this information are found in Legal Notices