how to deal with an inherited sql server
TRANSCRIPT
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