Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / DB Engine / SQL Server / March 2008

Tip: Looking for answers? Try searching our database.

Maintenance Plans

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Robert - 01 Mar 2008 15:27 GMT
We just started using DPM 2007 to backup our 2005 DB's so I am deleting the
backups in the maintenance plans. Should I go back in and have any regular
maintenance on DB's like Shrink or Reorganize or is just backing up using DPM
ok?
Andrew J. Kelly - 01 Mar 2008 15:44 GMT
DPM only does backups and AFAIK it also takes care of the retention period
as well. But it does not handle any other routine database functions such as
CHECKDB's, Reindexing etc. so you still have to do that yourself. And
shrinking should not be one of them.
http://www.karaszi.com/SQLServer/info_dont_shrink.asp

Signature

Andrew J. Kelly    SQL MVP
Solid Quality Mentors

> We just started using DPM 2007 to backup our 2005 DB's so I am deleting
> the
> backups in the maintenance plans. Should I go back in and have any regular
> maintenance on DB's like Shrink or Reorganize or is just backing up using
> DPM
> ok?
Robert - 01 Mar 2008 16:13 GMT
Thanks Andrew. What is typical for a maintenance plan, there are many options
in the Admin. Studio.

I just set one up to:
Check Integrity
Reorg Index
Update Stats
Clean up history
Maintenance Cleanup

> DPM only does backups and AFAIK it also takes care of the retention period
> as well. But it does not handle any other routine database functions such as
[quoted text clipped - 8 lines]
> > DPM
> > ok?
Tibor Karaszi - 01 Mar 2008 18:41 GMT
By understanding what each option do, you can decide which options are suitable for a particular
installation.

For instance, Maint Cleanup can be critical if you also do backup and don't have other means to
remove old backup files.

Or, Reorg can be important to reduce fragmentation, but since the maint plan's reorg is stupid and
don't take into account initial fragmentation one might want to skip this step and do it yourself
(smarter). Or perhaps not at all, if fragmentation don't cost you.

etc...
Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

> Thanks Andrew. What is typical for a maintenance plan, there are many options
> in the Admin. Studio.
[quoted text clipped - 18 lines]
>> > DPM
>> > ok?
Robert - 02 Mar 2008 16:10 GMT
Thanks Tibor. I will get to reading to better understand what each does.

> By understanding what each option do, you can decide which options are suitable for a particular
> installation.
[quoted text clipped - 29 lines]
> >> > DPM
> >> > ok?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.