Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between logshipping and mirroring
- 1 Answers
- 5318 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 to check if a User database is locked?
Define left outer join in sql server joins?
What do you mean by the term 'normalization'?
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
Explain what is row_number function?
What is table constraint?
Explain aggregate functions?
How to check status of stored procedure in sql server?
When to use null data driven subscription?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
Explain about remote stored procedure?
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
What is the use of for clause?
What are the types of lock supported by ?
What is the default order of an order by clause?
