What are the different types of backup avaible in SQL SErver

Answer Posted / hari

Full Backup
Differential backup
Transcational log backup

Is This Answer Correct ?    18 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is nonclustered index on computed columns?

569


what is the system function to get current user's user id? : Sql server database administration

546


Difference between report and query parameter.

598


Explain the difference between primary keys and foreign keys?

509


What is schemabinding a view?

523






What is 4nf in normalization form?

562


What is the difference between a fill factor of 100 and 0?

528


What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

582


What do you understand by coalesce in sql server?

494


Why use “pivot” in sql server?

621


how you can move data or databases between servers and databases in sql server? : Sql server administration

481


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

1848


as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

534


How can a user-defined datatype be created?

538


How to divide query output into multiple groups with the group by clause in ms sql server?

563