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

Question Posted / durga prasad

2 Answers
4945 Views
HCL, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / 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

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

Answer / laxman

that may recovery models:
simple
bulk-loged
full

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More SQL Server Interview Questions

i want to join two queries....and i want to run them as one after another that is want output of first query then second , then again output of first query then second and so on...

2 Answers

How to insert and update data into a table with "insert" and "update" statements?

0 Answers

What are subqueries in sql server? Explain its properties.

0 Answers

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

0 Answers

How do I view views in sql server?

0 Answers

i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?

5 Answers Aptech,

Explain about the command-line tool SQLCMD?

0 Answers

What are the different types of collation sensitivity in sql server?

0 Answers

What do you mean by acid?

0 Answers

What is Sqlpaging in SqlServer 2005 ?

0 Answers MCN Solutions,

How to Handle the exceptions in Sqlsrver 2005??

3 Answers Value Labs, Wipro,

Psudo colums

1 Answers HP,

For more SQL Server Interview Questions Click Here