Tuesday, July 10, 2012


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