Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ld4987
Starting Member
4 Posts |
 Posted - 2012-10-06 : 18:11:00
|
| I have a SQL Server 2000 instance (runs Microsoft Dynamics GP) that is installed on a domain controller.I am moving to a new domain with a SQL Server 2008 instance, but for approximately one weekend, I need to maintain access to the SQL 2000 instance.The instance is using mixed mode and logins are stored inside of SQL. I'm not looking to add the server to the new domain for the one week period.My plan is to:1) Demote the server2) Make sure I have a local administrator login on the server3) Connect to new network and let DHCP assign it an IP4) Reboot server and login locally5) Change ODBC settings on the user machines to point to the new instanceIs there anything else that I need to check or do to make this work?Thanks |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-10-07 : 03:03:26
|
| Consider using CNAMES in the DNS - therefore you won't need to change ODBC settings in the future Check there aren't SQL Server Agent jobs or scheduled tasks runningCheck there isn't momitoring What are you doing about backups?Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
ld4987
Starting Member
4 Posts |
Posted - 2012-10-07 : 12:17:50
|
| I'm going to do a full backup prior to the domain disconnect. Then each night, a full backup stored on an external USB will be sufficient based on our service level agreement. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-10-07 : 13:31:16
|
| OK , I was thinking more about if you have any schedules which backup automatically - such as log backupsJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
SQL Server 2000 - Domain Changes