SQL 2000 database - How to shrink and what to expect.

Microsoft SQL 2000 database on Server 2003

My support people told me to "shrink my database".  I know how to perform this action but would like to know what to expect and what I should consider before doing this action as I have never done it on a live database.  I have only done this to static access databases.  I have 160G free on my server.

My database is currently 115G and should be around 30G.  My .ldf file ballooned from a normal of around 5G to 85G.  So I called the people who support the application which I am running and their support people said to shrink the database after a good backup.  My backup executed successfully last night.

1. Is shrinking a database this big going to eliminate access to the database for an extended period of time?
2. When I do shrink the database what options are recommended:
           Maximum free space in files after shrinking:  "default is 0%"
           Move pages to beginning of file before shrinking "unchecked"
           
3. Also is it recommended to leave the main database alone   .mdf and only shrink the .ldf file?
LVL 9
Sean MeyerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Aneesh RetnakaranDatabase AdministratorCommented:
it seems like you are not backing up the log files, this is really a mistake unless you are ready to face the conseqquences once your db/system crashes.  in order to reclaim the spaces, use

http://sqlserver2000.databases.aspfaq.com/how-do-i-reclaim-space-in-sql-server.html
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Sean MeyerAuthor Commented:
Thank you for that article!

Out of the 88G of space being allocated to the .ldf file only 320MB actually had data.

0
Aneesh RetnakaranDatabase AdministratorCommented:
Dont forgot to take regular backups of your Log
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2003

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.