Recomendations before/after creating MP's

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

High Availability (2005)

Recomendations before/after creating MP's

Author

Topic

sponguru_dba
Yak Posting Veteran

93 Posts

Posted - 2010-07-27 : 06:55:15

Hi all

Will some body give some recomendations before/After creating MP's on Cluster Environment.

Sponguru

sponguru_dba
Yak Posting Veteran

93 Posts

Posted - 2010-07-27 : 07:01:34

As erlier post Shaw recomended Install SP3 on Microsoft SQL Server 2005 - 9.00.1399.06 (X64)
-- So that I can create Maintenance Plan's

1.after Installing SP3 is it required restart instance ?
2.Can have integrity and Backup very check in Full backup Maintenance Plan
3.I ma planing to take Every week full backup Once
4.weekly trice Diff backup.
5.Every hour T-log backup

is it correct scenario in Cluster environment ?

Sponguru

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-07-27 : 08:34:19

The SP3 recommendation was not so that you can create maint plans. You can create maintenance plans on ANY version of SQL 2005, providing you have SSIS installed. The SP3 recommendation was because there were bugs in RTM that have since been patched and because RTM is not supported any longer.

Impossible to tell if the backup frequency is 'correct'. Depends on yur maintenance windows, your data loss requirements, your downtime requirements, your available backup space, etc. There's no one correct backup strategy.

--
Gail Shaw
SQL Server MVP

sponguru_dba
Yak Posting Veteran

93 Posts

Posted - 2010-07-27 : 09:32:28

Hi Gail Shaw

I want create Database Maintenance plan only like Integrity check,Backup,Updatestatistics etc..

Do they required SSIS installation in Server?.

Sponguru

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-07-27 : 12:57:55

Prior to SP1, yes. But, since you're installing SP3 (I assume), no.

The need for SSIS for maint plans was one of the things fixed in Service Pack 1

--
Gail Shaw
SQL Server MVP

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2010-07-27 : 15:47:43

One thing you should realize also is that if you create maintenance plans on pre-SP1 and then upgrade to SP2/3 you will have to recreate each plan. There were significant changes (and fixes) in SP2 with regards to maintenance plans.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2010-07-27 : 15:54:49

quote:
Originally posted by GilaMonster

There's no one correct backup strategy.

There is one. Without having the backup tested correctly, there is no backup done.

N 56°04'39.26"
E 12°55'05.63"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2010-07-27 : 15:56:10

Hehe, I thought OP meant "Mounting Points" first time I read this topic.
Seemed more appropriate using MP for "Mounting points" in a clustered environment than "Maintenance Plans".

N 56°04'39.26"
E 12°55'05.63"

sponguru_dba
Yak Posting Veteran

93 Posts

Posted - 2010-07-28 : 01:46:37

Thanks Gail Shaw,Peso and jeffw8713

all suggestion and help

Thanks for advice ...I going to us MP for "Mounting Point" instead of Maintenance Plans...in furure.

Sponguru

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources