SQL Server Performance Forum – Threads Archive

moving user databases

I am moving user databases from one server to another in a network.I am following these steps:
1)detaching dbs from source-copy all data and log file to destination
attaching these files on destination server.
2)Using sp_help_revlogin to move the logins ,users and passwords.
3)correcting orphan users using sp_change_user_login
will these steps be sufficient for proper functionality of sp, triggers,indexes,stats,ownership etc on the destination server as they were in source servr.pls suggest

Yes and mostly covered as specified in thishttp://vyaskn.tripod.com/moving_sql_server.htm link. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

If I were you I’ll update statistics full.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>