Forum Discussion

BackupSysAdmin's avatar
BackupSysAdmin
Level 4
13 years ago

Host Sql Server backups

I am having an issue with the backup of one of the servers that host my SQL servers.  This server is running Windows 2003, SQL 2005, and Netbackup 7.0.1.  The problem is that I am backing up the Serv...
7.1.x and Earlier
Backup and Recovery
NetBackup
  • Will_Restore's avatar
    Will_Restore
    13 years ago

    exclude those database files from OS filesystem backups

     

     

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

     

    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.

     

Will_Restore's avatar
Will_Restore
Level 6
13 years ago

exclude those database files from OS filesystem backups

 

 

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

 

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.