Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between logshipping and mirroring
- 1 Answers
- 5341 Views
- Microsoft, Syntel, I also Faced
- E-Mail Answers
Answer / 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 |
what is physical sort data and logical sort data in index?
What is an Index?
What is sql collation?
what is syntex second or third highest salary. thanks & Regards Dhirendra sinha
what are cursors? : Sql server database administration
What is a covering index?
Explain throw statement in sql server 2008?
What is the difference between having and where clause?
What is forward - only cursors / read only cursor?
How to delete the duplicate rows from a table in SQL Server ??
What is normalization and its types?
What are sql dirty pages?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
