anyone there????

mukurdhom · Apr 29, 2009 12:49 PM

try to use database publishing wizard. generate a script using it and run that script in the server. it will work.

fishtail · Apr 29, 2009 1:19 PM

Some how my earlier reply got deleted or never got posted.... Anyway, have you updated your SQL Server 2005 to SP2. The following post might be helpful http://social.msdn.microsoft.c...

thisisbinod · Apr 29, 2009 3:17 PM

Copy database wizard did not work for me too. There were several reasons with no clear solutions. But I found one nice workaround. I backed up the database from the source server to a file. Then on the target server, I just restored the database from the file. See if it works for you.

कुश · Apr 29, 2009 6:52 PM

Most probably it is the issue of different  Service Pack  running in the system. Check the  serverproperty in both servers to confirm. Also do check error logs, you might get a clue why did it fail. By the way, why r u using database copying wizard? It is always best to use backup and restore. let us know how it goes.

imdevil · Apr 29, 2009 7:31 PM

Thank you friends for your help. Detach and attach method worked for me.

mukurdhom · May 1, 2009 9:39 AM

1. First stop the SQL server Service that is running  on local. you are trying to copy from local to server right.. 2. Copy the back up file that is stores in your C: Drive some where in MSSQL.1\......bak file to some other location. Remember to copy it not move it. 3. You can start the service..... 4. Create new database. 5. You can restore that backup file to do that create a new database with the same name. Restore the back up file. 6. Remember to stop local SQL server. Happy SQL Programming. If you have further problems.......email me.... Austin - Texan....

xcopsgen · May 9, 2009 11:25 PM