Differences between logshipping and mirroring
- 1 Answers
- 4845 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
Can you explain what are various ways to enhance the ssrs report?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What is the log shipping?
How do you make a trace?
How to encrypt Strored Procedure in SQL SERVER?
Does a specific recovery model need to be used for a replicated database? : sql server replication
What is database architecture? : SQL Server Architecture
How do you rename a table in sql server?
What is the synonym of join?
How can we improve performance by using SQL Server profiler?
How to download and install microsoft .net framework version 2.0?
How do clustered indexes store data?
After removing a table from database, what other related objects have to be dropped explicitly?
Define self join in sql server joins?
What is difference between aggregate and analytic function?
