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.
| Is This Answer Correct ? | 28 Yes | 12 No |
Post New Answer View All Answers
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
How check triggers in sql server?
Can we insert data if clustered index is disabled?
What does the update command do?
Do you know what is sql service broker?
What command is used to delete a table from the database in the sql server and how?
What are basics of policy management?
Explain contrast amongst grouped and non-bunched records?
What is the cartesian product of the table?
How to provide values to user defined function parameters?
whats the maximum size of view state??
Explain error and transaction handling in sql server?
Does table partitioning improve performance?
What are the instances when triggers are appropriate?
