Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Explian different types of BACKUPs avaialabe in SQL Server?
Given a particular scenario, how would you go about
choosing a backup plan?

Question Posted / swapna

Answers were Sorted based on User's Feedback



Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would..

Answer / swapna

Types of backups you can create in SQL Sever 7.0+ are Full
database backup, differential database backup, transaction
log backup, filegroup backup.

Is This Answer Correct ?    13 Yes 1 No

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would..

Answer / 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

More SQL Server Interview Questions

Mention the different types of triggers?

0 Answers  

what is blocking? : Sql server database administration

0 Answers  

How will you collect the date from current date to last older 6 days date in sql server 2005

4 Answers  

How do you use DBCC statements to monitor various aspects of a SQL server installation?

1 Answers  

How many types of local tables are there in sql server?

0 Answers  

What is the primary use of the model database?

0 Answers  

How to skip remaining statements in a loop block using continue statements?

0 Answers  

Can anyone explain difference between Database, Data warehouse and Data mart with some example?````

4 Answers  

What is the purpose of using COLLATE in a query?

1 Answers  

What does it mean to have quoted_identifier on? What are the implications of having it off?

2 Answers  

Can you explain important index characteristics?

0 Answers  

What are trace files?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories