[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 8846 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
TPS Re-registration case still pending ..
I hope all the fake Nepali refugee get deported
ढ्याउ गर्दा दसैँको खसी गनाउच
Tourist Visa - Seeking Suggestions and Guidance
Those who are in TPS, what’s your backup plan?
and it begins - on Day 1 Trump will begin operations to deport millions of undocumented immigrants
From Trump “I will revoke TPS, and deport them back to their country.”
Travel Document for TPS (approved)
wanna be ruled by stupid or an Idiot ?
To Sajha admin
MAGA denaturalization proposal!!
How to Retrieve a Copy of Domestic Violence Complaint???
MAGA and all how do you feel about Trumps cabinet pick?
All the Qatar ailines from Nepal canceled to USA
MAGA मार्का कुरा पढेर दिमाग नखपाउनुस !
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