Hi -
I have a database running on a server and its approx 50 MB. How can u mode the entire database to another server with all its tables, data and login details.
Please let me know all possible ways.
ThanksMove the logins from Server A to Server B
Back up the database on Server A
Restore the database on Server B
- CB|||Or you can detach the database and attach it back to the other server.
Make sure you use dbo rights to detach and dbo rights to attach.
After detach, you can copy and move the file (mdf, log) to your other server.
You have to recreate all the logins at the new server.
I personally like attach detach. But backup restore is also practical.|||Make sure you backup your database before if you detach and attach. Just in case.|||you can use DTS to transfer the logins and passwords, or better yet, use sp_help_revlogin... http://support.microsoft.com/default.aspx?scid=kb;en-us;246133&Product=sql2k
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment