9 Things to Do When You Inherit a Database

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Sylvia Moestl... » 9 Things to Do When You Inherit a Database

84 posts, Page 9 of 9

«««5 6 7 8 9

9 Things to Do When You Inherit a Database

Rate Topic

Display Mode

Topic Options

Author

Message

RBarryYoung

Posted Saturday, June 23, 2012 9:43 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855, Visits: 9,374

Big props for mentioning the most important th1ng, and putting it first: Backups.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."

Post #1320322

JasonRowland

Posted Sunday, June 24, 2012 1:34 PM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 8:44 AM
Points: 89, Visits: 684

On the topic of "obsolete" objects, dropping them if they haven't been accessed in 3 months or a year is a big mistake. I've seen objects that are only accessed on leap years and if dropped would cause serious implications. My advice on objects that you think are obsolete, leave them alone unless you are absolutely, 100% certain they will never be used again. Otherwise you could be setting yourself or someone else up for big problems.

Post #1320386

P Jones

Posted Monday, June 25, 2012 9:50 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 7:35 AM
Points: 515, Visits: 1,016

I'd get the separate dev and test app and database environments set up and working and run the everyday, period end, month end, year end and any other time procedures on that with profiler to find what is used and document it as well as running profiler on live to find out what gets connected to from outside the apps.

Post #1320711

hp_dba_uk

Posted Tuesday, September 11, 2012 9:55 AM

SSC Rookie

Group: General Forum Members
Last Login: Saturday, November 03, 2012 8:04 PM
Points: 37, Visits: 123

Really good article. I guess list could be end less as the time pass by requirements or usage change. But at least when you just been handed a DB and if you know even the only options listed here should be ok for a start. Other good suggestions could follow as given by others...

Also this could be asked in DBA interviews as at times basics are not followed getting lost in advance features..

Thanks

Post #1357546

« Prev Topic | Next Topic »

84 posts, Page 9 of 9

«««5 6 7 8 9

Permissions