.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

Differential VS Tranaction Logs

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server




Can some one let me know the differencies between different Backup models. Full, Differential and Transactional. I am more confused, when to use the Differential and Transactional log backups? How they both differ?


How the backup models depend on the database recovery model? Can i recover my database if my database recovery model is SIMPLE using a FULL backup?


I would appreciate if someone can explain it with an example and share the best practices.




View Complete Post

More Related Resource Links

Toolbox: Database Audit Logs, Joel on Software, Code Handouts, and More


This month the Toolbox column takes a look at database logging, Joel Spolsky's blog, printing code projects, and ASP.NET reading.

Scott Mitchell

MSDN Magazine May 2008

Toolbox: Generate Office Documents, Monitor Event Logs, and More


Most data-driven Web sites are used as interfaces to collect, process, and summarize information. Reports that summarize the data can be presented to the user in a variety of formats-the most common way is to display the report directly in a Web page.

Scott Mitchell

MSDN Magazine June 2006

Office: Relive the Moment by Searching Your IM Logs with Custom Research Services


Often, IM conversations contain important information you'd like to keep and reuse. Fortunately, MSN Messenger 6.2 has a feature to keep a conversation history permanently in XML format. This article shows you how to leverage that conversation history by consolidating IM exchanges so they are indexed, searchable, and ultimately reusable using the Microsoft Office 2003 Research and Reference task pane.

John R. Durant

MSDN Magazine February 2005

"Content for this URL is excluded by the server because a no-index attribute." in crawl logs


Hi All,

I am getting following error message in Crawl Logs

" Content for this URL is excluded by the server because a no-index attribute. "

Any help in this regard will be greatly appreciated.



'There is no Web named' in logs


I was wondering if anybody could help me.  When i look at logs in C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\LOGS i get a lot of errors saying 'There is no Web named'.

For example:-
09/08/2008 09:29:37.17  w3wp.exe (0x1BA0)                        0x296C Windows SharePoint Services    General                        8kh7 High     There is no Web named "/quality/Audit Reports/Forms/AllItems.aspx". 

There are no errors in server application event log.  I was hoping to find out what this means and if i should worry about the errors. 


Chris Rees.

Sharing folders under 12\logs


Hi Admins, 

I have a general question.  developer team does not have direct access to server. But they frequently need to dig logs for errors. (yes we have a test server but when switched to prod. environment, programs sometimes give errors that are need to be digged in prod)

Is it ok to "share" the folder program files\common files\microsoft shared\web server extensions\12\logs folder, so they can map the Web front End's logs folder to their computers ?

I dont really think it sounds good to make a sharing on production server like this,it is a sort of customization, I need your advices. is there a significant disadvantage that causes "don't!!" for this kind of operation?


Thanks in advance..


Re-run WSS 3.0 Usage Analysis Logs


WSS3.0SP2, 64-bit.

The service which runs and collects the log files for the Usage Analysis report was disabled for some reason. We have it re-activated but the logs for when it was down were not processed. How do we re-process those older logs?

Previously asked at  http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?&lang=&cr=&guid=&sloc=en-us&dg=microsoft.public.sharepoint.windowsservices&p=1&tid=f676c989-a369-4761-94e7-ef9b1c28fde7 and referred to here.

SQL Server Logs too big under Management

Hi, The sqlserver logs ("Current - date","Archive-date"...) is too big to open easily (esp at the time of crisis). Any idea how can I restrict the size of these logs to manageable size so that they can be read immediately? Is there any way to Archive daily logs separately? Thanks Chander

Sharepoint and IIS/Windows Event Logs in a single view

