Thursday, June 12, 2008
What is log shipping?
Log shipping is the process of automating the backup of database and transaction log files on a production SQL server, and then restoring them onto a standby server. Enterprise Editions only supports log shipping. In log shipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db can be used this as the Disaster Recovery plan. The key feature of log shipping is that is will automatically backup transaction logs throughout the day and automatically restore them on the standby server at defined interval.
Labels:
Interview Questions
Subscribe to:
Post Comments (Atom)
3 comments:
guess you are wrong dude... Log shipping is supported in Developer and Standard Editions as well...
Hi Suman,
Log Shipping is Supported in Developer Edition but not in Standard Edition.
Liên hệ Aivivu, đặt vé máy bay tham khảo
vé máy bay đi Mỹ tháng nào rẻ nhất
giá vé máy bay đi từ mỹ về việt nam
vé máy bay từ đức về việt nam
chuyến bay từ nga về việt nam
chuyến bay từ anh về việt nam
ve may bay tu phap ve viet nam
khách sạn cách ly tphcm
Chuyen bay cho chuyen gia nuoc ngoai
Post a Comment