Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kwterror
Starting Member
1 Post |
 Posted - 2011-11-20 : 02:50:15
|
| I am trying to copy database from one server to another using the Copy Database Wizard in SQL Server 2008 R2. The process fails in the last step.The error msg is not clear and it says there are more than two errors etc etc. Can anyone help me in this matter |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-20 : 03:36:23
|
| not much we can do until we've details on what error you're facing. Either post error message or post the screenshot in some shared server and give the link here------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
johntech
Yak Posting Veteran
51 Posts |
Posted - 2011-11-21 : 03:35:48
|
| The Copy Database Wizard lets you move or copy databases and their objects easily from one server to another, with no server downtime. Using this wizard, you can do the following:Pick a source and destination server.Select databases to move or copy.Specify the file location for the databases.Create logins on the destination server.Copy additional supporting objects, jobs, user-defined stored procedures, and error messages.Schedule when to move or copy the databases.To show all requirments and conditions to copy DB using sql wizard 2008 r2 show below linkhttp://msdn.microsoft.com/en-us/library/ms188664.aspx |
|
|
|
|
|
|
Copy Database Wizard Error SQL Server 2008 R2