Professional Web Applications Themes

Can not shrink a Database! - Microsoft SQL / MS SQL Server

Hi, I am running SQL 2K I have a DB that is 6GB. out of that, 5.5GB is the Trans Log. I did a backup of the Data and the log. Now it shows 5.3GB unused, but I cant get that free space to go away! When I creaded the DB it was 10MB? so I know that is not the problem any ideas??? thanks George....

  1. #1

    Default Can not shrink a Database!

    Hi,
    I am running SQL 2K
    I have a DB that is 6GB.
    out of that, 5.5GB is the Trans Log.
    I did a backup of the Data and the log.
    Now it shows 5.3GB unused, but I cant get that free space to go away!
    When I creaded the DB it was 10MB? so I know that is not the problem


    any ideas???

    thanks George.


    george Guest

  2. #2

    Default Re: Can not shrink a Database!

    George,

    A log backup wont shrink the files, it would just empty it.To shrink the
    files, use DBCC SHRINKFILE.More details here:

    INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
    http://support.microsoft.com/support/kb/Articles/q272/3/18.asp

    --
    Dinesh.
    SQL Server FAQ at
    http://www.tkdinesh.com

    "george d lake" <com> wrote in message
    news:phx.gbl... 


    Dinesh.T.K Guest

  3. #3

    Default Re: Can not shrink a Database!

    Ok,
    I ran this:
    DBCC SHRINKFILE(SystemMon_Log, 140)

    And got this:
    Cannot shrink log file 2 (SystemMon_Log) because all logical log files are
    in use.

    (1 row(s) affected)

    DBCC execution completed. If DBCC printed error messages, contact your
    system administrator.


    "Dinesh.T.K" <mail.tkdinesh.com> wrote in message
    news:phx.gbl... [/ref]
    away! 
    >
    >[/ref]


    george Guest

  4. #4

    Default Re: Can not shrink a Database!

    Ok.
    It worked!
    "Dinesh.T.K" <mail.tkdinesh.com> wrote in message
    news:phx.gbl... [/ref]
    away! 
    >
    >[/ref]


    george Guest

Similar Threads

  1. How to Shrink PDF Files?
    By Mandy_Roberts@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 3
    Last Post: August 1st, 09:10 AM
  2. Shrink to fit
    By drewp88 webforumsuser@macromedia.com in forum Macromedia Flash Sitedesign
    Replies: 5
    Last Post: January 29th, 08:31 PM
  3. How do I shrink tablespace?
    By Puneet in forum Oracle Server
    Replies: 1
    Last Post: October 16th, 05:44 AM
  4. shrink face
    By Mona_Richard@adobeforums.com in forum Adobe Photoshop Elements
    Replies: 12
    Last Post: October 16th, 12:20 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139