1)You mean you trying to migrate SQL Cluster 2008 Active\Active to SQL Cluster 2012/2014 with Availability group ?

2) for maintenance plan Please follow the link. This might clear...

As everyone mentioned

1)backup and

2)you have access.

since you are asking for what are pref counters you need to look at.

since you have dba and dba is gone on vacation....

Jeff gave you smart example.

in addition- one more example.

"SQLServercentral.com" which you are using is one right now.

You have posted question. You are getting reply . that is real time ......example...

Nothing Wrong with Your statement.

What do you mean by executing all the time ?

IF you are going for Instance level means it upgrade all databases which existed on SQL 2008 to SQL 2012

IF you go for database level then You need to ...

Is this for Instance level or Database level ?

sorry for typo error in last thread.

No. You can't.

There is only way You migrate data

On top of that even if You create schema DB on 2008.

You need to make sure when create schema...

First why you need to go back with SQL 2012 standard from SQL 2012 Enterprise.

Please follow this link and compare standard and enterprise edition feature

http://www.midnightdba.com/Jen/2014/03/the-case-for-sql-server-2012-enterprise-vs-standard-edition/

You need to consider...

I know you looking for certain answer.

How i will answer that question: I use formalizes approach

1) i need to find root cause and talk about possibilities like as...

It is up to you how you want to transfer data.

There are so many options available

You can use import/export wizard, SSIS, BCP ,script out data and run on other...

There is no certain answer for this question.

same question like what is your approach if your application is running slow.

This is hypothetical question and you can Drove them ...

Thank You Both for valuable input.

I just asked because we have new project now both Oracle and MS-SQL server teams are trying to prove their point.

I am 100% sure You...

Thank You Very much for valuable input.

Much appreciated.

It is clustred.

Thank You.