Solved

SQL server recovery Mode : Full/Simple and bulk

Posted on 2014-04-23
4
224 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 143

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 143

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 143

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

Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server maintenance plan 8 53
How can I use this function? 3 32
selective rebuild of SQL Tables in scheduled job 10 37
Can I skip a node in XML? 9 31
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

740 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