Hi everybody,
Before I re-invent the wheel... I was wondering if there were any documents already in existence that describe the optimal settings to use when defining a Maintenance Plan for the EPDM SQL Databases?
I have some customers complaining about the size of Transaction Logs and asking about Backup models, so thought that I would distribute a suggested Maintenance Plan to all my administrators (without prior SQL knowledge). There are a couple of Solutions on the KB which discuss managing existing Transaction Logs, but nothing definiate on creating a Maintenance Plan to take care of these (and other tasks) automatically
Kind regards
Wayne
You SHOULD have both daily and weekly backup/maintenance plans setup. If you don't, use the Wizard in SQK Server Management Studio.
The wizrd is good BUT the wizard doesn't have options to truncate/shrink transaction logs.
You'll need to create your own Maintenance Plan using your own T-SQL statements
I use the T_SQL statement:
As far as schedulng the task, you'll need to adjust the frequency accordingly. I do it weekly.