April 17, 2012 at 4:52 am
HI friends,
We have two servers server A and server B. In both have same databses maintaining but A server
is production server. B server is developement server. here my requirement is , At time multiple databses are overwrite from server A to Server B as per the schedule time any body help me how can achive this....
Note: Bothe server should be in read/write mode
--
Thanks
Rama prasad
April 17, 2012 at 8:37 am
Not sure I understand. You are wanting to copy production dbs back to dev? Just back them up and restore them on dev.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
April 17, 2012 at 1:35 pm
ramprasad1485 (4/17/2012)
Note: Bothe server should be in read/write mode
There's no way round it because of this statement. You have to set up a scheduled restore on "Server B".
I assume you are backing up Server A anyway as its a production server. I also assume that you dont want changes made on "Server B" to reflect on "Server A"; this eliminates replication.
EDIT: you could use snapshot replication but I wouldnt bother as it adds an extra layer of complexity
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply