I have a standalone SQL 2000 server. I want to take that database and move it to a SQL 2000 Cluster server with a different database name and server name. How can I do this and still keep all the SQL maintenance plans?
The maintenance plans probably have a fixed connections if they are DTS so will need to be changed or rebuilt. They need to be designed to take the database and server as parameters so they can be moved easily. It's usually pretty easy to build a stored procedure that takes the database name and/or server name as parameters.
========================================== Cursors are useful if you don't know sql. SSIS can be used in a similar way. Beer is not cold and it isn't fizzy.
The maintenance plans probably have a fixed connections if they are DTS so will need to be changed or rebuilt. They need to be designed to take the database and server as parameters so they can be moved easily. It's usually pretty easy to build a stored procedure that takes the database name and/or server name as parameters.
========================================== Cursors are useful if you don't know sql. SSIS can be used in a similar way. Beer is not cold and it isn't fizzy.
Ok, I understand and thought I would have to rebuild the procedures anyway. What are the steps to move the databases?
1. Backup the database on the old server to a file. 2. Restore the database on the new server with the new database name from the backup file from step 1.
restore database to a different server
Posted - 08/14/2012 : 13:03:27
