2 Replies Latest reply on Oct 8, 2009 11:23 AM by Richie Yosten

Does anybody have a definitive recomendation for a SQL Maintenance plan for EPDM

1-ALSL9H Oct 6, 2009 4:20 AM

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

Re: Does anybody have a definitive recomendation for a SQL Maintenance plan for EPDM

1-DPNRTK Oct 8, 2009 1:42 AM (in response to 1-ALSL9H)
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:

DBCC SHRINKFILE (<Logfile>, <target_size_in_MB>);

As far as schedulng the task, you'll need to adjust the frequency accordingly. I do it weekly.
Like Show 0 Likes(0)

Actions
- Re: Does anybody have a definitive recomendation for a SQL Maintenance plan for EPDM
  
  Richie Yosten Oct 8, 2009 11:23 AM (in response to 1-DPNRTK)
  
  I have 2 subplans in my PDM maint plan as well.
  
  Daily Backup
  Weekly Index Rebuild/Reorg, Shrink DB
  
  I haven't seen our logs get out of control since PDME 2007 but it's not a bad idea to shrink those as well. When we upgraded from 2007 to 2009 we saw that our log for our vault db was insanely huge. I think after the upgrade we ran a script like that once and all has been well since.
  
  Like Show 0 Likes(0)
  
  Actions

Go to original post