moving user databases | SQL Server Performance Forums

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 this link. Satya SKJ
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 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.