Explian different types of BACKUPs avaialabe in SQL Server?
Given a particular scenario, how would you go about
choosing a backup plan?
Answer Posted / 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 |
Post New Answer View All Answers
Explain about builtinadministrator?
What is the importance of three tier architecture?
what is a self join? : Sql server database administration
What does truncate do?
What is a field name?
How fixed length strings are truncated and padded?
How do you Implement SSIS Packages in your Project?
What stored by the tempdb ? : sql server database administration
What is difference between aggregate and analytic function?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
When you use @@error and try-catch?
what are the disadvantages of cursors? : Sql server database administration
How to list all schemas in a database?
What is default constraint in ms sql server?
What is BCNF? How is it better than 2NF & 3NF?