January 18, 2011 at 4:59 am
i have this requirement
two databases A and B , A is in simple recovery and B is in Full mode i want to synchronise the two databases from one server to another server , how to achieve this ?
replies are highly appreciated .
January 18, 2011 at 5:51 am
What are your exact requirements?
Is it a one time synchronization? Or do the databases need to be synchronized all the time? In real-time? Is latency allowed?
There are a number of ways to synchronize databases:
* 3rd party tools
* log schipping
* mirroring
* ...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 18, 2011 at 5:55 am
needs to synchronise ones for a day .
January 18, 2011 at 5:59 am
ramyours2003 (1/18/2011)
needs to synchronise ones for a day .
Do you mean once a day?
There are some excellent tools out there that can synchronize databases for you.
Another option - if the database isn't too big - is to create a backup of your database and restore it on the other server.
Yet another option, but you should check if your recovery models support it - is log shipping. In my opinion log shipping is easier to implement than replication or mirroring.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 18, 2011 at 6:10 am
yes ones on every night , if you prefer can u send me the procedure to do LS . what is the frequency to configure ?
January 18, 2011 at 6:14 am
ramyours2003 (1/18/2011)
yes ones on every night , if you prefer can u send me the procedure to do LS . what is the frequency to configure ?
I replied in your log shipping thread in SQL Server 2005 - Administration 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply