Post reply

Backup and restore in SQL Server 2005

  • July 2, 2009 at 5:55 am

    #206545

    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

  • July 2, 2009 at 6:12 am

    #1019070

    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

  • July 2, 2009 at 6:29 am

    #1019079

    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.

  • July 2, 2009 at 6:32 am

    #1019082

    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

  • July 2, 2009 at 7:00 am

    #1019102

    Sorry....I did a mistake. I'm able to take backup with sql command also.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply