.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Question on Bulk-Logged Recovery Model

Posted By:      Posted Date: September 28, 2010    Points: 0   Category :Sql Server

After reading this MSDN article , I'm a bit baffled about how bulk operations are logged...

If data extents are used for log backup, what data will be logged? Won't it be the data at a stage after several committed transactions have already been performed on those extents?

Just for my better understanding of the concept: Isn't it necessary to log the extents containing data at the time the bulk operation occured?

Is this the reason why restore operations cannot be performed on a point-in-time basis?

Thanks for helping me understand...

View Complete Post

More Related Resource Links

TLog backup size in Full vs. Bulk logged recovery model.

When executing some minimally logged operations one can notice higher in TLog growth in Full recovery vs that of Bulk. But when it comes to talking a TLog backup one can notice its bigger (because the modified extents are also backed up along with TLog) Questions: 1. Are the pages backedup only those which were modified by minimally logged operation? 2. TLog backups in bulk recovery will be bigger than those from Full recovery but it depends if or not any minimally logged operations were done.

Bulk and full recovery model


hi team,


i have one dought,


in Full Recovery model have bulk log opertaions restore.

bulk log Recovery model also have bulk log operaions and bulk insert operations 


what are the difference in these two bulks could any body please explaine me.





BULK INSERT under the full recovery model


Hi Experts, is there any performance difference between BULK INSERT and row-insert operations under full recovery model? My database is configured as full recovery model, so I want to konw do I still try use BULK operations to modify data? Thanks!

SharePoint 2010 Content DB Recovery Model

Hello Everyone, the following link states that the content db for SharePoint 2010 uses simple recovery model. http://technet.microsoft.com/en-us/library/dd207314.aspx   whereas this link at SQL Server documentation says that Simple model is not suitable for production systems because it has risk of data loss http://msdn.microsoft.com/en-us/library/ms189275.aspx   These two look totally contradictory to me.  

Simple Recovery Model Yet Transaction Log Is Full

Hi there, There's a database which has been configured with SIMPLE recovery model but yet the transaction log will grow and fill up the disk at times. Is there anything one can do to prevent the log from filling up the disk? Thanks in advance.

Database Switched to Simple Recovery Model


Hi there,

We came across a situation where the transaction log was full and we extended the disk that holds the transaction log. What happened after that is the log truncated and we noticed the recovery model of the database switched from FULL to SIMPLE. Does anyone come across this behaviour?

Thanks in advance.


Yong Hwee

how to understand full recovery model can restore to the point of failure


if I backup log hourly, 50 minutes after last log backup, sql server corrupts, I guess I can only restore to the last tlog backup, how to understand restore to the point of failure?

also if I use simple recovery model, backup differentially every hour, do I have the same data protection? I know answer is no, but how to understand it?



WCF authentication/authorization model question


Hello community

I'm building a SOA application, wcf services and RESTFull asp.net/java clients. I want to authorize/authenticare each client and be able to authorize/authenticate users of each client. example :

  • there are 10 servies running under the main application.
  • company A is authorized to use 5 services.
  • company A users has 3 diffrent group and will access diffrent class/functions within the services proviced for company A.

I want to use webhttpbinding for RESTfull support and Ajax calls(jquery since i'll have java client aswell) along with authentication.

is that even possible to authorize client/users on a wsHttp or basicHttp binding and let them use webhttpbinding in another service with role provider or declarative  authorization?  can anyone suggest me what sort of authorization/authentication combination model shall I use?

simple recovery model, backup plan best practise

any guideline on backup plan for a simple recovery model? if there is no differential backup, only has daily full backup, when the sever crashes, will it lose all info after last backup? if the data file crashes, but log file exists ok, is it possible to restore info after last backup? such as tail log backup?

Model View ViewModel question



I´m playing around with XAML and MVVM, and have a question about the wiring between the model and the viewmodel:

If I have a model that updates its data on random times, what wiring is used between the model and the viewmodel to let the viewmodel know that the model has changed?.

Between the view and viewmodel a bindings and NotifyPropertyChanged would take care of this.


Trying to learn

database mirroring "log records from bulk-logged operations cannot be sent to mirror database"?


does this mean only when bulk recovery model or apply to full recovery model as well? if applys to full recovery model, how the mirror database be synchronized after bulk operation?

Recovery Model Indicator - Which system table?




I hope you can help as I am really scratching my head on this one.  I am pulling together an assessment of the Disaster Recovery readiness for an organisation I am working at.  Part of the assessment I am doing is the recovery model of each of the databases.


I have scripts that are already pulling lots of data from 40+ servers and 500+ databases.  However, I cannot seem to find anywhere within the MASTER or MSDB or the database itself where the Recovery Model flag is held.  Obviously I can right click on the database and click properties and it is there, but I need to automate this task (as it will probably be a weekly assessment).


I have checked sysdatabases and almost every other table, but nothing obvious as to where this flag is.


Any ideas? 

Recovery model in Search Server Express 2010 Databases



We have installed a Search Server 2010 Express. The Database is a SQL Server 2008 SP2 (Standard Version)

I'm not a SQL Crack, I am more the SharePoint specialist.

Now my question: Can I set the recovery model for all databases to "Simple" mode? (instead of full mode). Or is there any problem in functionality if i do this?

The default settings are, that some of this are simple and other databases are full.

Thanks a lot for your help.

Changing the Recovery Model.


I need to change the recovery model from Full to simple, what are the things that I need to do before changing the recovery model.


Is a database online when it is changed from full to simple recovery model?



We have some databases that occaisally have very large ldf files and I have learned that the best way to shrink the ldf file is to change the backup mode to simple, shrink the log file, convert it back to full and do a full database backup so that the log file backups will run again. My question is during this process is the database available to the end users? When you guys do this do you feel it is nessesary to let the end users know or will they not notice what is going on?



Thanks! Kevin

Transaction log filling up in "Simple" recovery model, catch 22


I need to do the quaterly cleanup of our database involving moving historical data to our history db and delete-ing records in a our operational datastore. I've set the recovery model to "simple" as advertised in numerous fora and KB articles. Still the the transaction log goes through the roof evertime I do a

delete * from myTable
where datetime < '2006-10-01'

Where eventually it fails becouse transaction log is full....(Msg 9002)

If I do a

BACKUP LOG myDatabase
TO myBackup

sql claims that I cannot perform a transaction log backup (Msg 4208). So I 'm stuck with a large log file in the "simple" recovery model that can not be shrunk...

Binding WPF Controls to an Entity Data Model

In this interview, programming writer, McLean Schofield, demonstrates how to bind WPF controls to an entity data model, using Visual Studio 2010 Beta 1. You can also learn more in the topic: Walkthrough: Binding WPF Controls to an Entity Data Model.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend