Networks

Ask something
Discussion Locked

SQL SERVER - GENERAL QUESTION

0 helpful
3 replies

by xyzxyz1

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Setting up a NEW SQL SERVER under WIN2000. Currently have it all on 1 PC (WEB, SQL, File Server, etc., etc.) Yes, I know. It's bogging-down BIG time. Time to seperate...

General Question: BEST Config for new Servers - Should I setup SQL using theold PDC/BDC for simplicity, or go (make the transition to) AD?

MAny are pushing me into AD, saying I gain a lot for SQL. I don't see it. MY concerns are really what to do when the MAIN SQL SERVER goes down. At least with a BDC, I can setup SQL topickup & continue running. IS my thinking straight? ...Your Opinion?

Remember: SIMPLICITY of design HERE, since Administration is minimum, at best.

THX!

GUY!

3 replies

by blaine moore

PDC/BDC or AD doesn't matter. We have AD going with two machines. The primary has all of the SQL Server activitiy go down, and that data is replicated to the backup server (which we use for DNS). So if need be we could switch to the backup, but thankfully have not needed to.

I'm a big fan of AD, it makes administration so much easier. Migration can be a bitch though.

This discussion is closed to new replies.