Explian different types of BACKUPs avaialabe in SQL Server?
Given a particular scenario, how would you go about
choosing a backup plan?
Answers were Sorted based on User's Feedback
Answer / swapna
Types of backups you can create in SQL Sever 7.0+ are Full
database backup, differential database backup, transaction
log backup, filegroup backup.
| Is This Answer Correct ? | 13 Yes | 1 No |
Answer / raghuram
different types of BACKUPS available in sql server are full
database backup, differential database backup,
transactional log backup, files and filegroup backup.
for new database we will go for full database backup, and
if the the database is in full database backup type,then we
do differential database backup or transactional log backup.
if the database size is too heavy means the database is
VLDB then we go for files and filegroup database backup.
| Is This Answer Correct ? | 5 Yes | 1 No |
What is the language structure to add a record to a table?
In join, which clause in not used?
How many types of stored procedures are there in sql server?
What is normalization of database? What are its benefits?
What is the fillfactor concept in indexes?
What is the latest version of microsoft sql server?
what is curser.
How to provide login information for a new odbc dsn?
What is the difference between DATETIME2 and DATETIME?
How to link tables in sql server?
What is difference between getdate and sysdatetime in sql server 2008?
can you any body tell me why are go for the rebuild the master database.what is the reason?
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)