How to Shrink SQL Server database log files?

Huisheng Chen

Rate me:

0.00/5 (No votes)

8 Feb 2010CPOL

9.3K

DUMP TRANSACTION FooDB WITH NO_LOGBACKUP LOG FooDB WITH NO_LOGDBCC SHRINKDATABASE(FooDB)EXEC sp_dboption 'FooDB', 'autoshrink', 'TRUE'

Views

Daily Counts

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Huisheng Chen

Product Manager www.xnlab.com

Australia

I was born in the south of China, started to write GWBASIC code since 1993 when I was 13 years old, with professional .net(c#) and vb, founder of www.xnlab.com

Now I am living in Sydney, Australia.

How to Shrink SQL Server database log files?

Views

License

Comments and Discussions