Differences between logshipping and mirroring
- 1 Answers
- 4665 Views
- Microsoft, Syntel, I also Faced
- E-Mail Answers
Answer Posted / amit kumar sharma
Logshipping: Database are restored using the transition log
maintained by the db. If db dosen't maintained the
transition log then you will not able to restore the db.
Set Maintain Transition log of db to 'true' in db
environment variable.
Mirroring : Its just a spanshort of the actual database at
some schedule interval. or rather say just a copy of LDF
and MDF file taken at a particular time.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
1 01 101 01010
How network traffic be reduced by using the stored procedure?
What is catalog views?
What is temporary stored procedure?
Define normalisation?
What is the difference between composite index and covering index?
Do you know what is sql service broker?
Why are sql functions used?
What samples and sample databases are provided by microsoft?
List out the difference between union and union all in sql server?
Can you explain what are various ways to enhance the ssrs report?
What does it mean to manipulate data?
Explain timestamp datatype?
How many types of subqueries are there in sql server?
What is the use of keyword with encryption. Create a store procedure with encryption?
