Solved

SQL server recovery Mode : Full/Simple and bulk

Posted on 2014-04-23
4
226 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

738 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