dnncleandblogsched

Rating: No reviews yet
Downloads: 97
Released: Dec 6, 2012
Updated: Dec 6, 2012 by tiram
Dev status: Stable Help Icon

Downloads

Application dnncleandblogsched
application, 3K, uploaded Dec 6, 2012 - 97 downloads

Release Notes

This release uses the commands:
ALTER DATABASE thisDBname SET RECOVERY simple; --To change the recovery model
dbcc shrinkdatabase (thisDBname, TRUNCATEONLY); -- shrink database
TRUNCATE TABLE eventlog; -- clean eventlog table
TRUNCATE TABLE sitelog; -- clean sitelog
DBCC SHRINKDATABASE (thisDBname]);

Reviews for this release

No reviews yet for this release.