Explian different types of BACKUPs avaialabe in SQL Server?
Given a particular scenario, how would you go about
choosing a backup plan?
Answer Posted / 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 |
Post New Answer View All Answers
write an SQL query to list the employees who joined in the month of January?
What is exporting and importing utility?
What are different types of data sources?
How to use subqueries in the from clause in ms sql server?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
How to disconnect from a sql server using mssql_close()?
Why use cursor in sql server?
What are the components of sql server service broker?
How is sql server used?
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
Explain about Views?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
What are approximate numeric data types in ms sql server?
What is an identity column in insert statements?
Can we use custom code in ssrs?