|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Thursday, July 02, 2009 6:59 AM
Points: 3,
Visits: 3
|
|
Hi,
I have connected an external harddisk to my DB server and named it I:\. Then I created a backup device in SQL Server 2005 and pointed it to I:\Backup. I scheduled DB backup and gave the above mentioned device name.
Now I'm getting the following error:
System.Data.SqlClient.SqlError: Cannot open backup device 'SAPBACKUP_DISK(I:\Backup\SAPBACKUP_DISK.bak)'. Operating system error 32(The process cannot access the file because it is being used by another process.). (Microsoft.SqlServer.Smo).
Kindly help....
Regards,
Sriram
|
|
|
|
|
SSCommitted
Group: General Forum Members
Last Login: 2 days ago @ 5:41 AM
Points: 1,698,
Visits: 2,267
|
|
are you able to access the disk through windows?
also can u fire backup manually?
backup database yourdatabase to disk='I:\Backup\SAPBACKUP_DISK.bak'
Pradeep Singh
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Thursday, July 02, 2009 6:59 AM
Points: 3,
Visits: 3
|
|
Hi,
Thanks for your reply. If I try to take backup with SQL command then I get the error. If I take backup by right clicking on the database and click on task->backup then I'm able to take the backup.
|
|
|
|
|
SSCommitted
Group: General Forum Members
Last Login: 2 days ago @ 5:41 AM
Points: 1,698,
Visits: 2,267
|
|
This is unusual. Can you click on the script button at the top of the backup window in SSMS? and see the difference between the script SSMS is using and your script.
Pradeep Singh
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Thursday, July 02, 2009 6:59 AM
Points: 3,
Visits: 3
|
|
| Sorry....I did a mistake. I'm able to take backup with sql command also.
|
|
|
|
