Differences between logshipping and mirroring
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 are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
How to create a store procedure with encryption?
How can you list all the table constraints in a database?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
Do you know query execution plan?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
What do you mean by sql server 2005 express management tools?
What are the different subsets of sql?
How to check if stored procedure is running in sql server?
What does Master database contains?
How to invoke a trigger on demand?
Can we perform backup restore operation on tempdb? : sql server database administration
What are the types of user defined functions in sql server?
Difference between drill down and drill through report.
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration