Explian different types of BACKUPs avaialabe in SQL Server?
Given a particular scenario, how would you go about
choosing a backup plan?
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
What does null mean?
how to control the amount of free space in your index pages? : Sql server database administration
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
What is a ddl statement?
What does sql server mean?
Is INSTEAD OF trigger directly applicable to Table ?
How you can find out if an index is useful to the optimizer?
Sql server reporting services vs. Crystal reports.
What command is used to delete a table from the database in the sql server and how?
What are data driven subscriptions?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What is the difference between stored procedure and functions?
how you can move data or databases between servers and databases in sql server? : Sql server administration
What are the advantages of sql stored procedure?
What are pessimistic lock and optimistic lock?