Interesting topic. We are just beginning to implement COMMVAULT for all of our SQL Server and Oracle databases.

To go from SQL2008 to 2014 you cannot restore master and msdb from one version to another. So, if you are going from one server to another for different...

Thanks, very interesting. I will play around with it in our environment and see what I see with this.

First of all take it very slow.... and plan, plan, plan...

A test environment is needed to test our your upgrade process and test out running process against the new environment.

Download...

Agree. When I use DTA and it suggests indexes I take a copy of the production db, restore to non prod server and then one by one add the...

don't beat us up too badly... this is the way Microsoft created it..... It may be in plain text, but, you need 'sa' privledges to open up the job and...

I actually ran into this issue myself. I never found a resolution to it.

If you are pondering the replication route remember every single table HAS to have a primary key in order for it to be replicated.

The price certainly went up when they changed the pricing model for SQL2012. It certainly opens the door to other, less known RDBMS like MySQL and EnterpriseDB.

I know we...

TheSQLGuru (5/19/2014)

---

Kinda what I figured. It does sound like you either have too many servers or more hopefully you are expecting to grow into the ones you have (that...

TheSQLGuru (5/19/2014)

---

Markus (5/19/2014)

---

For the bulk of systems there aren't any additional features in 2012 or 2014 that will make a system run better for us. The biggest feature of...

For the bulk of systems there aren't any additional features in 2012 or 2014 that will make a system run better for us. The biggest feature of SQL2008R2 for...

Great script, thanks!

Yes, that is how it is supposed to be done via Microsoft. Do NOT use the services panel to change the userid/password.

Sorry, I meant I created linked servers up version... from 2000 to 2008 and 2000 to 2008R2. I also have one going from 2005 to 2008R2 as well....