April 24, 2013 at 5:01 am
Dear All,
I have to prepare a backup server for my SQL Server, which should be automatically updated as the changes in main server.
I want to know can we do the same through Replication or by some other means.
Regards
Vishal Sharma
April 24, 2013 at 5:26 am
thats a big subject and the best answer depends on what the backup server will be used for and what latency you require.
You need to research clustering, database mirroring, logshipping and replication, possibly even SAN replication.
Database mirroring is dependant on this in fact not being SQL2000.
Post more details on your requirements and SQL version and we can steer you in the right direction.
---------------------------------------------------------------------
April 24, 2013 at 5:39 am
Dear sir,
I want to make a backup Server where we can switch when the main server is down again when the main server is up then it should automatically become the man server and they must me automatically syncronising the data.
April 24, 2013 at 6:58 am
I would suggest database mirroring
http://msdn.microsoft.com/en-gb/library/ms189852.aspx
---------------------------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply