| Author |
 Topic  |
|
|
puzo
Junior Member
Israel
417 Posts |
 Posted - 26 October 2004 : 12:35:50
|
That's right, i want to transfer my database from one MS-SQL server to another.
Since there is no forum for this i decided to ask it here.
What is the best way to do so?
I tried backup and restore - no go (said invalid ACTIVE_USERS object)
DTS - no go (said Access Denied to user)
Thanks in advance (ruirib  )
Mike. |
 |
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 26 October 2004 : 12:56:28
|
| ok, create a database on the new server and add the same users as on the existing server. then just do a dts transfer and select "Copy objects and data....", this should transfer everything inluding indexes etc |
 |
|
|
Podge
Support Moderator
Ireland
3776 Posts |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 26 October 2004 : 19:05:39
|
| If you new server doesn't give you full access you may not be able to do a DTS Copy Objects and Data without getting access erors in which case you'll first need to script the original database (right click on it, all tasks, generate script), run that script on the new server to create your tables, indexes, constrains etc making sure to change any table ownership first as well if your using a different logon on the new server, then just do a DTS import copying *data* only not objects. |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
puzo
Junior Member
Israel
417 Posts |
Posted - 28 October 2004 : 22:24:32
|
HuwR - that worked, thank you!
Thank you also Podge and Gremlin. |
|
|
|
| |
Topic |
|
Topic Locked
