Hi..here i would like to know the Backup and Restore models?

Answer Posted / naren

Back up we have full and defferential
(incremental),transaction log backups


Recovery models full,bulk, simple

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create stored procedures with parameters in ms sql server?

526


but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

525


Give me a SQL Query to find out the second largest company?

688


Does partitioning improve performance?

486


How to return the top 5 rows from a select query in ms sql server?

586






what is the difference between Delete and Truncate command in SQL

626


Explain Reporting Life Cycle?

90


whats new about truncate in sql server 2008?

2024


How to loop through result set objects using mssql_fetch_array()?

539


How to create a user name in a database?

584


Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2174


How do I find query history in sql server?

515


What are the restraints imposed on the table design by a merge replication?

564


What is difference between after and before?

505


Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

569