August 2, 2006 at 9:29 am
I am planning on moving my existing SQL Server 2000 to a new server but before I do that I want to run them simultaneously for a few days to woek out any issues. What would be the best way to copy the SQL Server from one Server to the other. I have jobs and DTS packages that I want moved along with the databases.
Thanks.
August 2, 2006 at 1:25 pm
Have a look at these links:
http://www.sqlservercentral.com/columnists/ckempster/datamigrationoverview.asp
http://www.sqlservercentral.com/columnists/sMaganti/microsoftsqlservermigrationassistant.asp
http://www.sqlservercentral.com/columnists/glarsen/migratingloginstoanotherserver.asp
http://www.sqlservercentral.com/columnists/gFritchey/migrationtoproduction.asp
http://www.simple-talk.com/sql/sql-server-2005/dts-to-ssis-migration/
August 6, 2006 at 9:20 pm
Dear,
If the database is not in 24*7 mode then schedule a job to backup the database and then schedule another job to restore the database on other server.
From
Killer
August 6, 2006 at 11:58 pm
If you can maintain same directory structure as in old server then it should be more easy than backup and restore.
1. Install SQL Server on New Machine and bring it to same service pack level as of current production.
2. Make sure that system databases are in same location as current production server.
3. Copy All files from Old server(you need to stop SQL Server for this)
4. Stop New SQL Server and Move all files (system and user database mdf and ldf files)
5. Start New SQL Server and run sp_drop server/sp_addserver procedures (refer books online)
HTH
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply