Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of backup avaible in SQL SErver
- 6 Answers
- 10293 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 is difference between rownum and row_number?
Can an entity have two primary keys?
When should you use an instead of trigger?
What stored procedure would you use to view lock information?
Describe in brief sql server monitoring ways.
What are the two authentication modes in sql server?
Define the one-to-one relationship while designing tables.
how to overcome kernel isssues
How do you manipulate data?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
What are the differences between user defined functions and stored procedures?
what is trigger
1 Answers CarrizalSoft Technologies, NIIT,
-
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)
