I'm using scheduled NTBackup jobs to take a backup of my Server 2003 box. Since I'm performing SQL Server backups of the databases, I'm more interested in including these backup files in the NTBackup, rather than the actual SQL Server datafiles themselves. I want to avoid, if I can, the databases being "frozen", backed up, and "thawed". I have therefore not included the datafiles in my backup job, but the databases still appear to be subject to the freezing and thawing process.
Yes I would like to omit ALL the the databases from the NTBackup backup. I'm only interested in backing up the backup files using NTBackup at this point.
Ah, so are you saying that if I disable the writer ("MSDEWriter" as its SQL2000) then this will do the trick. Does that then mean the files are simply ignored and not backed up?
Oh, wait... to answer the 2nd part of your last question.
Yes, if this works, the backup will skip those files as "file in use, unable to lock" and just skip those files and move on to the next file. The backup log file would contain the list of skipped files.
