September 11, 2003 at 11:53 am
How can i move my database from one server to another server with all the database objects,users and stored procedures.
Thanks
September 11, 2003 at 12:48 pm
You can do this in either of the following
options :
1. Take a Database Backup and restore onto new Server.
2. Procedure:
2.a. Stop the SQL Services
2.b. Copy .MDF & .LDF files to new server
2.c. Attach Database on Target Machine.
2.d. Start Servives on Source Machine.
Option #1 is the easiest.
.
September 11, 2003 at 1:59 pm
Either way you'll have to transfer the logins too (separately) or add them manually. If you do the latter you'll need to run sp_change_users_login to fix up sql users in the db.
Andy
September 11, 2003 at 2:45 pm
Oppps.... I know I'd forget this one.
.
September 11, 2003 at 2:49 pm
It's a shame they don't make it easier/more transparent, its such a common task.
Andy
September 11, 2003 at 3:05 pm
You do have the tranfer login task within dts.
Steven
September 12, 2003 at 12:19 am
Yes. Its much easier with DTS Transfer login Task. The only bottleneck would be : both the servers had to be up and running while doing this.
.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply