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 |
|
sqlserverdbam
Yak Posting Veteran
54 Posts |
 Posted - 2009-04-29 : 15:55:32
|
| Hi All,Following configuration:SERVER 1 (PROD) SQL2005 (CLUSTER ENVIORNMENT) proddb is name of production database.Server 2(test) SQL2005 (CLUSTER ENVIORNMENT)Need to sync proddb from server 1 to server 2 on monthly basis.Server 2 has additional 6 tables which I need to keep during sync.Right now I'm doing backup/restore/fix orphand users and creating 6 tables.But lossing 6 tables data.Is there any other way I can save 6 tables with data.One of way I thought is DTS services.Please adviceThanks, |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-04-29 : 18:30:08
|
| Archive that 6 tables with some different name (DB). Then apply it to newly restored databases. Run the fix orphan again only if you need. |
 |
|
|
sqlserverdba
Yak Posting Veteran
53 Posts |
Posted - 2009-04-30 : 10:54:34
|
quote:
Originally posted by sodeep
Archive that 6 tables with some different name (DB). Then apply it to newly restored databases. Run the fix orphan again only if you need.
What do you meant by Table Archive?Thanks |
|
|
|
|
|
|
SYNCING 2 DATABASES