2005 has a 70% revamped SQL engine from its earlier product S2K.

SQL 2008 is only a 20% improvised model from SQL 2005.(A few things have changed in replication, log sipping,...

Can i ask you why are you using Maintenance plans anyways ?

There are good only for small applications, i have seen them crumble against some big databases even in SQL...

Try this.

Update the Maintainence plan and save the changes ( do not make any ).

Make sure that the Jobs etc, it creates are run by "sa" ( or if you...

This will work only on SQL 2005 ENTERPRISE and STANDARD Editions.

Is there an alternative in SQL 2000 for the same issue ?

I have tried this and it works fine........ created a function....... it works good. But i am in the last phase of QA and this will change everything !! So...

Yes. You are right........... I did not contact microsoft for this problem.

The problem could have been eliminated in 3 ways :-

1.> using sp_configure to set the MAX PARALLELISM to...

Got it !

The Design is bad. Actually this kind of configuration is not possible in an Active Passive clustered environment. The correct way of doing it without having to get...

• How big is the db ?
• How much time does is take to restore on Server B ?
• Are you restoring the backup from a N/W shared location ? There could...

So, the Node A has changed to Node B in your clustered environment.  To be able to diagnose the situation.... I need to know a couple of...

The Architecture for MS SQL and Oracle is completely different.

However, I have separated the database into multiple filegroups and multiple files ( more than 2 in any Filegroup )....