SQL server recovery Mode : Full/Simple and bulk

I am in the process of implementing sql mirroring and need to have the full database recovery mode  . few of the database on the simple mode and need to change me to do the mirroring

is it advisable to change simple to Full  ? please explain the each option outcome
curAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
the "bulk-logged" option is between, but very dangerous.
you can perform t-log backups, but the restores would only be able to go to the point of a bulk action, after which you need to perform a full restore.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
for mirroring, you indeed need full recovery mode.
when in full recovery mode, you will need to implement a very regular transaction log backup process, to avoid that the .ldf files would just grow endless, as it's exactly the t-log backup that will mark the space inside the .ldf file(s) as "reusable".

that's all of the side effects...
0
 
curAuthor Commented:
simple means no logs will create ? what is the practical usage of sql server bulk option
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
in "simple" mode, logs will be written, but immediately be marked as "overwritable".
in such mode, you can only perform full database backups and hence only full database restores.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.