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.

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

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.

what are the joins,primary key,foriegn key, candidate key, super key and expain them?

6 Answers   Polaris,

---

Diffrent types of function

1 Answers   Wipro,

---

Why union all is faster than union?

0 Answers  

---

What is triggers and stored procedures?

0 Answers  

---

How to update a field in SQL after ALTERING a row?

0 Answers   Amdocs,

---

What do you mean by 'normalization'?

0 Answers   Ernst Young, Thomson Reuters,

---

How can you know if the row fetched from cursor is still valid in underlying table?

0 Answers  

---

Explain user defined functions?

0 Answers  

---

What is bcp? When does it use?

0 Answers  

---

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

0 Answers  

---

How to view existing indexes on an given table using sys.indexes?

0 Answers  

---

What is the diffrence between update_one and auto_fix?

3 Answers   IBM,

---