Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between logshipping and mirroring
- 1 Answers
- 5455 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 stored by the msdb? : sql server database administration
What is built-in function?
How to copy data from one table to another table?
Write an sql query to find the names of employees start with ‘a’?
How to provide column names in insert statements in ms sql server?
Define Check points and End Points?
How do you persist objects, permissions in tempdb
How exceptions can be handled in sql server programming?
Can sql servers link to other servers?
What is the difference between insensitive and scroll cursor?
How to select top 5 coloumn from a table without using coloumn name
What stored by the master? : sql server database administration
-
Oracle (3253) - 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)
