February 14, 2009 at 10:13 am
Hi
With one of my backup jobs , i am taking the backup of one db and i have scheduled one window job to zip the backup file then . I saw my compression step was getting hanged , so i killed the RAR process and now when i am trying to create the backup file i am getting on error :
Operating system error : 32( The process cannot access the file because it is being used by some another process)
I have checked open files also to ensure that there is no process runing
Please advise.
February 14, 2009 at 10:21 am
I believe still your backup file is in use
1) Try to take the backup to different location to make sure there is no problem from sql server side.
2) Delete the old backup file or try to move to different location and start the backup.
2) If it is a test server reboot the machine and try.
Rajesh Kasturi
February 14, 2009 at 10:37 am
There is no space on the server to take backup. Moreover its a prodcutin server , so restart is not permitted
February 16, 2009 at 4:36 am
Do you see any win rar process exe under Task manager-->Processes-->Image Name column? If yes, then kill it and you will get your file freed from zip process(make sure there isn't anything using zip software on the server).
MJ
February 16, 2009 at 5:49 am
Hi,
Why you are using winrar or any other zipping software to zip the backup files. Its better to go with lite speed. I had seen that it had reduced a 150GB database to 45GB where as native backup is around 130GB.
Thanks
Chandra Mohan N
[font="Verdana"]Thanks
Chandra Mohan[/font]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply