January 22, 2004 at 1:54 pm
Recovery mode is different between SQL2k and SQL7. If I want to turn on 'full' recovery mode on SQL7, which option should be checked, 'Truncate log on checkpoint' or ' Select into/bulk copy'?
January 22, 2004 at 1:56 pm
Trun off both 'Truncate log on checkpoint' and ' Select into/bulk copy' will set database in 'Full' recovery mode.
January 23, 2004 at 12:44 am
In addition to Allen Cui's reply :
' Select into/bulk copy' will alow non-logged operations.
This will have some recovery disadvantages.
Check SQL7 BOL.
found this in my sql-log :
The Select Into/Bulk Copy option allows non-logged operations to take place within the database. This option should only be used in production environments under controlled conditions — if you want to recover the database, you must dump the database in full after non-logged operations.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply