Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between logshipping and mirroring
- 1 Answers
- 5252 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
What is an index. What are the types?
How to declare and use cursor variables?
How to check status of stored procedure in sql server?
Does view occupy space?
How to see existing views in ms sql server?
What is 'Join' and explain its various types.
What are the different sql server versions?
What are key constraints?
What is difference between global temporary tables and local temporary tables?
what is blocking? : Sql server database administration
What is deploy, process and build? : sql server analysis services, ssas
How to display a past time in days, hours and minutes?
How do you drop an index?
What is precedence constraint?
Why main is user defined function?
