|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
TRXN LOG BKP time takes so much longer than Full BKP???
One of several databases I support is about 70 MG. I have a nightly full
backup and hourly transaction log backup running on all of databases and there is no conflict in time on jobs.. There is something about this database that I do not understand. It takes less than a sec for a full backup but for the transaction log backup is about 10 sec. I do not know why any ideas? ktf wrote:
> One of several databases I support is about 70 MG. I have a nightly 70MB or 70GB? What recovery model are you using on the database?> full backup and hourly transaction log backup running on all of > databases and there is no conflict in time on jobs.. There is > something about this database that I do not understand. It takes less > than a sec for a full backup but for the transaction log backup is > about 10 sec. I do not know why any ideas? 70 MB and it is Full mode.
ktf Show quoteHide quote "David Gugick" wrote: > ktf wrote: > > One of several databases I support is about 70 MG. I have a nightly > > full backup and hourly transaction log backup running on all of > > databases and there is no conflict in time on jobs.. There is > > something about this database that I do not understand. It takes less > > than a sec for a full backup but for the transaction log backup is > > about 10 sec. I do not know why any ideas? > > 70MB or 70GB? What recovery model are you using on the database? > > -- > David Gugick > Imceda Software > www.imceda.com > Is the log backup running at the same time as the Full backup? If so then
change it as the Log backup can not happen until after the full is complete. -- Show quoteHide quoteAndrew J. Kelly SQL MVP "ktf" <k**@discussions.microsoft.com> wrote in message news:BB2C6F0B-5743-4B11-8F45-2E998A67154A@microsoft.com... > 70 MB and it is Full mode. > ktf > > "David Gugick" wrote: > >> ktf wrote: >> > One of several databases I support is about 70 MG. I have a nightly >> > full backup and hourly transaction log backup running on all of >> > databases and there is no conflict in time on jobs.. There is >> > something about this database that I do not understand. It takes less >> > than a sec for a full backup but for the transaction log backup is >> > about 10 sec. I do not know why any ideas? >> >> 70MB or 70GB? What recovery model are you using on the database? >> >> -- >> David Gugick >> Imceda Software >> www.imceda.com >> No Mr. Kelly there is no conflicts. Even if I change the frequency of this
job the time remains the same. Thank you, ktf Show quoteHide quote "Andrew J. Kelly" wrote: > Is the log backup running at the same time as the Full backup? If so then > change it as the Log backup can not happen until after the full is complete. > > -- > Andrew J. Kelly SQL MVP > > > "ktf" <k**@discussions.microsoft.com> wrote in message > news:BB2C6F0B-5743-4B11-8F45-2E998A67154A@microsoft.com... > > 70 MB and it is Full mode. > > ktf > > > > "David Gugick" wrote: > > > >> ktf wrote: > >> > One of several databases I support is about 70 MG. I have a nightly > >> > full backup and hourly transaction log backup running on all of > >> > databases and there is no conflict in time on jobs.. There is > >> > something about this database that I do not understand. It takes less > >> > than a sec for a full backup but for the transaction log backup is > >> > about 10 sec. I do not know why any ideas? > >> > >> 70MB or 70GB? What recovery model are you using on the database? > >> > >> -- > >> David Gugick > >> Imceda Software > >> www.imceda.com > >> > > > Are the tran logs on a different drive aray than the data files? If so you
might want to check and see if the array is not corrupt. Other than that I don't know of a good reason why this would be happening. -- Show quoteHide quoteAndrew J. Kelly SQL MVP "ktf" <k**@discussions.microsoft.com> wrote in message news:521D8D99-B3DB-4838-807E-60E7E967EA2F@microsoft.com... > No Mr. Kelly there is no conflicts. Even if I change the frequency of this > job the time remains the same. > Thank you, > ktf > > "Andrew J. Kelly" wrote: > >> Is the log backup running at the same time as the Full backup? If so >> then >> change it as the Log backup can not happen until after the full is >> complete. >> >> -- >> Andrew J. Kelly SQL MVP >> >> >> "ktf" <k**@discussions.microsoft.com> wrote in message >> news:BB2C6F0B-5743-4B11-8F45-2E998A67154A@microsoft.com... >> > 70 MB and it is Full mode. >> > ktf >> > >> > "David Gugick" wrote: >> > >> >> ktf wrote: >> >> > One of several databases I support is about 70 MG. I have a nightly >> >> > full backup and hourly transaction log backup running on all of >> >> > databases and there is no conflict in time on jobs.. There is >> >> > something about this database that I do not understand. It takes >> >> > less >> >> > than a sec for a full backup but for the transaction log backup is >> >> > about 10 sec. I do not know why any ideas? >> >> >> >> 70MB or 70GB? What recovery model are you using on the database? >> >> >> >> -- >> >> David Gugick >> >> Imceda Software >> >> www.imceda.com >> >> >> >> >> Hi ktf,
In the database you have data, but in TL you have every transaction you do on the database including regenerating indexes and similar task, you often check consistency of the data after backup. Online TL backup must also deal with physical writes to disk. So I am not surprised with time consuming backup off TL. Regards, Daniel Show quoteHide quote "ktf" <k**@discussions.microsoft.com> wrote in message news:4A389E71-BF05-4B5B-8D7C-78759C7CC601@microsoft.com... > One of several databases I support is about 70 MG. I have a nightly full > backup and hourly transaction log backup running on all of databases and > there is no conflict in time on jobs.. There is something about this database > that I do not understand. It takes less than a sec for a full backup but for > the transaction log backup is about 10 sec. I do not know why any ideas?  
Other interesting topics
Primary File Group Full?
How to 'call' UDFs from SPs How to backup and restore related databases? Exporting data using T-SQL... something opposite of BULK INSERT. SAN issues, please help Is it possible to restore SQL Server from Registry and System file could not find stored procdure xp_availablemedia Data Migration Recommendations Needed Help needed with OpenQuery copy data from one database to another |
|||||||||||||||||||||||
