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
- 10701 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
can any body tell me how to know the password of current user in sql server
How do I find the size of a sql server database?
What is co-related sub query?
What is the recovery model? List the types of recovery model available in sql server?
What is an identity?
What is store procedure? How do they work?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
Does union all remove duplicates?
What happens if you are trying to access a schema not owned by you?
What is the default port for SQL Server over a firewall?
List the advantages of using stored procedures?
How to invoke a trigger on demand?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
How to insert and update data into a table with "insert" and "update" statements?
What is the difference between commit and rollback?
