Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of backup avaible in SQL SErver
- 6 Answers
- 10032 Views
- Emphasis, IBM, I also Faced
- E-Mail Answers
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 types of user defined functions in sql server?
How to remove duplicate rows from table except one?
What happens if null values are involved in bitwise operations?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
Can a rule be bound to any column of any data type?
How much does sql server 2016 cost?
What are the types of database schema? : sql server analysis services, ssas
Equi join and non equi join is possible with sql server?
What is msdb database? : SQL Server Architecture
How to know the NAME of the Database and SIZE of the Database at the client node in Sql Server 2005
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
Explain about sql server login?
-
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)
