February 3, 2007 at 2:18 am
Hi all,
I have a production server which is running on a slow machine. There is some space constraint also. So i want to migrate the complete operation on to a new machine keeping in view the future requirement.
Please suggest me the best method to move complete sql server objects and data on to a new machine?
Thanks
February 3, 2007 at 7:34 am
FOr database u can detach and attach the databases. For logins and job u can use DTS to move the jobs and the logins to the new server.
Remember to d a check for orpahn ids after u move the logins
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 5, 2007 at 12:47 am
I will also recommend to note down the servername,collation settings(if any) of database,service pack info(along with the cumulative hotfix etc),output of sp_configure and bcp of tables.
Hope this will help
February 5, 2007 at 12:56 am
There are several articles that could help you in accomplishing your job. I am posting URLs of couple of articles that may help you.
http://www.sqlservercentral.com/columnists/cBunch/movingyouruserswiththeirdatabases.asp
http://vyaskn.tripod.com/moving_sql_server.htm
Prasad Bhogadi
www.inforaise.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply