Post reply

Disk Space

  • March 6, 2006 at 5:26 am

    #93432

    Hi ,

       Can any one help that if the disk is full how to shrink the disk.I mean which files we have to delete? Please tell me the best steps.....

     

     

    Thanks,

    Aregaddan.

     

  • March 6, 2006 at 6:56 am

    #624859

    Do you mean shrink the database to make more disk space avalible ?

  • March 6, 2006 at 9:51 am

    #624956

    If you're talking about the SQL data disk, step one is to delete the sample databases: pubs and northwind for 2000.  Make sure to delete the data files after you delete them with Enterprise Manager. 

    There are lots of other things that can be moved or removed to save space.  Be more specific with your question, and you'll get a better answer.

    So long, and thanks for all the fish,

    Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3

  • March 6, 2006 at 10:42 am

    #624968

    I agree, we need better information from you. But since you ARE posting on a SQL Server forum, I'm guessing your database files grew too large.

    Basic question: are you backing up your databases? If not, right there is a problem - you should be doing Full backups and if your database is in Full recovery mode, you should be also doing Log backups.

    -SQLBill

  • March 6, 2006 at 9:30 pm

    #625104

    Thanks for the reply to all.....

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

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