Re: out of control T-Log? NEED HELP PLEASE...

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/22/04 

Date: Mon, 22 Mar 2004 23:01:35 +0100

Yes, that is a log backup. Check out the links I have on the web page. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"randyvol" <anonymous@discussions.microsoft.com> wrote in message
news:5769B966-0388-4C2E-A336-ADBF015123D2@microsoft.com...
>
>      Sorry -
> I neglected to state that I have also done T-log backups... at least I
think I have.  Maybe you can tell me...
> Here's the script for the particular DB in question...
>
> <snip>
> BACKUP LOG WHALEYAPPS TO
> DISK = 'D:\EMSQLT_BKPS\WHALEYAPPS_LOG.trn'
> WITH INIT, STATS = 25
> <end snip>
>
>
>      ----- Tibor Karaszi wrote: -----
>
>      Full backup doesn't empty the log backup. And shrink won't work
either as
>      the haven't emptied the log file. Either do regular transaction log
backups
>      or set the database to simple recovery model. As for shrinking of the
log
>      files, there are a few useful links in below article:
>
>      http://www.karaszi.com/sqlserver/info_dont_shrink.asp
>
>      -- 
>      Tibor Karaszi, SQL Server MVP
>      http://www.karaszi.com/sqlserver/default.asp
>
>
>      "randyvol" <randy.volters@whaleyfoodservice.com> wrote in message
>      news:08ED6880-34CD-4A06-A18B-26DE8DA5AA27@microsoft.com...
>      > Hello -
>      >> I have a problem with a T-Log file that just seems to keep growing
no
>      matter what I do...
>      >> Here are the file sizes:
>      > MDF 563,648 KB
>      > LDF 3,244,544 KB !!!
>      >> I have done full backups on this database
>      > I have done DBCC shrinkdatabase
>      > I have done DBCC shrinkfile (<LDF filename>, TRUNCATEONLY) (where
<LDF
>      filename> is the name of the logfile)
>      >> Nothing seems to affect the size of this file.
>      >> I even, in desperation, thought that perhaps there was an open
transaction
>      in the log file, so I ran DBCC OpenTran ('<DBNAME>')  (where DBNAME
is the
>      name of the database)  I got back no active open transactions.
>      >> There is just no way that I can see that this database (either MDF
or LDF
>      file should be that big.
>      >> Does anyone have any advise ???  Thanks in advance.
>      >> Randyvol
>
>
>

Relevant Pages

  • Re: commiting the transaction log?
    ... Tibor Karaszi, SQL Server MVP ... been that the file growth (such as that by alter database or autogrowth) is ... Is that the reason for the log file (in the file system) having time stamp that is pretty old ... But even if I run the FULL backup, and then the T-log backup, I can see that ...
    (microsoft.public.sqlserver.server)
  • Re: detaching db and stopping services
    ... > Tibor Karaszi, SQL Server MVP ... >>> backup the filecreated by that process and you should have your database ... >> blown the standby database once. ...
    (microsoft.public.sqlserver.server)
  • Re: Using maint plan to backup db to network drive
    ... Tibor Karaszi, SQL Server MVP ... In setting up our system imaging software I wanted to move our database ... I see that when I click browse to select the backup location it allows you ... UNC path it says its invalid but lets me enter it anyway, ...
    (microsoft.public.sqlserver.tools)
  • Re: Full Backup and Log backup timing
    ... The database I tested on is only 50 MB in size, I didn't see that wait in there... ... > backup while a Full backup is in progress but it can not finish until the ... >> Tibor Karaszi, SQL Server MVP ... >>> running when the Tlog backup job kicks in. ...
    (microsoft.public.sqlserver.server)
  • Re: sql server 7.0 backup script.
    ... Thanks hari and nice to see this...Hari, SQL Server MVP ... > in which backup needs to be taken. ... > all the databases with a unique name place it in the folder your are ... >> AUTO BACKUP THE ALL DATABASE BACKUP ...
    (microsoft.public.sqlserver.clients)
Loading