Monday, March 26, 2012

help with server replacement

i'm replacing a server in the next few weeks.
the old server has all database files, log files, and error files on
f:\sql which is a drive on a san.
sql2000 program files are on c: and d:.
the new server will have the same name and same IP as the old server.
the only difference is new one is win2003 and old one is win2000.
i'm wondering if this will work.
create disk partition on new server f:
install sql2000 program files on c: and d:.
install sql2000 data, log, and error files in f:\sql
shut down sql2000.
delete f:
shut down old server.
connect new server to network.
attach the san drive to new server as f: (has all the databases from old
server).
start sql server.
think that will work?
or will i have to install master, model, msdb, tempdb on e: and then
detach the ones on e: and then attach the ones on f:?
last time i did that, it was a nightmare. i couldn't get sql server to
start for like an hour because the kb article had faulty instructions.Hi,
There are several factors you need to consider. I suggest you go through
these articles, list down each of the activities (something like checklist)
and execute it.
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://www.support.microsoft.com/?id=314546
INF: Using the WITH MOVE Option with the RESTORE Statement
http://support.microsoft.com/?id=221465
PRB: User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://www.support.microsoft.com/?id=246133
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://www.support.microsoft.com/?id=274188
How to Resolve Permission Issues When a Database Is Moved Between SQL
Servers
http://www.support.microsoft.com/?id=240872
SAMPLE: Mapsids.exe Helps Map SIDs Between User and Master Databases When
Database Is Moved
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
Thanks
GYKsql

No comments:

Post a Comment