November 25, 2009 at 11:08 am
I've installed the CU 6 SP3 on my SS2005 development/test server.
How do I effectively test this SS instances to see if nothing was broken? As well, there may have been security operations that hardened the server, and some settings might be reset post CU fix hot patch. I want to check these as well (or at least important ones).
Zee (Atlanta)
SS DBA
General Dynamics I.T.
November 25, 2009 at 12:09 pm
Effective testing would be much the same as the QA process for releasing an app to production.
Run through your test plans, test the application and verify that everything is still functioning as expected.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 25, 2009 at 1:18 pm
Jason is correct. You'd want to completely regression test your app against the server. This is one reason I wouldn't recommend CUs unless you are hit with a fix in one of them. Otherwise stick to SPs
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply