Could not back up to a remote drive in maintenance plan
Posted on 2004-04-06
I have mapped a remote to g: on my SQL server server, but I could not make the drive g: selectable in the maintenance plan GUI. I just typed the G:. It worked for a testing period. Later I wanted to changed ti g:\sql2kbaks directory. But it does not work after setting the destination to the folder for log and db. Here is one of error message:
BackupDiskFile::CreateMedia: Backup device 'g:\sql2kBaks\model_tlog_200404060000.TRN' failed to create. Operating system error = 3(The system cannot find the path specified.).
I used domain account in service for the agent and check security - the domain account has write permission the folder.