Results 1 to 8 of 8
  1. #1
    Join Date
    Feb 2004
    Location
    Poland
    Posts
    96

    Unanswered: no place on disk

    I have one big db and i heve no place on disk
    the log file is big too. how can i delete the log

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    Quote Originally Posted by rafala
    I have one big db and i heve no place on disk
    the log file is big too. how can i delete the log
    to delete the log :
    1)Detach the database
    2)Delete the log file
    3) Attach the database again

    or
    use dbcc shrink file to shrink the file.
    or
    to increase the space u can also consider adding new filegroup on other disk.

  3. #3
    Join Date
    Feb 2004
    Location
    Poland
    Posts
    96
    Thanks. it's what I was looking for

  4. #4
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    be sure to take a backup before you do a detach and attatch ....
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  5. #5
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    Quote Originally Posted by Enigma
    be sure to take a backup before you do a detach and attatch ....
    OOps sorry forgot to mention that , but that should be by default isnt it

    1)Backup database
    2)detach database
    3) delete log
    4) attach database

  6. #6
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    but how will this guy take a backup if he is out of space ;D ... hope he has a tape drive ...
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  7. #7
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    Quote Originally Posted by Enigma
    but how will this guy take a backup if he is out of space ;D ... hope he has a tape drive ...
    Hope so ...
    or there are other two options

  8. #8
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Well .. i would recommend ...
    Code:
    use dbname
    backup log dbname with no_log
    Then do a dbcc shrinkfile. You forgot to mention the solution about adding new HDDs ...
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •