Post reply

Running out of free space in T:\drive

  • 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

  • June 23, 2011 at 3:25 am

    #1342887

    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

  • June 23, 2011 at 7:09 am

    #1343003

    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.

  • June 23, 2011 at 7:13 am

    #1343008

    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

  • June 26, 2011 at 12:21 pm

    #1344233

    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/

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

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