[VIEWED 8846
TIMES]
|
SAVE! for ease of future access.
|
|
|
Mukurdhom
Please log in to subscribe to Mukurdhom's postings.
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. - Copy database option from task menu.
- Getting error message
- Tried the Generate Script method.
- Copied most of the objects but not all.
- Tried the backup and restore method.
- No luck
- 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
|
|
|
|
Mukurdhom
Please log in to subscribe to Mukurdhom's postings.
Posted on 04-29-09 12:49
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
|
|
|
fishtail
Please log in to subscribe to fishtail's postings.
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.
|
|
|
thisisbinod
Please log in to subscribe to thisisbinod's postings.
Posted on 04-29-09 3:17
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
|
|
|
कुश
Please log in to subscribe to कुश's postings.
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.
|
|
|
ImDevil
Please log in to subscribe to ImDevil's postings.
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.
|
|
|
Mukurdhom
Please log in to subscribe to Mukurdhom's postings.
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.
|
|
|
xcopsgen
Please log in to subscribe to xcopsgen's postings.
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....
|
|