Problems Shrinking Log File

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Problems Shrinking Log File

14 posts, Page 2 of 2

««1 2

Problems Shrinking Log File

Rate Topic

Display Mode

Topic Options

Author

Message

McSQL

Posted Thursday, November 08, 2012 4:24 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 4:06 AM
Points: 146, Visits: 281

Ah apologies, yes you're right, you would have to set RECOVERY to SIMPLE and then run the shrink commands in SQL 2008.
Forgot that this was a discountinued command in 2008 Tongue

Post #1382403

sanket kokane

Posted Thursday, November 08, 2012 4:29 AM

Old Hand

Group: General Forum Members
Last Login: Monday, June 10, 2013 11:13 PM
Points: 323, Visits: 972

McSQL (11/8/2012)

Ah apologies, yes you're right, you would have to set RECOVERY to SIMPLE and then run the shrink commands in SQL 2008.
Forgot that this was a discountinued command in 2008 Tongue

be aware about this . this can break LSN chain in log file

-----------------------------------------------------------------------------
संकेत कोकणे

Post #1382404

anthony.green

Posted Thursday, November 08, 2012 4:31 AM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 2:40 AM
Points: 5,075, Visits: 4,833

sanket kokane (11/8/2012)

McSQL (11/8/2012)

Ah apologies, yes you're right, you would have to set RECOVERY to SIMPLE and then run the shrink commands in SQL 2008.
Forgot that this was a discountinued command in 2008 Tongue

be aware about this . this can break LSN chain in log file

So does TRUNCATE_ONLY, should only ever use it if you dont care about recovery and if you dont care about recovery need to step back and decide if you actually need to be in the full or bulk logged recovery model.

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1382405

McSQL

Posted Thursday, November 08, 2012 4:36 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 4:06 AM
Points: 146, Visits: 281

Yeah they both do, and I only suggested it on the basis that the log file was at 50GB (from a standard 4GB), and therefore log shipping and log backups were unlikely to be taken, at least with any regularity.

The better option is to set up maintenance routines on your logs to prevent them getting to that size, but in the event you're not maintaining logs or are out of space, then it is an option to consider.

Post #1382411

« Prev Topic | Next Topic »

14 posts, Page 2 of 2

««1 2

Permissions