Friday, 31 January 2014

Reduce Shareweddb_log file size

Use SQL Management Studio & connect to ##SSEE database

Choose the ShareWebDB

New query & run below to reduce log file size

USE ShareWebDb
 GO
 DBCC SHRINKFILE(ShareWebDb_log, 1)
 BACKUP LOG ShareWebDb WITH TRUNCATE_ONLY
 DBCC SHRINKFILE(ShareWebDb_log, 1)
 GO

No comments:

Post a Comment