Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between logshipping and mirroring
- 1 Answers
- 5351 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 |
Can you tell me the difference between DELETE & TRUNCATE commands?
Explain about integration services of Microsoft SQL server?
two tables are there.1st table EMP has two columns ID and name and contains data 1,A 2,B 3,C 2nd table EmpSal has 2 columns ID and Salary Contains data -1,1000 2,5000 3,3000 Find name of employee having maximum salary ?
What is the contrast between sql and mysql?
What sql server means?
What is the importance of concurrency control?
Can we join two tables without primary key?
What are different types of constraints?
How to create hyperlink from returned sql query ?
Why we need a group by clause?
What are the differences between char and nchar in ms sql server?
explain different types of jions with examples briefly?
2 Answers Accenture, Excellence, Zensar,
-
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)
