Files being skipped. Are they necessary?

[undrcovr]

Every backup always skips the files below. Obviously they are tied to SQL Server but I dont know how important they are and wether or not I should back them up. Does veritas has an option to stop a running file, back it up and start it again?

Media used : Wednesday
File is in use : D:\Microsoft SQL Server\MSSQL$SBSMONITORING\Data\master.mdf
File is in use : D:\Microsoft SQL Server\MSSQL$SBSMONITORING\Data\mastlog.ldf
File is in use : D:\Microsoft SQL Server\MSSQL$SBSMONITORING\Data\model.mdf
File is in use : D:\Microsoft SQL Server\MSSQL$SBSMONITORING\Data\modellog.ldf
File is in use : D:\Microsoft SQL Server\MSSQL$SBSMONITORING\Data\msdbdata.mdf
File is in use : D:\Microsoft SQL Server\MSSQL$SBSMONITORING\Data\msdblog.ldf
File is in use : D:\Microsoft SQL Server\MSSQL$SBSMONITORING\Data\tempdb.mdf
File is in use : D:\Microsoft SQL Server\MSSQL$SBSMONITORING\Data\templog.ldf
File is in use : D:\Microsoft SQL Server\MSSQL$SHAREPOINT\Data\master.mdf
File is in use : D:\Microsoft SQL Server\MSSQL$SHAREPOINT\Data\mastlog.ldf
File is in use : D:\Microsoft SQL Server\MSSQL$SHAREPOINT\Data\model.mdf
File is in use : D:\Microsoft SQL Server\MSSQL$SHAREPOINT\Data\modellog.ldf
File is in use : D:\Microsoft SQL Server\MSSQL$SHAREPOINT\Data\STS_Config.mdf
File is in use : D:\Microsoft SQL Server\MSSQL$SHAREPOINT\Data\STS_Config_log.LDF
File is in use : D:\Microsoft SQL Server\MSSQL$SHAREPOINT\Data\STS_UFCTV-SBS_1.mdf
File is in use : D:\Microsoft SQL Server\MSSQL$SHAREPOINT\Data\STS_UFCTV-SBS_1_log.LDF
File is in use : D:\Microsoft SQL Server\MSSQL$SHAREPOINT\Data\tempdb.mdf
File is in use : D:\Microsoft SQL Server\MSSQL$SHAREPOINT\Data\templog.ldf
File is in use : D:\Shared Folders\Act Database\ufcdb.ADF
File is in use : D:\Shared Folders\Act Database\ufcdb.ALF

 

[steveot]

Looks as if your running Windows Small Business server. What version of Backup Exec?

If you create a batch file and place it in the pre-post command in the job setup.

 

[undrcovr]

Yeah, SBS with BE 10. I'll have to dig up my old dos commands, is it net stop to stop a service?

 

[SQLBill]

Yes, they are important. However, you cannot backup .mdf and .ldf files while they are online UNLESS you:
1. use SQL Server backup commands
2. use Veritas' Agent for SQL Server.

I suggest not using Veritas to backup those files. Have your SQL Server DBA do the backups to disk and then you COPY the backup files to tape using Veritas.

-SQLBill

Posting advice: FAQ481-4875