Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 244
  • Last Modified:

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
0
cur
Asked:
cur
  • 3
3 Solutions
 
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
 
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
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.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now