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

Question Posted / durga prasad

2 Answers
5025 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

What should be the fill factor for indexes created on tables? : sql server database administration

0 Answers

Can you explain some of the DTS problems?

1 Answers UBS, Wipro,

What is the difference between a local and a global temporary table?

0 Answers

What is the new security features added in sql server 2016? : sql server security

0 Answers

Can foreign key be deleted?

0 Answers

Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY

5 Answers TCS,

What will happen if a column containing char type data is changed to the nchar data type?

0 Answers

What are sub-queries? Give example? In which case sub-queries are not feasible?

4 Answers Infosys,

What is a Trace frag?Where can we use this?

1 Answers

What is the difference between for xml raw and for xml auto?

0 Answers

What is difference between clustered and non clustered index?

0 Answers

Tell me about joins in database system and explain each in detail.

0 Answers Axtria, ITC Indian Tobacco Company,

For more SQL Server Interview Questions Click Here