SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Server Organization

Server Organization

chappell grant-willis
chappell grant-willis
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 35
Cool I just secured a job where the company has about 98 SQL Servers installed. I only know this by polling the network for them. I think I have linke 187 instances of SQL Dbs floating around but they are scattered. They are in no rhyme or reason. Test and dev are usually on the same server and there is no real backup process in place.

I am in the process of finding these servers and instances and identifyling them to an application. The instances are unpached and on inadequate servers. It has taken me 3 months to find out this much.

In the intrim they are deploying 4 major projects with new server taht were built by infrastructure but no one knows the names of them.

Also they want me to constuct the policies and procedures for the databases, job accesses and vendor accesses (since on vendor logged in without knowledge and restarted the server and applied 48 windows patches to the server which crashed the database :w00tSmile

I feel like im spinning my wheels. In not a new DBA (10years exp) however I have not ever found myself in this much disarray. Has anyone any suggestions how I can organize this mess besides quitting?????Crazy

The DBADiva

Steve Jones
Steve Jones
SSC Guru
SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)

Group: Administrators
Points: 401062 Visits: 20448
First, get backups running on production servers in an organized fashion. Just built a policy for now, then start getting things changed based on criticality.

Second, as you set things up, SCRIPT EVERYTHING. Make sure that if you setup a backup, you do so with a script so that you can deploy the same thing on other servers.

Third, get a place to test restores. Last thing you need is an explosion on production without being ready. Get this ready, practice a few restores, do log restores, point in time, get some familiarity with what's needed on these systems.

From there, you can start to look for others test/dev servers, set up a reasonable backup strategy. If you're not sure, post back here with specific questions in a new thread.

I would also not worry too much about all those instances. Some may be MSDE, so you might get a domain admin to query all of them and get back the results from

select @@version

If you see Express or MSDE, it's a local instance. Not worth worrying about for you.

Now, take a deep breath. This is a great chance for you to learn. Every time you think about doing something think about how to apply it to multiple servers. SQL Server has some good tools, and as you try to handle something like jobs, backups, whatever, come up with a plan. Test something on one server, make sure you have a script, and then post a new thread here, asking what others think. Then you can deploy things.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com


You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum