database modes in sql server 7

Hi
Can some one give me a quickly if we have a FULL Mode in SQL server 7?
I do not see anywhere mention of Mode of the database unlike in sqlserver
2000.
Tks
MangeshThere is an option 'truncate log on checkpoint'
if this option is checked it would be similar to simple recovery model,
if not - transaction log would not be truncated until you will back it up
which is similar to full recovery model.
Regards
"Mangesh Deshpande" wrote:
> Hi
> Can some one give me a quickly if we have a FULL Mode in SQL server 7?
> I do not see anywhere mention of Mode of the database unlike in sqlserver
> 2000.
> Tks
> Mangesh
>|||Hi,
Recovery model is introduced only from SQL 2000. For SQL 2000 we have only
database options.
If you enable 'Truncate log on checkpoint' - equivalent to SIMPLE Recovery
If you do not enable 'Truncate log on checkpoint' - equivalent of FULL
recovery
We can not implement BULK_LOGGED recovery model in SQL 7
Thanks
Hari
SQL Server MVP
"Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote in
message news:129C4071-3B29-47D8-AD6A-78066D8EB1CF@.microsoft.com...
> Hi
> Can some one give me a quickly if we have a FULL Mode in SQL server 7?
> I do not see anywhere mention of Mode of the database unlike in sqlserver
> 2000.
> Tks
> Mangesh
>|||Thank you guys.
"Mangesh Deshpande" wrote:
> Hi
> Can some one give me a quickly if we have a FULL Mode in SQL server 7?
> I do not see anywhere mention of Mode of the database unlike in sqlserver
> 2000.
> Tks
> Mangesh
>|||To get a close to what full is in prior version, you need to have "select into/bulkcopy" turned on
as well.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote in message
news:A4C9050F-1F03-4533-A66B-96EDE8140324@.microsoft.com...
> Thank you guys.
> "Mangesh Deshpande" wrote:
>> Hi
>> Can some one give me a quickly if we have a FULL Mode in SQL server 7?
>> I do not see anywhere mention of Mode of the database unlike in sqlserver
>> 2000.
>> Tks
>> Mangesh