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

What r sql reporting services and analysis services? how can we use it.

2 Answers   Microsoft,

How to start and end transact-sql statements?

0 Answers  

Questions on identity?

2 Answers   Infosys,

What is the full form of dql?

0 Answers  

What is the difference between count () and rowcount ()?

0 Answers  

What are statistics?

0 Answers  

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

0 Answers  

When a primary key constraint is included in a table, what other constraints does this imply?

0 Answers  

What is checkpoint process in the sql server?

0 Answers  

What are the triggers in sql?

0 Answers  

What is a view and what are its advantages?

0 Answers  

What do we have to check in database testing?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories