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 is the purpose of optimization?
Can sql servers link to other servers?
How to divide query output into multiple groups with the group by clause in ms sql server?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
Can you tell me some of the common replication dmv's and their use? : sql server replication
What is unpivot?
What are rows and columns?
Why can there be only one clustered index and not more than one?
What are different types of replication in sql server?
How many database files are there in sql server 2000?what are they?
how many no of arguments can be passed in procedures and functions
What are various aggregate functions that are available?
How many levels of sp nesting is possible?
What is the openxml statement in sql server?
What is trigger in salesforce?