Replies to this thread:

More by Mukurdhom
What people are reading
[Total Subscribers 1]

:: Subscribe
Back to: Computer/IT Refresh page to view new replies
 SQL Server HELP !!!!!!!!!!!!
Keywords associated with this thread

Computer SQL Server Database HELP Dbase Mysql
SAVE! for ease of future access.
Posted on 04-29-09 11:47 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?        



I am using SQL server 2005, and I am having trouble while copying database from Local to Server.


Here are the things I had tried so far.

  1. Copy database option from task menu.

    1. Getting error message

  2. Tried the Generate Script method.

    1. Copied most of the objects but not all.

  3. Tried the backup and restore method.

    1. No luck

  4. Tried Google Search


( Server : SQL Server 9.0.1406 – sa

Local: SQL Server 9.0.1399 – sa ) Does this matter????



SQL Server is working fine on both local and server.


Please suggest.  need to keep job and pay bills




Posted on 04-29-09 12:49 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?        

anyone there????
Posted on 04-29-09 1:19 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?        

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

Posted on 04-29-09 3:17 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?        

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

Posted on 04-29-09 6:52 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?        

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.

Posted on 04-29-09 7:31 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?        

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.

Posted on 05-01-09 9:39 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?        

Thank you friends for your help.

Detach and attach method worked for me.

Posted on 05-09-09 11:25 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?        

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 me....

Austin - Texan....


Please Log in! to be able to reply! If you don't have a login, please register here.



Within last 365 days
Recommended Popular Threads Controvertial Threads
What stocks to buy -- Any recommendation
TRUMP 2016!!! Here is why?
जोडि त भाग्यले जुराउँछ - हिरोइन स्वेताले यसरि दोश्रो पटक बिहे गर्न लागिन
ॐ श्री स्वस्थानी ब्रत कथा
लौ .. संसद नै बिघठन गरिदिएछन ओलिबाले
Conservative discussions
उस्तै उस्तै हामी
Looking for Potential Match
निर्लज्जताको बाढी आएको छ
Love Letters From The Past--SITARA
A New Start
हाकिमनी संग- आज सुक्रबार -३
सान भिनाजु लाई अझै पैसो कमाउने आइडिया
Ushering in new era of communism ...
Rain Rain .. Raut
I m offered a Job in Bank in Nepal, should i go back ?
Fox News: Wear the Damn Mask, it is not political issue but a public health issue.
Photo of the day
Nas and The Bokas: Coming to a Night Club near you
विद्या तेरो सिन्दूर खोइ, केपी ओली तेरो पोइ ..
TRUMP 2016!!! Here is why?
NOTE: The opinions here represent the opinions of the individual posters, and not of It is not possible for to monitor all the postings, since merely seeks to provide a cyber location for discussing ideas and concerns related to Nepal and the Nepalis. Please send an email to using a valid email address if you want any posting to be considered for deletion. Your request will be handled on a one to one basis. is a service please don't abuse it. - Thanks. Privacy Policy

Like us in Facebook!

↑ Back to Top
free counters