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 |
|
r_sonakiya
Starting Member
25 Posts |
 Posted - 2001-06-01 : 07:57:54
|
| What are the ways of Moving SQL SERVER database from one SQL Server to another SQL Server. I tried DTS Option it brings the objects but never gets the relationship of the objects defined at the database level like Referential Integrity,FK etc.So it's not of much use.If any one have any script please share the same.ThanksRavindra |
|
|
rohans
Posting Yak Master
194 Posts |
Posted - 2004-03-08 : 08:12:19
|
| I am having a similar problem. whenever I restore the database on another server the relationships are not there. I thought the idea of a backup was to preserve the entire database as is. I need help on this issue. Anyone have any idea?All help appreciated. |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-03-08 : 08:16:59
|
| A restore will preserve foreign keys and all other constraints. If the restored database does not have them, then they were not in the original when it was backed up. |
|
|
|
The Enigma
Posting Yak Master
179 Posts |
Posted - 2004-03-08 : 09:56:22
|
| Still ... Did anybody find an automated way to transfer linked servers from one machine to another ... |
|
|
|
rohans
Posting Yak Master
194 Posts |
Posted - 2004-03-08 : 10:44:32
|
| Thank you robvolk. But what about my diagram showing related tables. How can I build it back?All help appreciated. |
|
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
|
|
|
|
|
Moving SQL Server Database from one Server to Anot