Link to home
Create AccountLog in
Avatar of motioneye
motioneyeFlag for Singapore

asked on

sql2005 bulk logged recovery mode vs FULL recovery mode

Giving example that I'm going to update a records under bulk logged recovery which consist of 1000 records as following:
update TableA set columnA='Test' where columnB=1
Or do the same statement but in FULL recovery mode, so what will be a different here?? will that means when I do this kind of update with FULL recovery mode, is that means row based recovery is applied ?

ASKER CERTIFIED SOLUTION
Avatar of TAB8
TAB8
Flag of New Zealand image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer