Mahesh .NET Blog
Wednesday, December 31, 2008
Cleaning the Transaction Logs in SQL Server2005
To Back up the transaction log file :
BACKUP LOG
TO DISK = '
'
Eg.
BACKUP LOG TestDB TO DISK='C:\TestDB1.bak'
To Shrink the transaction log file:
DBCC SHRINKFILE (
,
) WITH NO_INFOMSGS
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment