Best practice for transfering MSSQL Databases and all accounts to new server?
One of our customers has installed a new SQL server and needs to take down the old SQL box. Both servers are running Microsoft SQL Server 2008. The applications all access the current SQL server via hostname so the plan is to transfer everything then cut over the connections by updating DNS.
My question is: “What is the best way to actually move the databases and all associated accounts to the new server?”
Nothing about the current set up is documented. I need to figure out how to move over all the databases, stored procedures, SQL agent jobs, and SQL authentication accounts to the new server (note: the only account password I have is the sa password).
I am not a MSSQL guru so any help would be appreciated. Let me know if I need to clarify anything.
I guess a Backup/Restore would be appropriate here
Check more discussion of this question.
Related posts:
Leave a comment
Recent Posts
- What is the easiest way to upgrade my existing Perl 5.14 to Perl 5.16 on FreeBSD 9 using the ports system?
- Know if mysql has done its job
- Redirect https .com to https .co.uk without a valid SSL cert on .com without DNS change
- Why is it a bad idea to use customer email as from address
- 100% packets dropped on first RX queue on 3/5 raid6 iSCSI NAS devices using intel igb (resolved)





