SQL Server 2005 Tidbit 010

Manly SQL DBA

Number Ten! 

Credit for this one goes to my friend and teammate Matt Hester...

Q: How does SQL 2005 handle online databases during the upgrade, what about the applications that are in use?

A: This questions was very interesting to me so I did some checking.  The best bet to see how this is going to work, is to use the Upgrade Advisor, this will give you great advice on any potential database or application issues.  However ultimately for any upgrade, some good ole’ fashion testing is in order.  For more information, and to down load the Upgrade Advisor look here: http://www.microsoft.com/downloads/details.aspx?FamilyID=cf28daf9-182e-4ac2-8e88-f2e936558bf2&DisplayLang=en 

Got an IT question?  Give me a comment, or contact me.