what are the problems in logshipping?

Answers were Sorted based on User's Feedback



what are the problems in logshipping?..

Answer / d patel

- Logshipping failover is not automatic process. DBA must
sitll muanually do. that means DBA must be present when the
failover occurs

- The users will experience some downtime. How long depends
on how well you implement log shipping

- Some data will be lost

- The database that are being failed over to the standly
server cannot be used for anythings.

Is This Answer Correct ?    39 Yes 7 No

what are the problems in logshipping?..

Answer / chhavi...sql server dba_431,44

Let me rephrase it first...Limitation in logshipping...

1. Automatic failove is not possible.
2. There will be some data loss because you can't configure
the backup job to run less than 2 minutes.

But insted of these limitation we have many advantages:
1. We can configure the restore job to run with sufficint
delay to recover from user's error.
2. We can have more number of secondaries
3. Also provide log backup backup which can be utilize in
point in time recovery

Is This Answer Correct ?    21 Yes 2 No

what are the problems in logshipping?..

Answer / parker

Logshipping is a new feature of SQL Server 2000. We should
have two SQL Server - Enterprise Editions. From Enterprise
Manager we can configure the logshipping. In logshipping
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
and we can use this as the DR (disaster recovery) plan.

Is This Answer Correct ?    28 Yes 12 No

Post New Answer

More SQL Server Interview Questions

what is the purpose of creating view is sql server 2000

13 Answers   Wipro,


what is isolation level at dead lock?

0 Answers   Verizon,


What is user-defined function?

0 Answers  


How is sql server used?

0 Answers  


What is always encrypted?

0 Answers  






What is difference statement and preparedstatement?

0 Answers  


How to delete an attribute from the emp table

4 Answers  


how many type of subquery?

2 Answers  


What is difference between equi join and natural join?

0 Answers  


find the 3rd max salary

10 Answers  


what authentication modes does sql server support? : Sql server database administration

0 Answers  


write sql program to get the detail of student in a class?

2 Answers  


Categories