Interested to Buy Any Domain ? << Click Here >> for more details...
Explian different types of BACKUPs avaialabe in SQL Server?
Given a particular scenario, how would you go about
choosing a backup plan?
- 2 Answers
- 10692 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / raghuram
different types of BACKUPS available in sql server are full
database backup, differential database backup,
transactional log backup, files and filegroup backup.
for new database we will go for full database backup, and
if the the database is in full database backup type,then we
do differential database backup or transactional log backup.
if the database size is too heavy means the database is
VLDB then we go for files and filegroup database backup.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Write SQL queries on Self Join and Inner Join.
How to create a dml trigger using create trigger statements?
How to create new databases with "create database" statements?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
What is use of @@ spid in sql server?
Can you explain what is indexed view? How to create it?
What is an entity-relationship diagram (erd)?
How much memory that we are using in Logshipping Concept?
What method is used by the Command classes to execute SQL statements that return single values?
What is the difference between createstatement and preparedstatement?
What are the main sources of data?
What is the difference between Normalization and De-normalization?
Mention the differences between substr and charindex in sql server.
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
How to convert numeric values to integers in ms sql server?
