Running out of free space in T:\drive

Question

Running out of free space in T:\drive

stockholm

Default port

Points: 1468
More actions
June 23, 2011 at 3:16 am

#389827

Hi,
Today I’ve noticed that drive with Logs for several databases is running out of free space. I’ve made some investigation and found that logs of 8 databases are being backuped on this drive. That backups take much of space and databases have no space to write their logs.
I have always issue with running out of FREE SPACE, which or what is best solution to avoid future error message.
Thnx
Kahn

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 1

Kahn

Back up to a separate drive, across the network to a separate server, or direct to tape - whichever works best for you. But don't have your backups on the same drive as your data files. Not only will you run into space issues like that, but if the drive fails, you lose your database and your backups. Try explaining that to the boss!

John

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 2

Is T a logical or physical drive? Is it a SAN? Can you add more space to it without having to move anything?

I'm assuming from your description that you only have log files on this drive. Is that correct or is John correct about you having database files there too?

EDIT: He's right that the backups should be sent to another drive, too.

You could add another drive and split the log files between the two drives. Take databases 1-5 offline, move the log files to the new drive, then bring the databases online with an ALTER DATABASE statement to point to the new location (I advise backing up the DBs & Logs before this).

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 3

Brandie Tarvin (6/23/2011)
I'm assuming from your description that you only have log files on this drive. Is that correct or is John correct about you having database files there too?

Sorry, Brandie - that's my lazy notation. I said data files when I meant to say database log files.

John

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 4

John Mitchell-245523 (6/23/2011)
Kahn
Back up to a separate drive, across the network to a separate server, or direct to tape - whichever works best for you. But don't have your backups on the same drive as your data files. Not only will you run into space issues like that, but if the drive fails, you lose your database and your backups. Try explaining that to the boss!
John

Good point. You will also notice fragmentation on the drive that you backup to.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/