TheBugSlayer
Programmer
I cannot remember where/how to see/change the recovery model in SQL Server 7, does anybody do?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Where to see/change recovery model in SQl 7?
- Thread starter TheBugSlayer
- Start date
- Status
RobertT687
Programmer
In SQL 7.0 the option 'Truncate log on checkpoint' set to false is equivalent to 'Full'.
I think recovery models by name are in SQL 2K and above.
In EM, right click on the database, pick Properties. About mid-way down is the Recovery heading.
I think recovery models by name are in SQL 2K and above.
In EM, right click on the database, pick Properties. About mid-way down is the Recovery heading.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
