Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rgchai
Starting Member
3 Posts |
 Posted - 2004-03-31 : 22:15:33
|
| Hi all,I am having problem in transfering the database from one server to another server.I am using DTS Import Wizard to import database from another SQL server (both are MSSQL Server 7.0). I used "Transfer Objects" option in order to transfer all other objects besides tables. So far I have tried few times, even with restarting both SQL Server service, I still can't get database successfully transfered.The details error message I got is:Need to run the object to perform this operation [SQL-DMO]Code execution exception: EXCEPTION_ACCESS_VIOLATIONAll the time I logged in using SA privilege but still have this access violation message. I have no idea of what is that means at all. Actually I'd also tried to disable all the constraint in source database but still have the same problem. Can someone can help me up here?Thank you.Regards,Roger |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-01 : 12:21:57
|
| Why are you using the DTS import wizard to transfer a databse? Transfer a database using BACKUP/RESTORE or sp_detach_db/sp_attach_db.Tara |
 |
|
|
rgchai
Starting Member
3 Posts |
Posted - 2004-04-01 : 19:43:30
|
| Thanks for your reply. Well, I'd tried the Backup/Restore method before, but when I tried to restore from the backup set, the system seemed detected the backup set is not from the same server, and refused to proceed.Regarding sp_detach_db/sp_attach_db, I have no idea about that. Can you please explain more about it if you don't mind. Very sorry for my ignorance. :pRegards,Roger |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-01 : 19:58:05
|
| You can restore a database that was backed up from a different server. You probably just need to move the location of the MDF and LDF file. Are you using EM for the restore? If so, go to the second tab in the restore screen and modify the location of the files. For QA, you'll need the WITH MOVE command.sp_detach_db and sp_attach_db are documented in SQL Server Books Online.Tara |
|
|
|
rgchai
Starting Member
3 Posts |
Posted - 2004-04-04 : 21:03:15
|
| Thank you for your advice. Finally I'd successfully copied my database using Backup and Restore methods. Thanks again.Regards,Roger |
|
|
|
|
|
|
|
|
Problem in database transfer in DTS