Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of backup avaible in SQL SErver
- 6 Answers
- 10434 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 |
How do I create a stored procedure in sql server?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
Tell me what is the stuff and how does it differ from the replace function?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What are the differences between left join and inner join in sql server?
How do you size a resultset?
1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"
How can you stop stored procedures from recompiling?
What is a group function explain with an example?
Can we add an identity column to decimal datatype?
What is precedence constraint?
How will u find the query which is running in some other machine
4 Answers CarrizalSoft Technologies, IBM,
-
Oracle (3253) - 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)
