Getting W3404 error message, need help or suggestions?

[33788]

Below is the backup error message. Wondering if OFA will help solve this problem or Agent for MS SQL will help? Any help would be greatly appreciated, thanks ahead.

W3404
Unable to open file. (FILE=C:\Program Files\Microsoft SQL Server\MSSQL$TRACKIT\Data\master.mdf, EC=32)
W3404
Unable to open file. (FILE=C:\Program Files\Microsoft SQL Server\MSSQL$TRACKIT\Data\mastlog.ldf, EC=32)
W3404
Unable to open file. (FILE=C:\Program Files\Microsoft SQL Server\MSSQL$TRACKIT\Data\model.mdf, EC=32)
W3404
Unable to open file. (FILE=C:\Program Files\Microsoft SQL Server\MSSQL$TRACKIT\Data\modellog.ldf, EC=32)
W3404
Unable to open file. (FILE=C:\Program Files\Microsoft SQL Server\MSSQL$TRACKIT\Data\tempdb.mdf, EC=32)
W3404
Unable to open file. (FILE=C:\Program Files\Microsoft SQL Server\MSSQL$TRACKIT\Data\templog.ldf, EC=32)
Retry Open File(s)

 

[vschumpy]

If you wanna backup SQL properly - use the SQL agent. Backing up via OFA may work, but personally I wouldn't recommend it.

 

[Cyklops]

There are 4 ways to resolve this:

1. stop the MSSQL server processes with a script, run the backup and restart them.

2. use OFA, but (as vschumpy already mentioned) it is not recommended.

3. use SQL's built-in backup utility to backup dump files (*.BAK) to disk. Backup the *.BAK files with ARCserve and filter out the skipped files.

4. use the MSSQL agent

with Windows 2003 server there is a fifth method : VSS

regards