June 16, 2011 at 3:30 am
Hi to all,
Contineously i m getting the backup failed error in my sql server error log on my production server. I check space of the backup drive there is a more sapce. My backup log shows me to check the command, the command which i using to take the backup of my db that is as follows,
BACKUP DATABASE [dbname] TO DISK = N'E:\\PP\\Jobs\\db\\dbname_backup.bak' WITH NOFORMAT, NOINIT, NAME = N'dbname_backup', SKIP, REWIND, NOUNLOAD, STATS = 10
Error:
Write on "E:\\PP\\Jobs\\db\\dbname.bak" failed: 112(error not found)
Error No's are:
===========
Error: 3041
Error: 18210
please can any one help out by this problem..
Thanks in advance.
M.I.
________________________________________
M.I.
[font="Times New Roman"]
June 16, 2011 at 3:57 am
I think there is a problem in that extra \. See below.
N'E:\\PP\\Jobs\\db\\dbname_backup.bak'
M&M
June 16, 2011 at 3:59 am
Change it to N'E:\PP\Jobs\db\dbname_backup.bak'
See if those folders exist in the E drive.
M&M
June 16, 2011 at 4:04 am
I don't think the double \ causes any issues.
Error:
Write on "E:\\PP\\Jobs\\db\\dbname.bak" failed: 112(error not found)
Are you sure you have enough space on the drive? net helpmsg 112 shows the error as "There is not enough space on the disk"
June 16, 2011 at 4:10 am
I checked there is no problem with // slash and also i checked to run this command manually. Its working fine but when its running in schedule its genrate an error message which i write above.
And there is engouh space on the disk. I checked all the posibilites which cause the backup.
1) Its not a network drive so there is no issue of network.
2) I also check the space on the drive i.e also no problem.
3) I checked the query of the backup that is also working if i run it manually.
Is there any othere problem which may i have not checked?
Regards,
M.I.
________________________________________
M.I.
[font="Times New Roman"]
June 16, 2011 at 5:25 am
Has the backup device been created?
People who use third party tools or the GUI tend to forget that the T-SQL backup commands need that extra step.
June 16, 2011 at 5:26 am
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply