help with log file

Got a database in SQL2005 that  is basically  a download of a daily flat text 
files and creating tables from them.
The log.ldf file is frikkin huge.  It's over 146GB and I don't need this,  I 
have storage issues.  How do I shorten down this file and keep it small 
forever?
0
Utf
11/16/2009 4:39:01 PM
sqlserver.server 1327 articles. 0 followers. Follow

1 Replies
777 Views

Similar Articles

[PageSpeed] 54

Hi Rocketman

Have you read about managing the transaction log in the Books Online?
How big is your database?
What recovery model are you in?
What kinds of backups are you doing, and how frequently?

If you are not in SIMPLE recovery, and you don't back up your log, it will 
continue to grow. Even in SIMPLE, there are reasons the log can grow, so we 
really need more info.

-- 
HTH
Kalen
----------------------------------------
Kalen Delaney
SQL Server MVP
www.SQLServerInternals.com

"Rockitman" <Rockitman@discussions.microsoft.com> wrote in message 
news:16FBC191-63BC-44AA-B74E-A9E4511213B4@microsoft.com...
> Got a database in SQL2005 that  is basically  a download of a daily flat 
> text
> files and creating tables from them.
> The log.ldf file is frikkin huge.  It's over 146GB and I don't need this, 
> I
> have storage issues.  How do I shorten down this file and keep it small
> forever? 

0
Kalen
11/16/2009 5:39:37 PM
Reply:

Similar Artilces:

Importing into Excel from a Text file
We have a text database of about 7,000 rings. It is in a fixed format. Unfortunately some where we have about 4 or five rings whose format is screwed up. We figured by importing to Excel, we should be able to find where the records are to fix them. But, we just can't get the following format to import into excel. If anyone can help us, we sure would appreciate it! Thank you Greg Gates www.ringdesigner.com Each record begins with Begin Product Each record endswith EndProduct a semicolin seperates each record Also there are para symbols at the end of every line Herer are a...

hyperlink to existing excel file
When I create a hyperlink to an existing excel file and then click on it, explorer opens to the folder that the file is in instead of the excel file opening. Just to test I pointed it to a word document and the doc file opened fine. How do I get a hyperlink to open the excel file? Thanks. Are you sure it isn't to the folder instead. Only way I can reproduce that is if I select the folder instead of the file when I create the hyperlink. As expected if I use a hyperlink to a particular file it will open.. -- Regards, Peo Sjoblom "purplehaz" <software@for.me> wrote i...

Removing characters from cell
Hope someone can help me with this one.... I have text in column "A" a list of parts like the following..... ...nhg1234 ..nhg1235.54 nhg3456 ....nhg1253.7 Is thier anyway of removing the dots in front the part number? I dont want the points moving after the the main part of the number. Please help TiA mag()() Do you part numbers all start with nhg? If yes, you could select column A edit|Replace what: .n with: n replace all And keep hitting the replace all button until all are fixed. "Mag()()" wrote: > > Hope someone can help me with this one.... >...

Save for Web (.htm) file
I have two similarly structured XLS file. One file "A" is much longer...perhaps 2000 rows long...when saved as a htm file it is around 500KB. I take another XLS spreadsheet that looks like the same structure...rows and colums...only about 560 rows...when I save this as webpage .htm it ends up being 11.2MB. What the heck happened? How do I get it down in size. There is no apparent reason why a smaller file ends up being 11 time larger that the smaller file when saved! Thanks, --confused ...

point exchange to a different priv1.edb file
I have a snapshot of my priv1.edb file on a different drive. I know that exchange 2003 lets us me the priv1.edb file to a different location if the file isn't already there. Is there a way to have exchange point to a different priv1.edb and use it? On Thu, 5 Oct 2006 21:31:01 -0700, Han <Han@discussions.microsoft.com> wrote: > >I have a snapshot of my priv1.edb file on a different drive. I know that >exchange 2003 lets us me the priv1.edb file to a different location if the >file isn't already there. > >Is there a way to have exchange point to a differ...

External Link-help!
Hi there, I am trying to get rid of an external link to my excel spreadsheet that I created. When I email the excel file to a coworker, the file asks to update links. But, I want to get rid of all the links so that when others open it, the message will not come up. Under the Edit menu, the Links option is not highlighted. Somehow, the external link got embedded into the file, and I need a solution to delete it out. My job is depending on this resolution! Thanks, Tina I could really use some help! Try Bill Manville's addin. It'll find those pesky ones. Findlink.zip ...

!!HELP!! OWA ans Outlook do not synch
OK so I rebuilt my SBS 2003 server and used Exmerge to exmerge all my users mailboxes out. Successfully exmerged them back into Exchange. Had to recreate new profiles on the users workstations but all appears to be good. One slight problem. For my external users who use Citrix and log onto the Citrix server desktop they cannot use Outlook there. I do have a case open with Microsoft regarding this issue however my immediate issue to resolve is why I can log on as a user here in the office, open Outlook and all their mail is there. However when I use OWA the mailbox is incomplete. Does no...

forgot password?please help
I FORGOT MY PASSWORD ON MY MICROSOFT MONEY 2000 BUSINESS - PERSONAL I TRYED EVERY NAME AND NUMBER FOR 2 DAYS tsger@aol.com wrote: > I FORGOT MY PASSWORD ON MY MICROSOFT MONEY 2000 BUSINESS - > PERSONAL I TRYED EVERY NAME AND NUMBER FOR 2 DAYS That's got to be VERY FRUSTRATING! Not only that, but your CAPS LOCK KEY is stuck! I'm sorry for you! ...

Hyperlink Error
I have a hyperlink set-up for a netwrok file. It works fine, but when the file is copied the hyperlin chages to the folder that the file has been copied to. original link - L:\folder\folder\file Changes to - C:\file How can I get it to keep the original link? Justin ...

getting a single line from a file
I was wondering if someone could tell me how to read a single line from a text file. I tried using getline, but my MFC program does not recognize the getline function. Nor does it recognize <string> or <string.h> or using namespace std. So is there another function that I can use in MFC? Roger Take a look at the CStdioFile MFC class. -- Cheers Check Abdoul [VC++ MVP] ----------------------------------- "R.H." <roger.huggins@intermec.com> wrote in message news:e98o6IMmDHA.1764@tk2msftngp13.phx.gbl... > I was wondering if someone could tell me ho...

need a bit of help.....
I have generated a form that shows money amounts. yet i want two colums that separates the dollar amount from cents. I have for example colum *H* as the dollar amount and colum *I* as the cent amounts. Now i have tried Format Cell to set it up but it doesnt work. for example i tried the custom format for the dollar amount and it rounds it. and if there's an amount of 1108.83 the cell will show 1109. so it does not show the true value amount. i also tried the same approach with the =RIGHT(H1,2) but with the left and Mid but still didnt work, because i would have to enter the same amount o...

Help! page range prob in print
Hi I worked on print.Everythings working perfectly except one problem.ie. When i set the PageRange option to 'ALL' option and press print button..instead of displaying only the pages which has information ..its displaying that all pages from 1 to 65535 r going to be printed. How do i remove this problem? thanks, vani I thing you may failed to set the maximum number of pages to print. Check CPrintInfo::SetMaxPage(nMaxPage); method regds Jibesh -- ------------------------------------------------------------------------- FIGHT BACK AGAINST SPAM! Download Spam Inspecto...

MSP 2007 resources help
Hi all, Three questions: 1. What the constraint A<B,C means and how can I entering in the MSP? 2. I have 3 kinds of human resources. Lets say for example, kind A are engineers. I have 8 of them and everyone is costing 1500 Euros/month. Task A needs 4 engineers. How can I assign them to the task and add the appropriate cost? 3. I have 3 machines as a resource. Each machine has a usage cost of 3000 euros per task and function cost 2400 euros per month. How can I assign them in the appropriate tasks? And how can I distribute their cost? Thank you in advance -- - Hello...

Link Help!!!
hi, How can I add or remove link from “My Work” under workplace, like Calendar or Reports...? And where the file sitelog.xml?? thnx, ...

overwritten file
I have a client that overwrote an excel sheet. He did not have autorecovery on. Is there any way to recover this document? Sorry, no. -- John johnf202 at hotmail dot com "mark" <mark@mwts.cc> wrote in message news:4c7501c356ae$89ae8500$a001280a@phx.gbl... > I have a client that overwrote an excel sheet. He did not > have autorecovery on. Is there any way to recover this > document? Backup file is pretty much his only option if one exists. Has he perhaps sent the file anywhere else that he can get a copy back from, or if so he could possibly still have a ...

connection filtering RBL logging
I have followed the KB here: http://support.microsoft.com/kb/823866/en-us and I was wondering if there is a way that I can tell if it is working or not. I have the logging turned on but AFAIK this log logs everything (blocked and unblocked). Is there a way that I can look at some logs and it tell me when something is blocked and perhaps an error code? TIA. -Steven- On Mon, 26 Jun 2006 14:42:32 -0500, "Steven Platt" <me@nowhere.com> wrote: >I have followed the KB here: http://support.microsoft.com/kb/823866/en-us >and I was wondering if there is a way that I c...

