Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Clearing/Releasing data files Expand / Collapse
Author
Message
Posted Thursday, February 19, 2009 1:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 26, 2009 3:04 AM
Points: 2, Visits: 16
I recently installed SQL Server 2005 on a new machine. It all appears fine. I ran a large job and the job caused the following files dbname_SHOP_AREA, db_name_LOG1, db_name_LOG2 and db_name_LOG3 to be approx 40Gb in size. How do I clear these down? Is there a setting I have missed in install? or is this a manual task?

As the next time I run a job it uses up all remaining memory on the machine, so I would like this to free itself after each job completion, is this possible?

Thanks in advance.
Post #660111
Posted Thursday, February 19, 2009 6:44 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 11:13 AM
Points: 15,527, Visits: 27,909
It sounds like the database is in FULL recovery mode. So you need to institute log backups. Depending on your data needs, you could set the database to SIMPLE recovery mode and then you wouldn't need the log backups, but you also wouldn't be able to recover to a point in time. After a log backup is completed, you should be able to shrink the files.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #660246
Posted Thursday, February 19, 2009 8:08 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 11:54 AM
Points: 42,466, Visits: 35,530
Please read through this - Managing Transaction Logs


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #660378
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse