February 23, 2009 at 11:23 pm
i have a database in one server
2nd database another server at another location
now i need to synchronize these 2 servers
can any body tell the solution for this
How to synchronize databases between two server in sqlserver 2005
February 23, 2009 at 11:27 pm
Is it one time requirement like Database Refresh or you want to implement standby solutions like Mirroring, Log shipping?
Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc
February 24, 2009 at 1:33 am
i want to implement standby solutions like Mirroring, Log shipping?
pls provide the solution
February 24, 2009 at 1:50 am
There are a couple of strategies you can use, mirroring / logshipping / replication. My recommendation will vary depending on what you want to accomplish, if you would like to accomplish a hot standby server I would recommend mirroring
To read about mirroring in books online :
ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_4deptrbl/html/a7f95ddc-5154-4ed5-8117-c9fcf2221f13.htm
To read about log shipping in books online :
ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_4deptrbl/html/b6e5f108-227b-479a-9405-40b7ab46dc0d.htm
Database mirroring is a simple strategy that offers the following benefits:
Increases data protection.
Database mirroring provides complete or almost complete redundancy of the data, depending on whether the operating mode is high-safety or high-performance. For more information, see "Operating Modes," later in this topic.
A database mirroring partner running on SQL Server 2008 Enterprise or later versions automatically tries to resolve certain types of errors that prevent reading a data page. The partner that is unable to read a page requests a fresh copy from the other partner. If this request succeeds, the unreadable page is replaced by the copy, which usually resolves the error. For more information, see Automatic Page Repair During a Database Mirroring Session.
Increases availability of a database.
In the event of a disaster, in high-safety mode with automatic failover, failover quickly brings the standby copy of the database online (without data loss). In the other operating modes, the database administrator has the alternative of forcing service (with possible data loss) to the standby copy of the database. For more information, see "Role Switching," later in this topic.
Improves the availability of the production database during upgrades.
To minimize downtime for a mirrored database, you can sequentially upgrade the instances of SQL Server that are participating in a database mirroring session. This will incur the downtime of only a single failover. This form of upgrade is known as a rolling upgrade. For more information, see How to: Install a Service Pack on a System with Minimal Downtime for Mirrored Databases.
(ref Microsoft Books Online for SQL Server 2008)
/Håkan Winther
Senior Development DBA
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
February 24, 2009 at 2:00 am
hi
iam not able to open the above link
please send it again with link
February 24, 2009 at 2:40 am
You have to open books online for SQL server an paste the link in the address bar.
/Håkan
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
February 24, 2009 at 2:43 am
I am sorry, to use the link you need to have books online for SQL Server 2008.
Use this link:
http://msdn.microsoft.com/en-us/library/ms189852.aspx
or
http://msdn.microsoft.com/en-us/library/bb895393.aspx
or
http://msdn.microsoft.com/en-us/library/ms190202(SQL.90).aspx
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply