Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amerms
Starting Member
2 Posts |
 Posted - 2005-11-19 : 02:33:43
|
| i have maintenance plan with full db backup everyday.. backup file is overridden everyday by the new backupsuppose i have 100 GB hard disk space and db backup file size is 65 GB then free space is 35 GB...but quite often backup fail with msg " BackupMedium::ReportIoError: write failure on backup device 'G:\abc.BAK. Operating system error 112(There is not enough space on the disk.)."what i suspect is that during the process of creating backup which also overwrites the existing backup file, the system uses some hard disk space temporarily which is apart from actual backup file size..can anybody explain about this problem and how to solve it..Thanks in advance .Smile ... it increases your face value ! |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-11-19 : 02:44:23
|
| A maintenance plan does not overwrite the old backup file. It creates a new backup file, and then deletes the old backup file after creating the new one. It needs enough space for 2 backups files bacause of this. This is the safe way to do backups, because you always have a backup file on disk.The solution is to make sure you have enough disk space for 2 backup files.CODO ERGO SUM |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-20 : 02:48:10
|
| Reminds me of the story of a client, many many years ago.They had two backup tapes. Each morning the operator took the completed tape out of the tape drive, and then formatted the second tape ready for the backup the following night ...amerns:Is the folder you BACKUP to "compressed"? That would give you some extra space (we do that here and my backup folder says "10GB files, Size on disk=4.5GB").Note that there are articles which say you should not do this, but I struggle to see why, and I've been doing it for many years without problems - yet!Make sure only the folder that the backups go to is compressed - you don't want to compress the folder the data/log files are in, that's for sure!Kristen |
|
|
|
|
|
|
full backup with overwriting previous backup file