can you any body tell me simple recovery,full recovery,bulk logged recovery wh

can you any body tell me simple recovery,full recovery,bulk
logged recovery where can use?

Question Posted / prasadhari_m@yahoo.com

1 Answers
3811 Views
I also Faced
E-Mail Answers

can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?..

full - every transaction will be recorded in t-log
bulklog - bulk transactions like select into will not be
recorded in t-log
simple - no logs will be recoreded.

Is This Answer Correct ?

3 Yes

0 No

Post New Answer

More SQL Server Interview Questions

What is compression - row-level and page-level compression?

0 Answers

Define master database?

0 Answers

Explain what is row_number function?

0 Answers

please give me query code of unique fuction select UNIQUE (name) from emp_info Incorrect syntax near the keyword 'UNIQUE'.

1 Answers TCS,

When I delete any data from a table, does the sql server reduce the size of that table?

0 Answers

Can one drop a column from a table?

0 Answers

What is BLOCK statements in SQL?

0 Answers HCL,

What is exporting utility?

0 Answers

How to insert data with null values?

0 Answers

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

0 Answers

What method is used by the Command classes to execute SQL statements that return single values?

0 Answers B-Ways TecnoSoft,

How to rebuild all indexes on a single table?

0 Answers

For more SQL Server Interview Questions Click Here