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
what are the core components of SSRS?
Can we use where clause in union?
What gets stored inside msdb database?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
What is an indexing technique?
Can you explain powershell included in sql server 2008?
What are the source of constraints?
What is view in sql?
Can coalesce return null?
Why I can not enter 0.001 second in date and time literals in ms sql server?
What is rank function?
What is left outer join in sql server joins?
Explain Geometry datatype in sql server 2008 with example
What is a scheduled job or what is a scheduled task?
Give main differences between "Truncate" and "Delete".