What are the different types of backup avaible in SQL SErver
Answers were Sorted based on User's Feedback
Answer / senthilkumar
SQL Server provides several different kinds of backups
including Complete Backup, Differential Backup, Transaction
Log Backup, and File(s) and Filegroup(s) backup.
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / 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 |
Answer / devender reddy
The different types of backups in SQL Server are following:
Full Backup
Differential backup
Transcational log backup
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / koti
full,
differential,
transactional,
file group:-it is a backup in which the large databases are
separated as file groups. this is used in high level
organizations.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / pavan
full
differential
transaction
taillog
copy_only
mirror
files and file group
partial
| Is This Answer Correct ? | 1 Yes | 5 No |
What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.
What is the boxing and unboxing concept in .net?
How can you stop stored procedures from recompiling?
What is difference in performance between insert top (n) into table and using top with insert?
How do you use DBCC statements to monitor various aspects of a SQL server installation?
How to know the NAME of the Database and SIZE of the Database at the client node in Sql Server 2005
List the various tools available for performance tuning?
How to execute stored procedure in select statement sql server?
what stored procedure can you use to display the current processes? : Sql server administration
Do you know what is a linked server in sql server?
Do you know how to store and query spatial data?
Explain what is scheduled job and how to create it?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)