Answer Posted / 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 different steps will a sql server developer take to secure sql server?

927

---

What is the use of nvl work?

946

---

What is isnull() operator?

973

---

Can we add an identity column to decimal datatype?

942

---

What do you think of this implementation? Can this be implemented better?

874

---

How to execute a sql statement using mssql_query()?

975

---

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

910

---

Define tool Manage Statistics in SQL Server 2000 query ?

1021

---

What is the web service used for reporting services?

114

---

How do I find the sql server database version?

939

---

What do you mean by an execution plan? How would you view it?

866

---

1 01 101 01010

2003

---

Explain steps of normalization?

939

---

How do you start single user mode in clustered installations?

901

---

What is triggers and stored procedures?

887

---