Some notes on software development... RSS 2.0
# Tuesday, 29 October 2013

I always forget the exact sql server commands for shrinking a transaction log file so, thanks to Pinal Dave, here they are:

USE DatabaseName
GO
DBCC SHRINKFILE(<TransactionLogName>, 1)
BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(<TransactionLogName>, 1)
GO

Links
Pinal Dave - SQL SERVER – Shrinking Truncate Log File – Log Full

Tuesday, 29 October 2013 17:54:04 (GMT Standard Time, UTC+00:00)  #    -
SQL Server
Navigation

Sign In
Extras
Statistics
Total Posts: 116
This Year: 0
This Month: 0
This Week: 0
Comments: 36
About the author/Disclaimer

Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

© Copyright 2017
Hadrian Phillips

All Content © 2017, Hadrian Phillips
DasBlog theme 'Business' created by Christoph De Baene (delarou)