Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between logshipping and mirroring
- 1 Answers
- 5367 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 |
Explain full-text query in sql server?
What is save transaction and save point?
What is a heap?
Write a sql query to sort on different column name according to the parameters passed in the function?
how to find maximum identity number in a table ?
2 Answers JPMorgan Chase, Thomson Reuters, Wipro,
How can sql injection be stopped? : sql server security
How to call a function from a stored procedure in SQL Server ?
How do you debug a procedure in sql server?
What is Schema? and why we use schemas?
How do I install only the client tools of sql server 2000?
sql server architecture ?
Explain the third normal form(3nf)?
-
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)
