Christopher,
Find the below mentioned steps.
1) Take full backup of the database
2) Change the recovery model to simple
3) Truncate the log file
4) Shrink the log file using EM or QA
5) Then change the recovery model back to full
This will solve your problem
________________________________________________________________________
_
Thanks & Regards
Prabhu Sundaram
MSSQL Database Administrator
Nuware Technologies | MSSQL Database Services
Phone : 91 80 41247998, 91 80 41239585
Mobile: +919900521990 prabhu.[Email address protected]
________________________________________________________________________
_
-----Original Message-----
From: Bellizzi Christopher J
[mailto:mssqldba-ezmlmshield-x71997961.[Email address protected]
Sent: Wednesday, August 29, 2007 5:45 PM
To: LazyDBA Discussion
Subject: RE: Shrink my log file!!
I guess I am confused with this one.
Your setting it to simple.
Your restricting the log file growth.
Your setting the DB option to the check point.
Wouldn't the db_option set the database to "simple" with this command?
Aren't you going to need to set the database back to "Full"?
PAYCHEX
Christopher Bellizzi
Information Technology * Database Administration
675 Basket Road * Webster, New York 14580
(585) 216-0670 * [Email address protected]
-----Original Message-----
From: RAMAKRISHNAN Sudharshan Pedhamas
[mailto:mssqldba-ezmlmshield-x73146992.[Email address protected]
Sent: Wednesday, August 29, 2007 4:56 AM
To: LazyDBA Discussion
Subject: RE: Shrink my log file!!
Hi
1/ Set the recovery model to Simple.
2/ Restrict the File growth for Log file. Don't allow unlimited
growth.
3/ Set this db option:
SP_DBOPTION <database>, 'trunc. log on chkpt.', 'true'
Regards
Sudharshan PR
Administrator - MSSQL | Covansys India, | www.covansys.com E-mail:
[Email address protected] | India: +91 - 44 - 22623880, 22628080 x 6260
| Mobile: +91 - 9884044200
-----Original Message-----
From: Dan Guzman
[mailto:mssqldba-ezmlmshield-x29018599.[Email address protected]
Sent: Wednesday, August 29, 2007 3:34 AM
To: LazyDBA Discussion
Subject: Shrink my log file!!
Ive tried full backups, then log backups, then full backups again. I've
tried Shrink files on the data and on the log file, nothing seems to
shrink this file. It's a 6 Meg database, with an 8 gig log file. I
would like to do this properly, so please, any suggests would be
helpful.
Dan
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Confidentiality Statement:
This message is intended only for the individual or entity to which it
is addressed. It may contain privileged, confidential information which
is exempt from disclosure under applicable laws. If you are not the
intended recipient, please note that you are strictly prohibited from
disseminating or distributing this information (other than to the
intended recipient) or copying this information. If you have received
this communication in error, please notify us immediately by return
email.
-----------------------------
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-----------------------------------------
The information contained in this message may be privileged,
confidential, and protected from disclosure. If the reader of this
message is not the intended recipient, or any employee or agent
responsible for delivering this message to the intended recipient,
you are hereby notified that any dissemination, distribution, or
copying of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately
by replying to the message and deleting it from your computer.
Thank you. Paychex, Inc.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page