Answer Posted / 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

How to create a new table in a given schema?

1111

---

What do we have to check in database testing?

966

---

Do you know what are the reporting services components?

917

---

What are orphan records?

886

---

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

933

---

How to get a list of columns in a view using the "sp_columns" stored procedure?

984

---

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

913

---

What is resultset concur_updatable?

968

---

Explain syntax for viewing trigger?

884

---

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1011

---

Explain the disadvantages/limitation of the cursor?

914

---

How many categories of functions based their return modes?

1061

---

what is bit datatype? : Sql server database administration

863

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

855

---

How to add the custom code in Report?

117

---