Method 1
ALTER DATABASE DatabaseName SET RECOVERY SIMPLE
use DatabaseName
GO
CHECKPOINT
GO
DBCC SHRINKFILE(transactionloglogicalfilename,TRUNCATEONLY)
GO
ALTER DATABASE DatabaseName SET RECOVERY FULL
Method 2
USE DatabaseName
GO
ABCC SHRINKFILE(
BACKUP LOG
ABCC SHRINKFILE(
GO
No comments:
Post a Comment