Solved

SQL server recovery Mode : Full/Simple and bulk

Posted on 2014-04-23
4
219 Views
Last Modified: 2014-05-12
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
Comment
Question by:cur
  • 3
4 Comments
 
LVL 142

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 180 total points
ID: 40017185
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
 

Author Comment

by:cur
ID: 40017191
simple means no logs will create ? what is the practical usage of sql server bulk option
0
 
LVL 142

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 180 total points
ID: 40017202
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
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 180 total points
ID: 40017204
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

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question