What is log shipping? Can we do logshipping with SQL Server
7.0 - 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.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What are the Pre Requisites when you apply Srvice Packs?

1 Answers   IBM,


What is schemabinding a view?

0 Answers  


What is the sql case statement used for?

0 Answers  


What is The Use Of TIMESTAMP DataType in SQL Server 2005?

6 Answers  


I have a table Events Events containing cardno,time,id,name- -each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

0 Answers  






What is the template in sql?

0 Answers  


What are Spatial data types in SQL Server 2008

0 Answers   Infosys,


What is a NOLOCK?

3 Answers   NA,


What would be the Expected Salary For SQL Server Developer for 3 years exp. as per indian market?

7 Answers  


What are the parts of a function?

0 Answers  


select empid empname from employee What is the result for the about query?

4 Answers  


how to avoid cursors? : Sql server database administration

0 Answers  


Categories