Results 1 to 4 of 4

Thread: [RESOLVED] SQL Server 2005 Enterprise Shrink DB

  1. Jan 22nd, 2009, 12:55 PM #1
    GaryMazzone
    GaryMazzone is offline

    Thread Starter
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,493

    Resolved [RESOLVED] SQL Server 2005 Enterprise Shrink DB

    Does anyone have a good script to shrink a SQL 2005 database to a size (or % free space) that you set?


    I now there is DBCC Shrinkdatabase. That is not shrinking the size down.

    Thanks
    Gary
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1
    Reply With Quote Reply With Quote
  2. Jan 22nd, 2009, 01:52 PM #2
    dee-u
    dee-u is offline
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,127

    Re: SQL Server 2005 Enterprise Shrink DB

    How about the Management Studio?
    Regards,

    ™

    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system
    Reply With Quote Reply With Quote
  3. Jan 22nd, 2009, 02:01 PM #3
    GaryMazzone
    GaryMazzone is offline

    Thread Starter
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,493

    Re: SQL Server 2005 Enterprise Shrink DB

    I need to do this in code. We are mograting some systems and pulling some data from one db to another (al scripted) and I want to include a script to shrink the databases on completion of restore and conversion/migration.
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1
    Reply With Quote Reply With Quote
  4. Jan 27th, 2009, 08:26 AM #4
    GaryMazzone
    GaryMazzone is offline

    Thread Starter
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,493

    Re: SQL Server 2005 Enterprise Shrink DB

    Found the answer and script in is this thread:

    http://www.vbforums.com/showthread.php?t=554905
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width