Answer Posted / Subash Chandra Pandey
In SQL Server 2000, the recovery models are: Full (all data and transaction log are backed up), Bulk-Logged (bulk-logged operations consume less log space than the full recovery model but provide less recovery protection), and Simple (only full backups are performed and only the most recent backup can be restored; it does not support point-in-time recovery).
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a coalesce function?
List out the different types of locks available in sql server?
How do I find the sql server version?
What is standby servers? Explain types of standby servers.
Can we shrink data file in sql server?
Does view occupy space?
How do I find query history in sql server?
What are the source of constraints?
What are the different subsets of sql?
What is an indexed view?
What is sql server query analyzer?
Why we use the openxml clause?
What is a view in sql?
Can we do dml on views?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
