how to deal with an inherited sql server

How to Deal With an Inherited SQL ServerMarch 11. 2015

Meet Andy Warren

• Microsoft MVP• Served on the PASS Board• Founding partner in

SQLServerCentral.com• Blogs at https://sqlandy.com

It’s All Yours Now

• Might be from a merger/acquisition

• A “departmental” server

Take Notes, Triage, Do No Harm

• Taking notes might seem obvious, but imperative!

• There’s a tendency to just jump in and start “fixing”

stuff. Build the list, talk to the boss

• It’s amazingly easy to break something by trying to

make something “better”

Warm Hand Off

• Meet the people that used to manage it

• Don’t be critical of the setup

• Get as much info as you can during the planning and

transfer, but assume you’ll have some follow up

questions

Find The Documentation

• There is never enough, but some

• Data Dictionary/Diagrams

• Jobs

• What do they do

• Who do you email when they fail

Did you miss the live webinar? You

can view the entire Geek Sync on

idera.com

Watch the On Demand Webinar