Re: Transaction log file

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Susan (susan_at_nospam.com)
Date: 12/15/04


Date: Wed, 15 Dec 2004 07:16:02 -0800

no...changing the path will not do that...since you are just speculating, I
would say that getting yourself into this kind of a situation is a very bad
thing; so the best thing to do would be to ensure you never get into a spot
like this...
"Gomat.G.B" <GomatGB@discussions.microsoft.com> wrote in message
news:C03190C5-7E70-40CE-8B72-D5F0461F9A31@microsoft.com...
> But then how do i take an online backup or if i change the path of the
> Database will it start from the E0000001.log as the transaction log file
name
>
> "Susan" wrote:
>
> > I believe Exchange would use the res1.log and res2.log files and shut
down
> > Exchange...I would imagine you just wouldn't be able to keep the stores
> > mounted, and you would be forced into deleting transaction log
files...not a
> > good thing at all...
> >
> > "Gomat.G.B" <Gomat.G.B@discussions.microsoft.com> wrote in message
> > news:1132C43E-0A61-4CFA-9B12-C2582F17495C@microsoft.com...
> > > Its a speculation i want to know how does exchange server behave at
this
> > > point and how do it take an online backup after all this developments
> > >
> > > "Mark Arnold [MVP]" wrote:
> > >
> > > > On Tue, 14 Dec 2004 04:25:03 -0800, Gomat.G.B
> > > > <Gomat.G.B@discussions.microsoft.com> wrote:
> > > >
> > > > >Hi all,
> > > > > if exchange database is not backed for years so it wolud result in
a
> > pile
> > > > >up of transaction log files so there would be a situation where in
the
> > last
> > > > >log file would turn up to EFFFFFF.log further it cannot create a
log
> > file so
> > > > >how do we take a backup as the store comes down
> > > >
> > > > Good question although you'd be out of a job before you got anywhere
> > > > near using all the possible logs.
> > > > Are you asking for any specific purpose or are you speculating?
> > > >
> > > >
> >
> >
> >



Relevant Pages

  • Re: Transaction log file is damaged
    ... Tibor Karaszi, SQL Server MVP ... > lose the transaction log file, the database file was not cleanly closed. ...
    (microsoft.public.sqlserver.server)
  • Re: Question on shrinkingTransaction Log file
    ... After Transaction log backup the physical file will not shrink automatically ... Shrink the transaction log file. ...
    (microsoft.public.sqlserver.server)
  • Re: HELP!!
    ... The best option is shrinking the transaction log and data file individually ... DBCC SQLPERF ... How to shrink the transaction log file if your database is FULL recovery ... How to shrink the transaction log file if your database is Simple recovery ...
    (microsoft.public.sqlserver.security)
  • Re: Transaction log file is damaged
    ... The transaction logs were on a mirrored disk colume. ... lose the transaction log file, the database file was not cleanly closed. ...
    (microsoft.public.sqlserver.server)
  • Re: Question on shrinkingTransaction Log file
    ... up a transaction log that is 25GB and I've got only 1 GB ... >Auto shrink will take more I/O. ... Backup the transaction log (Use BACKUP Log dbname to ... Shrink the transaction log file. ...
    (microsoft.public.sqlserver.server)