Differences between logshipping and mirroring
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 |
How to delete exactly duplicate records from a table?
What is read uncmmited?
Define the term DML, DDL and DTL?
What is the difference between a primary key and a unique key? Are they the same?
Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.
How do we rollback the table data in SQL Server
What does it mean to be in union?
What is order of B+tree?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
Which is best Subquery (or) joins in sql server? explain why
What does select 1 mean?
What is an expensive query?