SQL Server Performance Forum – Threads Archive
moving user databasesI 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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
If I were you I’ll update statistics full.
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
All postings are provided â€œAS ISâ€ with no warranties for accuracy.