ALTER DATABASE [db name] SET RECOVERY SIMPLE GO DBCC SHRINKFILE('log_file_name.ldf', 100)--whatever size you need in MB's GO ALTER DATABASE [db name] SET RECOVERY FULL
To Find Log file name use below T-SQLuse [db name] GO select name as [log_file_name] from sys.database_files
where [type_desc] = 'LOG'
No comments:
Post a Comment