Solved

Could not back up to a remote drive in maintenance plan

Posted on 2004-04-06
3
1,852 Views
Last Modified: 2007-12-19

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
0
Comment
Question by:geotiger
  • 2
3 Comments
 
LVL 34

Accepted Solution

by:
arbert earned 250 total points
ID: 10769318
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
 
LVL 12

Author Comment

by:geotiger
ID: 10805949
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
 
LVL 12

Author Comment

by:geotiger
ID: 10806697
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Creating SQL script using SQL data and SQL script 8 39
SQL: launch actions one before the other 10 23
SQL Server Designer 19 40
SSIS with VPN COnnection 2 75
I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question