I have a maintenance plan in place to backup daily. The backups are meant to be done on an external hard drive(format NTFS), but this is failing every time with teh following error: [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally. Could not create a sub directory for database The_Tsogo_CO. The parent directory will be used instead.[2] Database The_Tsogo_CO: Database Backup... Destination: [O:\NewSAPBackup\The_Tsogo_CO_db_201201201230.BAK] [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device 'O:\NewSAPBackup\The_Tsogo_CO_db_201201201230.BAK'. 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.
When I change the plan to backup on the local disk it works fine.
I need the external as we are running out of space on the local disk.
I have a maintenance plan in place to backup daily. The backups are meant to be done on an external hard drive(format NTFS), but this is failing every time with teh following error: [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally. Could not create a sub directory for database The_Tsogo_CO. The parent directory will be used instead.[2] Database The_Tsogo_CO: Database Backup... Destination: [O:\NewSAPBackup\The_Tsogo_CO_db_201201201230.BAK] [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device 'O:\NewSAPBackup\The_Tsogo_CO_db_201201201230.BAK'. Device error or device off-line. See the SQL Server error log for more details.maybe that helps? [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.
When I change the plan to backup on the local disk it works fine.
I need the external as we are running out of space on the local disk.
Any help will be appreciated.
Thanks Dario
No, you're never too old to Yak'n'Roll if you're too young to die.
For Creating backup a SQL Server database to a mapped drive using a local drive letter you have the following options: 1. Run the following command from a query window EXEC xp_cmdshell 'net use <drivename> <share name>' -- where <drive name>: Letter used to map the drive <share name>: UNC path to the share 2. After that you should be able to backup using the mapped drive letter 3. Your Management Studio Object Explorer logical drive enumeration window should be able to list the above mapped drive http://www.techyv.com/questions/cannot-run-database-server-works-fine-local-disk
Database Backup failing
Posted - 01/20/2012 : 05:40:48