Hi - I'm coinsidering addng sharepoint log reading capabilities into an application I've built for reading windows and IIS logs (for more info http://logenvy.com). I know there are quite a few applications capable of reading sharepoint logs (a number are listed here http://stackoverflow.com/questions/781179/sharepoint-2007-log-viewer). Does anyone think the capability to analyse windows and IIS logs alongside sharepoint logs would be useful, or have any logging requirements not well met by the current set of tools? I'm especially keen to explore useful/interesting data visualizations on top of data logs.

Differential Backup

I have SQL Servers both 2000 and 2005 and I wanted to perform backups daily, so I want the backups to have Datetime stamp therefore I can distinguish between the different files. I have 2 questions 1.I'm going to use the following script to run a full backup on the sql 2005 server but I wanted to know if there is a way to perform the same thing in the sql server 2000 server. declare @CheckDate [nvarchar](50), @Title [nvarchar](100) set @CheckDate = replace(replace(convert(nvarchar(50),getdate(),120),':',''), ' ', '_') set @Title = N'E:\DataWarehouse_Microstrategy_'+@CheckDate+''+'.bak' BACKUP DATABASE [DataWarehouse_Microstrategy] TO DISK = @Title WITH NOFORMAT, INIT, NAME = N'DataWarehouse_Microstrategy-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,STATS = 10 ; 2. I need to perform a differential backup for both on sql 2000 and sql 2005 and I wanted to know a way of doing the differential backup but delete files that are old e.g any files that are older then 4 weeks. Thank you in advance

Logs are written only on one WFE

Hi,h I have a four server farm. 1 db server and 3 wfe's. They are not load balanced. the log level is  "verbose".. however, only one wfe is writing logs. I mean, on the first WFE there are 3 log files under 12\logs and there are about 100 gb each. The other WFEs have three logs but they are 10kb  !!! Is this normal?? Why is that happening

Effect of error logs

Hi, I just came across a situtation where one of my application is trying to connect SQL box and is failing because of permission. It is writing audit failure to the Error log file. Can anyone please explain what would be the effect of this continous writing to error log. Does it affect performance of SQL Server in any ways or if there is a way i can check.Regards, Deven ----------------------------------------- Please vote if you find any of my post helpful.

Incorrect number of users reported in SharePoint Usage Logs

* See last post - issue appears related to KB 969231 *   It seems SharePoint 2007 usage logging with anonymous access worked in IIS6 but not IIS7. Is there a way to fix it?   Background: The SharePoint Usage logging was working fine (approximately 20,000 hits per day) until the upgrade to a new IIS7 environment. The configuration in both environments is very similar (both Anonymous Access and Windows Authentication are enabled) however the new environment is only showing 600 hits per day.   This forum response from Cornelius J. van Dyk [MVP] suggests that Usage analysis/logging with Anonymous Access doesn't work, however it does work in our old IIS6 environment (a dash "-" is just shown in the usage logs which suggests an anonymous user): http://www.eggheadcafe.com/software/aspnet/29823445/sharepoint-doubt-is-there-any-way-to-find-out-how-many-users-have-logged-in-to-the-sharepoint-site.aspx   So I've concluded it's differences in IIS6/IIS7 authentication. Reading articles on the differences (e.g.  single auth pipline instead of two-stage) doesn't highlight any obvious reasons why this wouldn't work.   Any help would be greatly appreciated.   Thanks,   Peter

SQL 2005 LSBackup_SID transaction logs hung...

Hello folks, I've searched google dry.. I feel as if I am the only one with this issue (hope not)!!.. for some reason my transaction logs stopped generating files via the job LSBackup_sid, i had my log shipping very nicely setup my secondary DB was in (restoring mode) LScopy and LS restore were running quite nicely but not the LSbackup_sid job on the primary simply stopped creating transaction logs to any shared folder I point it to. I have tried to redo all the shipping log process, I have tried pointing it to a different path, i even restored my secondary DR database and brought it up with SAP to see if I can get my trn files back on the primary.. there simply is no error on the LSBackup job it just says running forever: see below   Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted 09/07/2010 00:22:01,LSBackup_PAB,Unknown,,,LSBackup_PAB,,,In progress,00:00:18.4770000,,,,,, 09/07/2010 00:21:43,LSBackup_PAB,Unknown,1,DBGRPNEW,LSBackup_PAB,Log shipping backup log job step.,,2010-09-07 00:21:48.30 Backing up transaction log. Primary Database: 'PAB'<c/> Log Backup File: '\\sapprd2\bckp_drc\PAB_20100906212148.trn',00:00:05,0,0,,,,0 09/07/2010 00:21:43,LSBackup_PAB,Unknown,1,DBGRPNEW,LSBackup_PAB,Log shipping backup log job step.,

CustomError Mod Logs redirects me to Logout

I have a bug in which, whenever an error occurs the user seems to get logged out.  After much research I find that the situation is not so simple:(note I have dumbed these down a bit to make it easier to follow)Web.config - I turn on Custom Error Mode               <customErrors mode="On" defaultRedirect="ExceptionPage.aspx" >       <error statusCode="404" redirect="PageNotFound.aspx"/>     </customErrors >              <customErrors mode="On" defaultRedirect="ExceptionPage.aspx" >      <error statusCode="404" redirect="PageNotFound.aspx"/>    </customErrors >Global.asax - I save the Last Error so I can access it easily later on the error page    void Application_Error(object sender, EventArgs e)    {        Exception oEx;                oEx = HttpContext.Current.Server.GetLastError();                HttpContext.Current.Session["LastException"] = oEx;}ExceptionPage.aspx - Show a nice error message protected void Page_Load(object sender, EventArg

Same Application On The Same IIS Logs User Out

Hi,I have identically same applications on the same IIS. But when I login one, the other logs me out by IIS.Event Viewer logs this error:Event code: 4005 Event message: Forms authentication failed for the request. Reason: The ticket supplied was invalid. Event time: 07.09.2010 17:00:51 Event time (UTC): 07.09.2010 14:00:51 Event ID: a87e86a77ab641a99dcb2904765eb658 Event sequence: 24 Event occurrence: 21 Event detail code: 50201  Application information:     Application domain: /LM/W3SVC/1/ROOT/ECZKariyer-5-129283414711424580     Trust level: Full     Application Virtual Path: /ECZKariyer     Application Path: C:\inetpub\wwwroot\ECZKariyer\     Machine name: BIZALPERE  Process information:     Process ID: 2040     Process name: w3wp.exe     Account name: NT AUTHORITY\LOCAL SERVICE  Request information:     Request URL: http://localhost/ECZKariyer/loginpage.aspx?ReturnUrl=Forms authentication failed for the request. Reason: The ticket supplied was invalid.fECZKariyerForms authentication failed for the request. Reason: The ticket supplied was invalid.fscreen.aspx     Request path: /ECZKariyer/loginpage.aspx     User host address: ::1     User:      Is authenticated: Fa

MOSS Search Differential Backup

With the SharePoint 2007's built-in backup tool, will it do differential backup on databases and file system? File system as is Search index files?
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