Results in logs that are to big. Changed the recovery model to simple and executed the following to truncated the log
USE vcms_nieuw
GO
DBCC SHRINKFILE("logicalname_log", 1)
BACKUP LOG vcms_nieuw WITH TRUNCATE_ONLY
DBCC SHRINKFILE("logicalname_log", 1)
GO
This cleaned up the logs. Waiting for the backup guys to take it over from here :)
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.