Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Could not back up to a remote drive in maintenance plan

Posted on 2004-04-06
3
Medium Priority
?
1,858 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 1000 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

810 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