ALTER DATABASE <db name> SET RECOVERY SIMPLE
DBCC SHRINKFILE(dblognamenotpath_log)
ALTER DATABASE <db name> SET RECOVERY FULL
db log name is from db properties – it is not path and not file name
or run full SQL backup
run SQL T log backup
ALTER DATABASE <db name> SET RECOVERY SIMPLE
DBCC SHRINKFILE(dblognamenotpath_log)
ALTER DATABASE <db name> SET RECOVERY FULL
db log name is from db properties – it is not path and not file name
or run full SQL backup
run SQL T log backup
0 Comments.