skip to main
|
skip to sidebar
ActiveInfo
Sunday, March 21, 2010
Shrinking Log File for SQL Server
DBCC SHRINKFILE(
{Database Name}
_log, 1)
BACKUP LOG
{Database Name}
WITH TRUNCATE_ONLY
DBCC SHRINKFILE(
{Database Name}
_log, 1)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Blog Archive
▼
2010
(2)
►
April
(1)
▼
March
(1)
Shrinking Log File for SQL Server
►
2009
(12)
►
May
(6)
►
April
(2)
►
March
(3)
►
February
(1)
►
2008
(11)
►
December
(3)
►
October
(5)
►
September
(1)
►
February
(2)
►
2007
(1)
►
May
(1)
Contributors
Ofer Narkis
Ofer Narkis
No comments:
Post a Comment