Could not back up to a remote drive in maintenance plan


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.

Any suggestion?

GT
LVL 12
geotigerAsked:
Who is Participating?
 
arbertCommented:
You can't use mapped drives--they exist when you're logged on and are very difficult to get to work with a service account.  use the unc path instead:

\\servername\share\folder\backupname.bak
0
 
geotigerAuthor Commented:
Arbert,

Thanks for your comment. It is creating TRN files for some databases.

It seems that it only solves part of the problem. I am getting errors for not being able to switch to single user mode. Is it requred to switch single user mode even if it is just backing up logs? How to force users off in maintenance plan?

[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC SQL Server Driver][SQL Server]Database state cannot be changed while other users are using the database 'msdb'
[Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE statement failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
[3] Database msdb: Check Data and Index Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not processed. Database needs to be in single user mode.

    The following errors were found:

[Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not processed. Database needs to be in single user mode.
    ** Execution Time: 0 hrs, 0 mins, 1 secs **

GT
0
 
geotigerAuthor Commented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.