GO
DBCC SHRINKFILE(SAVEERP_Log, 1)
BACKUP LOG SaveERP WITH TRUNCATE_ONLY
DBCC SHRINKFILE(SAVEERP_Log, 1)
GO
use SAVEERP
--Delete data log
Alter database SAVEERP set recovery SIMPLE
DBCC SHRINKFILE ( SAVEERP,TRUNCATEONLY)
--To Clear Cached plan
DBCC FREEPROCCACHE
--TO Clear Buffer from Buffer Pool
DBCC DROPCLEANBUFFERS
No comments:
Post a Comment