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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recovery model full
- Thread starter peppe71
- Start date
nigelrivett
IS-IT--Management
Enterprise manager - database properties.
Or sp_dboption
======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Or sp_dboption
======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
- Thread starter
- #3
nigelrivett
IS-IT--Management
Oh sorry.
truncate log on checkpoint is the equivalent of simple recovery model so set that off.
This will allow tr log backups.
For select into bulk/copy - it's up to you - I would set it off unless youu need it.
======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
truncate log on checkpoint is the equivalent of simple recovery model so set that off.
This will allow tr log backups.
For select into bulk/copy - it's up to you - I would set it off unless youu need it.
======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
- Status
Similar threads
- Locked
- Question