Mukurdhom
Replies to this thread:

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

malekhu2009
:: 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
[VIEWED 4897 TIMES]
SAVE! for ease of future access.
Posted on 04-29-09 11:47 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?        
 

HELP


 


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


http://social.msdn.microsoft.com/forums/en-US/sqlsmoanddmo/thread/12181324-bc51-41a5-a8a5-608bfe2725e9/


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


Austin - Texan....

 


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

YOU CAN ALSO



IN ORDER TO POST!




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 Sajha.com. It is not possible for sajha.com to monitor all the postings, since sajha.com merely seeks to provide a cyber location for discussing ideas and concerns related to Nepal and the Nepalis. Please send an email to admin@sajha.com 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. Sajha.com is a service please don't abuse it. - Thanks.

Sajha.com Privacy Policy

Like us in Facebook!

↑ Back to Top
free counters