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 |
|
kbk
Starting Member
34 Posts |
 Posted - 2009-05-26 : 10:29:02
|
| Hi Alli have an issue here...One of my drives(disk partition) have only backup files,both full backup files and log backups. (the backups are stored here )I get disk space issues very frequently.It reaches upto 80%,90% during backup time.however it isnt at a constant or increasing rate.Two days back i got 93% disk space occupied during backup time and yestdray ,only 81%.The backup files' size keeeps increasing,then how is it that the percentage goes down & up ,and not a linear growth? Can anyone advise me on this? Why does it happen so?and what is the resolution?All suggestions are welcome..ThankyouPVK |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2009-05-27 : 23:53:49
|
| The size of the log file backups could vary greatly from day to day. The logs basically reflect how busy the database has been - so on a day when there was less activity they could be much smaller than a day when there was a lot of activity. The full backups should be more constant, slowly growing larger as the amount of data increases. |
 |
|
|
|
|
|
DRIVE SPACE DURING BACKUPS