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