Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DarioLMou
Starting Member
3 Posts |
 Posted - 2012-01-20 : 05:40:48
|
| Hi Guys,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.Any help will be appreciated.ThanksDario |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-01-20 : 05:55:04
|
quote:
Originally posted by DarioLMou
Hi Guys,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.ThanksDario
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
Andrewpaul
Starting Member
1 Post |
Posted - 2012-02-19 : 14:55:26
|
| 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 share2. After that you should be able to backup using the mapped drive letter3. Your Management Studio Object Explorer logical drive enumeration window should be able to list the above mapped drive[url]http://www.techyv.com/questions/cannot-run-database-server-works-fine-local-disk[/url] |
|
|
|
|
|
|
Database Backup failing