Forum Discussion

ngdan's avatar
ngdan
Level 3
18 years ago

WSUS error message

Hi guys,
 
Had a problem during the last few months with the netbackup, one of the policies had returned 2 error message:
 
WRN - can't open file: F:\Software\WSUS\MSSQL$WSUS\Data\tempdb.mdf (WIN32 32: Unknown error)
WRN - can't open file: F:\Software\WSUS\MSSQL$WSUS\Data\templog.ldf (WIN32 32: Unknown error)
 
Was thinking of adding these 2 into the exclude list. Not too sure if this is applicable. Will it affect other files if I am to do that. Hope you guys can share your experience about this.
 
Thank you in advance
 
 
7.1.x and Earlier
Backup and Recovery
NetBackup

1 Reply

Sort By
  • DavidParker's avatar
    DavidParker
    Level 6
    18 years ago
    Yes, you should exclue *.mdf and *.ldf files on MSSQL servers; NetBackup cannot backup those files as they are constantly in use by the SQL server.

    To backup MSSQL you can either 1) use the MSSQL Agent or 2) have the SQL DBA dump the DB into .bak files and then back them up during your nightly jobs.

    Either way though, you should exclude those files ...

    Assuming you're on 6.0, here is some reference material:
    http://support.veritas.com/docs/279277
    VERITAS NetBackup (tm) 6.0 for Microsoft SQL Server System Administrator's Guide



    Message Edited by David Parker on 11-26-2007 03:10 PM

    Message Edited by David Parker on 11-26-2007 03:10 PM