Explian different types of BACKUPs avaialabe in SQL Server?
Given a particular scenario, how would you go about
choosing a backup plan?
- 2 Answers
- 9833 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
Do you know what are the ways available in sql server to execute sql statements?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
What is Federation and Federation Member?
How do I port a number to sql server?
What is temporal table?
What are Spatial data types in SQL Server 2008
Explain the categories of stored procedure?
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
What is a derived table?
What is the difference between inner join and equi join?
Can one drop a column from a table?
Tell me in brief how sql server enhances scalability of the database system?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
How can you set the threshold at which sql server will generate keysets asynchronously?
Are resultset updatable?
