[ODBC SQL Server Driver][SQL Server]Cannot open backup device

[DH1982]

Morning,

I have a strange problem when trying to backup up a SQL database through our software.
Its the MSDE version of SQL 2000 which is installed by default when our software is installed.

When running the backup routine and pointing the path to a UNC path it backs up fine. i.e \\server\SQL Backup\DATA\...

Try saving it to a Mapped drive which points to the same location i.e z:\DATA\.... and i get the following.

Exception Information:
OS Version: Microsoft Windows NT 5.1.2600.0

ExceptionManager.MachineName: DSK00159
ExceptionManager.TimeStamp: 29/08/2007 12:44:28
ExceptionManager.FullName: Sys_ExceptionManagement, Version=1.0.107.0, Culture=neutral, PublicKeyToken=null
ExceptionManager.AppDomainName: ApplicationFrame.exe
ExceptionManager.ThreadIdentity:
ExceptionManager.WindowsIdentity: **************
System.Runtime.InteropServices.COMException (0x80040C81): [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device 'FNETMainBackupDevice'. Device error or device off-line. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.
at SQLDMO.BackupClass.SQLBackup(_SQLServer ServerObject)
at FNET.CommonUtilities.DatabaseFunctions.BackUpDatabase(String _sDatabaseName, String _sDatabaseLocation, String _sServerName, String _sUserName, String _sPassword)


Can anyone advise what the issue maybe ?

Thanks in advance

 

[mrdenny]

It is recommended that you do not use a mapped drive to backup to and instead backup to the network share. The reason for this is that you mapped the drive in your session, not in the SQL Servers session.

Not to mention that there is no way to guarantee that the drive letter you are using for a mapped drive will never be changed by anyone.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com