March 13, 2012 at 11:53 am
Hi guys. I have been trying to take a maual bkp on the local drive. But the bkp terminated abruptly has the disk did not have enough space. The comand I ran was like this.
BACKUP DATABASE [Tab_NationalCofee] TO
DISK = 'F:\Star\PNTab_NationalCofee01.bak',
DISK = 'F:\Star\PNTab_NationalCofee01.bak'
WITH INIT , NOUNLOAD , NAME = 'Tab_NationalCofee03132012Backup', NOSKIP , STATS = 10, NOFORMAT
Now because it ended abruptly I just changed the drive name from 'F' to 'G' and reran the script. I did create a 'Star' folder in G too. But I get the following error.
Cannot open backup device 'G:\Star\PNTab_NationalCofee01.bak'.
Operating system error 32(The process cannot access the file because it is being used by another process.).
I dont understand whats causing the problem? Why is it not able to go to that drive? Does the previous back command though it ended is still using the backup set or something. I am confused. Any Ideas?
March 13, 2012 at 11:57 am
Not sure, but I think this part may be the problem:
DISK = 'F:\Star\PNTab_NationalCofee01.bak',
DISK = 'F:\Star\PNTab_NationalCofee01.bak'
I would think this wouldn't work as you are trying to strip the backup to the same file.
March 13, 2012 at 2:49 pm
Ohhh. How Silly Of Me. I am sry. That was my typo mistake.
Any Thank u guys
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply