What are the different types of backup avaible in SQL SErver
Answer Posted / amit kumar
Full - backups entire database
Differential - backups all changes since last full backup
Transaction Log - backups transaction log for all changes
since last transaction log backup
File - allows you to backup one data file
Filegroup - allows you to backup an entire filegroup
Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
What does select 1 mean?
Characterize join and name diverse sorts of joins?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
Explain different forms of normalization?
How to drop an existing stored procedure in ms sql server?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
Explain subquery and state its properties?
How to delete duplicate rows in sql server?
What method is used by the Command classes to execute SQL statements that return single values?
How to generate create table script on an existing table in ms sql server?
Tell me what are the essential components of sql server service broker?
What is the difference between ddl,dml and dcl commands?
Do you know what is difference between index seek vs. Index scan?
Tell me what is log shipping?