|
Posted by Erland Sommarskog on 10/02/42 11:46
KR (kraman@bastyr.edu) writes:
> What is the equivalent of the "Full Recovery Model" in sql 7? I see
> only two options - for recovery models - "Truncate at Check Point" and
> "Select Into/Bulk copy.
SIMPLE => "truncate log on check point" set.
BULK_LOGGED => "Select into/bulk copy" set.
FULL => None of them set.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|