can you any body tell me simple recovery,full recovery,bulk
logged recovery where can use?
Answer Posted / laxman
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 View All Answers
Can sql servers linked to other servers like oracle?
How to bind a view to the schema of the underlying tables?
Where sql server usernames and passwords are stored in a sql server?
What is a sql join?
What is self contained sub query?
What are horizontal and vertical scaling?
Explain some stored procedure creating best practices or guidelines?
What is default port number for sql server 2000?
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
what are the different ways to return the rowcount of a table?
Where in ms sql server is ’100’ equal to ‘0’?
Find first and last day of current month in sql server
How to apply cascading referential integrity in place of triggers?
What is full outer join in sql server joins?
Explain having clause?