Restore

Tech-Archive recommends: Speed Up your PC by fixing your registry

I have two way transactional replication between Hq and other partner
countries. I want to create same enviornment in a lab for testing for
upgrade from SQL7.0 to 2000. Transactional replication is replicating same
tables and same rows and columns both ways;subscriptions are not updatble.
Now I have to take backup of all databases and restore them in the lab
enviornment and then run replicatioln script to create replication in the lab
enviornment. My question is in which order I should backup databases to keep
them synchonized. Shold I backup the HQ first or partner countries? Both
are publisher as well as subscriners for the same tables.

thanks
.

Relevant Pages

  • Re: Windows 2000 domain Upgrade
    ... remove it from production and restore it. ... I have already a test lab with 2 subnets ... But tell me what will happen to all those those Child domains? ... replication you can get away with ghosting a dc and then bringing the ...
    (microsoft.public.windows.server.active_directory)
  • Re: Restore
    ... > unless you can kick all of your users off both databases you can't. ... > restore it to the lab publisher and lab subscriber and re-run the ... > Looking for a SQL Server replication book? ... My question is in which order I should backup databases to ...
    (microsoft.public.sqlserver.replication)
  • Re: Upgrading from Windows 2000 to Windows 2003
    ... the ForestPrep will not succeed if not ... If you want to do a test, you may need to get all the DCs in the lab as ... >all of the replication partners in our ... >> The DC is a hardware related system. ...
    (microsoft.public.windows.server.migration)
  • Re: Windows 2000 domain Upgrade
    ... Since this is a test domain and you don't have to be as concerned about ... replication you can get away with ghosting a dc and then bringing the image ... Ghost at least one of my DCs of the forest / root and put it in the lab. ... will ghost also two DCs and make sure replication is fine in the lab. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Upgrading from Windows 2000 to Windows 2003
    ... I restored the lab via tape backup and not using a ghost ... > How you duplicate these DCs? ... >>the three forest root DCs and two DCs from the child domain. ... >>If the replication to the third DC is an issue, ...
    (microsoft.public.windows.server.migration)