What are the different types of backups that exist?
- 1 Answers
- 1258 Views
- ADITI, I also Faced
- E-Mail Answers
Answer Posted / Sanjeev Kumar Aman
In SQL Server, there are several types of backups available. Full backup creates a copy of an entire database, including data files and log files. Differential backup only captures changes made since the last full backup. Transaction log backup captures transaction-level changes, allowing for point-in-time recovery. Copy-only backup creates a read-only copy of a database for reporting or testing purposes without affecting production data. Snapshot backup takes a snapshot of a database at a specific point in time and can be used to create read-only versions of databases.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is an indexed view?
Where can you add custom error messages to sql server?
What is sql server query analyzer?
Why should you use or avoid select * statements?
What kind of problems occurs if we do not implement proper locking strategy?
How to enter binary string literals in ms sql server?
What is sql or structured query language?
What are the kinds of subquery?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
Can sql servers link to other servers like oracle?
What are the source of constraints?
What is subquery? Explain the properties of a subquery?
What is the difference between for xml raw and for xml auto?
What is acid mean in sql server?
What are the different SQL Server Versions you have worked on?