File Size #4
Using Windows XP and Office 2007 Is there a reason that Publisher files keep growing in size? We have a weekly bulletin with some static information and some information that changes from week to week. On Monday, we open last week's publication, delete the no-longer-relavent text boxes and pictures, and add new text boxes and pictures for the current week. That has been our standard practice. I just noticed that the file size is increasing exponentially which leads me to believe that even though I delete things, there is still some sort of "ghost" material left in the...

Preventing Excel files from being moved or deleted
What permissions setting is used to prevent users from moving or deleting an Excel file on a network? This is more of an network operating system setting question. I would think putting the file on a share that the users only had readonly access would be enough. But this would mean that the users could still copy (not move) the file. And they wouldn't be able to update the workbook. bg500 wrote: > > What permissions setting is used to prevent users from moving or deleting an > Excel file on a network? -- Dave Peterson All explained in Start>Help and Support "p...

Windows Easy Transfer won't load files?
I ran Windows Easy Transfer on my laptop with Windows 7 RC1 to save and move my profile data because Win 7 RC is shutting down. I am trying to install the Windows Easy Tranfer data to Windows Vista Business. Each time I try it won't read the file but keep asking for the drive with the data to be loaded. I tried a test by moving the the data (.MIG) files out of the folder I saved them to and put them in the root of the drive but that didn't help. I tried a test of copying the files to the root of C: and now it actually sees the file for the short test at home I trying in t...

publisher 97 won't import a file graph of acceptable quality.
To MSFT: Let me try this again. I have Pub 97 that I must use for writing a manual. I try to import a black and white graphic-a chart, in jpeg or gif or whatever,but the graphic is of such poor quality that it can not be used. This only happens in my Publisher program. I have tried to change the adapter accerleration reading, but it does not help. Does anyone else have this problem with the older version of Pub 97? Do you have this problem with later versions of Publisher? Any ideas are appeciated. Check your graphics filters. Might have some corruption going on. They are in a folder sim...

List of File Extensions
Is there a list somewhere that contains the file extensions used in Office 2003 applications? I need to backup files before re-installing my OS. These include files that store settings, customizations, macros, Outlook address books, etc. ...

Making Design Gallery Objects available to other files in publishe
Hello, I created some custom objects and saved them to the Design Gallery, and they did appear under My Objects. However, I saved the file and opened up a new one and to my shock My Objects was empty. I opened the earlier file where I created and saved the objects and they were still there. Does this mean that the Design Gallery if file-specific and not saved in a Publisher Application file for use in other .pub files? Perhaps that is the default setting that can be changed later. Please help me on this matter. Thank you in advance for your support. Alcide <Alcide@discussions.micr...

trendline HELP!
I have a chart that i am making of PPMs for the year of 2006. I have jan-may in the data series and the rest are left blank. I am trying to get a trendline in where it will stop at whatever month I am at but update when a new month's data is entered into the box. However, I cannot figure out how to do this, when I do have a trend line it goes to like -4000. can anyone help me please? Make a dynamic chart: http://peltiertech.com/Excel/Charts/Dynamics.html http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html http://www.stfx.ca/people/bliengme/ExcelTips/Dynamic.htm...

Help what kind of formula?
I've used Excel formulas in a basic way (sums, averages, divisions, and multiplication of cell data) for about a year. I came across this formula today for a project I need to complete. I've never seen the "SUMIF" or the dollar symbol, OR the ampersand! After hilighting the formula to see if I could just figure it out, I'm stumped. Any chance someone could explain what function these symbols serve Here is the formula =SUMIF($D$3:$D$28,"="&$C38,H$3:H$28) :confused: -- Emil0 ------------------------------------------------------------------------ Emil...

Was this post helpful to you?
Hi gang, Just curious about the Yes, No selection on the question, "Was this post helpful to you? " In a case where I posted a question and received numerous helpful responses, which collectively provided the final solution, do I select Yes for each response that was helpful, or just select Yes on the very last post when the topic has ended? Thanks Peter On Sun, 12 Aug 2007 13:44:01 -0700, Petermgr <Petermgr@discussions.microsoft.com> wrote: >Hi gang, > >Just curious about the Yes, No selection on the question, "Was this post >helpful to you? "...