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 is the concept of optimization?

0 Answers  

Can you explain powershell included in sql server 2008?

0 Answers  

How are the exceptions handled in sql server programming?

0 Answers  

What is mscorsvw.exe - process - microsoft .net framework ngen?

0 Answers  

Can a synonym name of a table be used instead of a table name in a select statement?

0 Answers  

What is deadlock and how to avoid the deadlocks.

3 Answers   TCS, Wipro,

You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

0 Answers  

What is row-level compre?

0 Answers  

Tell me what is the stuff and how does it differ from the replace function?

0 Answers  

How to check if stored procedure is running in sql server?

0 Answers  

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

0 Answers  

What are the disadvantages of indexes?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories