xp_sqlmaint
in [Server Configuration]
|
From: RG on 26 Jan 2010 21:11 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 26 Jan 2010 21:57 Are you expecting the physical file size to decrease? 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: RG on 26 Jan 2010 22:55 "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 26 Jan 2010 23:24 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. "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 04:41
> 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 >>> >>> >> > > |