[Show all top banners]

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 7187 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 script using it and run that script 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 60 days
Recommended Popular Threads Controvertial Threads
What are your first memories of when Nepal Television Began?
निगुरो थाहा छ ??
Basnet or Basnyat ??
Sajha has turned into MAGATs nest
NRN card pros and cons?
Will MAGA really start shooting people?
मन भित्र को पत्रै पत्र!
Top 10 Anti-vaxxers Who Got Owned by COVID
काेराेना सङ्क्रमणबाट बच्न Immunity बढाउन के के खाने ?How to increase immunity against COVID - 19?
TPS Work Permit/How long your took?
Breathe in. Breathe out.
3 most corrupt politicians in the world
चितवनको होस्टलमा १३ वर्षीया शालिन पोखरेल झुण्डिएको अवस्था - बलात्कार पछि हत्याको शंका - होस्टेलहरु असुरक्षित
शीर्षक जे पनि हुन सक्छ।
Disinformation for profit - scammers cash in on conspiracy theories
someone please tell me TPS is here to stay :(
Nepali doctors future black or white usa ?
Doctors dying suddenly or unexpectedly since the rollout of COVID-19 vaccines
BREAKING: THE LEFT HAS LOST THE SUPREME COURT!
Another Song Playing In My Mind
Nas and The Bokas: Coming to a Night Club near you
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