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.
Saturday, May 10, 2008
What is log shipping?
Labels:
SQL Interview Questions
Subscribe to:
Post Comments (Atom)
Archives
-
▼
2008
(41)
-
▼
May
(20)
- Which command using Query Analyzer will give you t...
- What is SQL server agent?
- Can a stored procedure call itself or recursive st...
- What is @@ERROR?
- What is Raiseerror?
- What is log shipping?
- What is the difference between a local and a globa...
- What command do we use to rename a db?
- What is sp_configure commands and set commands?
- What are the different types of replication? Explain.
- What are the OS services that the SQL Server insta...
- What are three SQL keywords used to change or set ...
- What does it mean to have quoted_identifier on? Wh...
- What is the STUFF function and how does it differ ...
- Using query analyzer, name 3 ways to get an accura...
- How to rebuild Master Database?
- What is the basic functions for master, msdb, mode...
- What are primary keys and foreign keys?
- What is data integrity? Explain constraints?
- What are the properties of the Relational tables?
-
▼
May
(20)
No comments:
Post a Comment