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 maximum size of a dimension? : sql server analysis services, ssas

0 Answers  

What are the types of user defined functions in sql server?

0 Answers  

What are indexes in ms sql server?

0 Answers  

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers   Cognizant,

plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005

3 Answers  

Will the writetext statement activate a trigger?

0 Answers  

Give an example of why you would want to denormalize a database

0 Answers  

wat new abt truncate in sql server

2 Answers   HCL, HP,

What is the purpose of grouping data in a report?

0 Answers  

How to check table values in sql server?

0 Answers  

How to find the date and time of last updated table?

3 Answers  

What is a DBMS, query, SQL?

0 Answers   Maveric,

For more SQL Server Interview Questions Click Here
Categories