Huge SQL Server 2003 mdf and ldf files

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

Huge SQL Server 2003 mdf and ldf files

Author

Topic

englishw
Starting Member

1 Post

Posted - 2009-10-30 : 18:52:27

I'm new and inexperienced with SQL admin and I am attempting to manage an SQL Server 2003 database that has been growing. I have been deleting old data, but that actually makes the database sizes go up, not down, so I am a little confused. My MDF is currently 10GB and the LDF is just over 60GB. Two weeks ago they were 8GB and 50GB. I am running out of room on the disk that the database files are on and am looking at my options. I could add more storage, but I would rather get it down to a manageable size. I'm sure there is room to shrink this beast in size, but I'm clueless where to start.

Any help is greatly appreciated! Thanks!

-Bill

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-10-30 : 19:40:15

You are probably using FULL recovery model and not backing up your transaction log. Either switch to SIMPLE or start backing up your transaction log on a regular basis. We backup ours every 15 minutes.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-11-02 : 01:22:56

Take a look through this article - [url]http://www.sqlservercentral.com/articles/64582/[/url]

p.s. there is no SQL server 2003. The versions for SQL are SQL Server 2000, SQL Server 2005 and SQL Server 2008.

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources