March 15, 2012 at 1:50 pm
my backup job is running everyday but, from the past 2 days it is failing due to :
18210 :
BackupMedium::ReportIoError: write failure on backup device 'D:\SQLServer\MSSQL\BACKUP\TPO_ProdData\TPO_ProdData_db_201203150030.BAK'. Operating system error 112(There is not enough space on the disk.).
but , I am having 48g of free space on the drive & database size is 12g. the database is in simple recovery model. the job is scheduled to run at 12:00AM it is failing from the past 2 days. but when I ran it completed sucessfully. I have checked the drive is NTFS.
can you please any one let me know what the issue.
Thanks
March 15, 2012 at 2:05 pm
backups and databases on the same drive?
got other processes which are running around the same time which could cause file growth and shrinking? Index rebuild for example or if tempdb is on the d drive massive reports running sorting loads of data?
March 15, 2012 at 5:02 pm
kodalisridevi (3/15/2012)
my backup job is running everyday but, from the past 2 days it is failing due to :18210 :
BackupMedium::ReportIoError: write failure on backup device 'D:\SQLServer\MSSQL\BACKUP\TPO_ProdData\TPO_ProdData_db_201203150030.BAK'. Operating system error 112(There is not enough space on the disk.).
but , I am having 48g of free space on the drive & database size is 12g. the database is in simple recovery model. the job is scheduled to run at 12:00AM it is failing from the past 2 days. but when I ran it completed sucessfully. I have checked the drive is NTFS.
can you please any one let me know what the issue.
Thanks
At the time when the backup ran and failed the disk space was insufficient. It is possible that post the failure event space was freed so when you come along to check you don't see a problem.
Can you supply a little more info on your disk setups, namely locations of the various files (data, log, backups), also how many other databases are backed up in the same job?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 15, 2012 at 6:27 pm
only one database is being backed up in the job. data, log files and backup files are stored on the same device and no other process is running at the same time.
March 15, 2012 at 11:26 pm
kodalisridevi (3/15/2012)
.. data, log files and backup files are stored on the same device...
Data, log and backup files should be on different drvices from performance and DR point of view.
March 16, 2012 at 1:25 am
Is backup done via a script or a maintenance plan
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 16, 2012 at 7:35 am
It is done through a maintence plan.
March 18, 2012 at 3:01 am
Can you post a screenshot of the plan
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply