xp_sqlmaint
in [Server Configuration]
|
From: RG on 27 Jan 2010 07:58 I suppose in simple recovery mode, when commit is issued the space automatically becomes available. Is that right? "Jay" <spam(a)nospam.org> wrote in message news:urJApTznKHA.5524(a)TK2MSFTNGP05.phx.gbl... >> The backed up log will contain the entire transaction, without the >> commit. When the commit is issued, that will go into the backup as well. > > at which point the log space will become reusable. > >> >> >> "RG" <nobody(a)nowhere.com> wrote in message >> news:AC45B9C4-4E8F-4BA7-ACA7-F3D3F92467CC(a)microsoft.com... >>> >>> "Jay" <spam(a)nospam.org> wrote in message >>> news:O1dY4xvnKHA.1556(a)TK2MSFTNGP05.phx.gbl... >>>> Are you expecting the physical file size to decrease? >>> No. >>> >>> I think I found the answer. It seems that log space is not freed for as >>> long the transaction hasn't completed. What I don't understand is how, >>> then, log backup could be performed on an inconsistant data. >>> >>>> >>>> If so, that must be done manually. >>>> >>>> >>>> "RG" <nobody(a)nowhere.com> wrote in message >>>> news:76640A32-9497-4925-9C43-260617BEB535(a)microsoft.com... >>>>>I have a fixed size log file. I have setup a job using xp_sqlmaint to >>>>>backup log every five minutes. In monitoring used log space, I find >>>>>that the used space is the same as before running log backup. Shouldn't >>>>>the used log space be freed after log backups? >>>>> >>>>> Thanks in advance >>>> >>>> >>> >> >> > >
From: Jay on 27 Jan 2010 10:10 >I suppose in simple recovery mode, when commit is issued the space >automatically becomes available. Is that right? Yes, or in other words, it is truncated. Try searching in BOL for "Transaction Log Truncation", or http://msdn.microsoft.com/en-us/library/ms189085.aspx (same page, but for 2008). > "Jay" <spam(a)nospam.org> wrote in message > news:urJApTznKHA.5524(a)TK2MSFTNGP05.phx.gbl... >>> The backed up log will contain the entire transaction, without the >>> commit. When the commit is issued, that will go into the backup as well. >> >> at which point the log space will become reusable. >> >>> >>> >>> "RG" <nobody(a)nowhere.com> wrote in message >>> news:AC45B9C4-4E8F-4BA7-ACA7-F3D3F92467CC(a)microsoft.com... >>>> >>>> "Jay" <spam(a)nospam.org> wrote in message >>>> news:O1dY4xvnKHA.1556(a)TK2MSFTNGP05.phx.gbl... >>>>> Are you expecting the physical file size to decrease? >>>> No. >>>> >>>> I think I found the answer. It seems that log space is not freed for >>>> as long the transaction hasn't completed. What I don't understand is >>>> how, then, log backup could be performed on an inconsistant data. >>>> >>>>> >>>>> If so, that must be done manually. >>>>> >>>>> >>>>> "RG" <nobody(a)nowhere.com> wrote in message >>>>> news:76640A32-9497-4925-9C43-260617BEB535(a)microsoft.com... >>>>>>I have a fixed size log file. I have setup a job using xp_sqlmaint to >>>>>>backup log every five minutes. In monitoring used log space, I find >>>>>>that the used space is the same as before running log backup. >>>>>>Shouldn't the used log space be freed after log backups? >>>>>> >>>>>> Thanks in advance >>>>> >>>>> >>>> >>> >>> >> >> >
First
|
Prev
|
Pages: 1 2 Prev: New store procedure template Next: Upgrade MS SQL 2000 Cluster to SP4 |