Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Posts
    1

    Post Unanswered: Compressing SQL Server Database

    Newbie - SQL 2000. I have a database file 150 MB and my log file is 400 MB. Is there anyway I can compress the size of these files.

    Thanks,

  2. #2
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185

    You can do this..

    If you don't need to take the backup of the Transaction Log:::

    Take the full database backup(Recommended not Reqd)

    go to Query Analyzer and
    use [your database]
    backup TRAN [your dbname] with no_log

    once it's over then you can run:

    dbcc SHRINKFILE([YOUR DBNAME_LOGFILENAME,TRUNCATEONLY)

    and it will reduce the size of the Transaction Log

Posting Permissions

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