What are the different types of backup avaible in SQL SErver

Answer Posted / koti

full,
differential,
transactional,
file group:-it is a backup in which the large databases are
separated as file groups. this is used in high level
organizations.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between row_number and dense_rank?

442


Mention the different types of triggers?

549


How to test a dml trigger in ms sql server?

579


How to create a new login name in ms sql server?

549


What is self contained multi valued query?

556






What are entities and relationships?

556


What are the various editions of sql server 2017 that are available in the market?

503


What are the purposes and advantages stored procedure?

499


Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

530


What is sqlcmd?

555


What is difference between after and before?

505


Do you know what are acid properties?

570


What is a domain constraint give an example?

565


How we create SQL Server 2005 Reporting Services ? Give me Sample

1573


what does the automatic recovery do? : Sql server administration

538