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
How to create indexed view?
How do I start sql server 2017?
What are scalar functions?
What is the maximum number of index per table?
How real and float literal values are rounded?
can we have a nested transaction? : Sql server database administration
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
How many types of local tables are there in sql server?
What is difference between standardization and normalization?
What is not null constraint?
What is the difference between primary key and unique constraints?
How are the exceptions handled in sql server programming?
What are trace files?
How do I know if localdb is running?