.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

User who truncated the log file

Posted By:      Posted Date: October 22, 2010    Points: 0   Category :Sql Server

Hi All,

I check the size of my log file everyday, yesterday it was 10GB. But today when i checked it was just 5MB.

The database is set up in FULL Recovery mode on Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)   Feb  9 2007 22:47:07   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2) .

I checked my backuphistory and logs but there is no log back up taken.

My question is how to reverse engineer this so that i can know who took a log backup and who shrinked the log file.

Any suggestion!!!!

Regards, Deven ----------------------------------------- Please vote if you find any of my post helpful.

View Complete Post

More Related Resource Links

User validation Issue in xlsx file



I am validating user from Login.xlsx file. It was working fine by validating email and password from that file. For testing i got new file same contents of file but added some more user names.

So after that when i validating the user i am getting the following error "Data type mismatch in criteria expression".

But when i replaced the new to old one it is working fine. The contens of both files are the same. So why this kind of error happened.


how to know when a user finish his file download successfully ?


hi all

i am doing a page to sell files online

 the paying method is by a card or bank account and the customer is not registered to the site so i want to make sure that the customer has downloaded the file successfully after that the system completes the payment operation

so if there is any way to know do that tell me please

i use c# thanx all



file upload in Create User Wizard Created User event with UpdatePanel Tag wont work?



In my Create User Wizard1 Created User Wizard Event, I am collecting extra information from text boxes and allowing

the user to uplad a file.



I have put the Submit button within an Update Panel Tag but since I have done this it does not work.

Is there a way round it. In this situation would you use a trigger.?


<br />

  <asp:UpdatePanel ID="UpdatePanel2" runat="server">

  <asp:Button ID="StepNextButton" runat="server"  CommandName="MoveNext"  align="middle"
                                            Text="Submit my Profile" />

user.identity.name="0" when uploading file using ajaxToolkit:AsyncFileUpload

hi, i am using AsyncFileupload to upload user picture. after the picture is uploaded and saved i opened another page and i noticed that the user.identity.name is lost. any idea 

if ssis package writes to excel file that might be open by a user

I have written a package that writes to an excel file to a network folder. Eventually this package will run as a job. What is the best way to handle the situation where someone opens the file or inadvertantly leaving it open while the package is running and and stop the package.? No one needs to modify or write anything to this file after it is finished

How to manually set which localization file (resx) to load up depending on user

Hi,I want to use localization as user base and not language base.  I would like to name my resx to default.aspx.ABC where ABC is the user's name.How do i manually specify which resx file the page should load up?  Thanks

what is the better design for location of system database data / log files and user data/log file,

is there a guideline for better performance for system database data location log location, like tempdb location etc. also better location for user databases/data and log.

Why is the "attach file" control not active, if I try to upload a file as an anonymous user within a

Hi everybody! We try to design an online application form and implement an infopath form over a form webpart! Meanwhile, I'm able to see the form as an anonymous user and I can enter the specific informations, but unfortunately I'm not able to attach a file, because the control is not aktive! Does someone have an idea, why?   Thanks for your replies    

Problem while 2 User write in a File a the Same time


Hi Everyone
I am facing a problem while a user is going to write in a file. My question is that if a User A open a file and start writing in file usin FileStream, if at the same other user try to access this file and try to write in it then he should wait until User A does not complete his work and close writer object.  Waiting for quick response. It is very urgent. Thanks in advance.


File upload control and not permitting user to upload over 500px in WIDTH ??




I have a file upload control on my page with a regular expression validator that handles the file format.


Users can upload files but I want the maximum WIDTH size to be 500px.


If any bigger I need to show a message advising the width is to great and stops them.


Thanks for any solutions



The file 'document name' has been modified by user name on 'date'



After modifing the document, if the user edit the document properties and save, it shows error like,

The file 'filename' has been modified by 'user name' on 28 Sep 2010 17:21:04 +0530 .

what is this means? how to resolve this, Please guide me. thanks in advance.


custom handler caching user file


i have a custom handler which captures user's book mark entry. To debug this handler, i have created a file "test1.txt" in code behind which saves the user entry. After the debug, i removed the text file (test1.txt) then re-complied the web app and deployed new DLLs for the site. But, the site is still looking for test1.txt file. i dont know how to confirm if the handler is really removed from the new DLL. Also, looked at the handler code behind file and didn't find any entry with test1.txt. So, i had no clue where this is sitting?

Anyone tried using LDIF file in the User Profile Synchronization Process?


Microsoft pushied an article recently talking about using LDIF file in the SharePoint's user profile synchronization. 

Configure profile synchronization using a Lightweight Directory Interchange Format (LDIF) file (SharePoint Server 2010) http://technet.microsoft.com/en-us/library/ff959234.aspx

Currently I am unable to obtain the required "Replicate Directory Change" permission set up by the AD admin.  So I thought of exploring this alternative since I still have AD search permission right now.

So far, I was able to set up the MOSSLDAP-LDIFMA, and use an import.ldif file to add, remove and update user profiles.  However, there are some problems that I can't resolve.  One of key problems is, the LDIF-imported records can't be sync'd with login-based records.

In my environment, when a user login SharePoint via Windows authentication, a new profile would be added, under the account name "domain\username".  Meanwhile, when an LDIF record imported, there will be another profile created under the account name "domain:domain\username", or "domain:username".  That is, there would be two profiles for each user.

Based on my understanding, it is very likely the user profil

Getting data and sending it in a CSV file to user



I'm creating an ASP.NET application that needs to get data from database (time consuming) and show some indication (e.g. gif animation) that the application is doing something. After that the data should be send to user that the user can save or open the CSV file.

I'm able to do this with two button click's. One for getting the data from the database in codebehind and using javascript to show the gif animation for user in the meanwhile. Second to use the response.write(myData) and response.end() to send the data for user to save in CSV file.

The problem is that I need to do this with one button click. If I combine the code to one button click handler the data is sent correctly but the gif animation is not hidden because the page is not updated. How to do this correctly with one button click?

Thanks, Nitos

Sharepoint 2010 custom file crawling from user submission C#


Ive currently got a user control on a search page that displays related documents for a particular record based on the GUID. What I have is an integration between ms CRM and sharepoint. i.e got an iframe in CRM pointing to sharepoint showing related documents for a particular record. All that is working well but now my issue is this:

When a user uploads a document from crm, it uploads succesfully but as its not crawled, it wont appear in their iframe view. Initially in my code ive started an incremental crawl when a document is succesfully submitted spcs.StartIncrementalCrawl() the problem with this is that this typically takes about 3-4mins. what I want to do (if possible) is crawl the exact document/url uploaded. I see theres the StartAddresses.Add method in the ContentSource class but I cant get this to work as the URI i provide (url of the document url) causes an error.

Anyone have an example of this which is NOT a WebContentSource or does anyone have any ideas how I could do this?




windows service creates a tmp file under service account user


We have a WCF windows service. We install this service with service account say e.g. WCF_ServiceAcc

When we start the service a tmp file gets created under the service account.

Sometimes this files grows bigger and the service stops working.

Do let us know why this is happening?


Have a user save a file from a server


I create an xml file from a csv file that a user uploads. What I want to do is display a link that says click here to download and have it pop up a box where they can save the specific file I just created. I can't seem to find any examples on this. Can someone help me out?

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