February 17, 2009 at 1:57 am
We have a sql 2000 database that generate 2GB+ file transaction dumps every hour. What could the source of such a large file be? (Again, I'm talking about the size of file representing the dump of the transaction log not the size of the transaction log itself.)
TIA,
Barkingdog
February 17, 2009 at 3:27 am
U know about the how much transaction file generated.but u don't know about the source database size. r u joking,if don't know the find out datbase size by...
Sp_helpdb 'database_Name'
or
u know about which database using how much log space, then
Run this query...
DBCC SQLPERF(Logspace)
February 17, 2009 at 4:18 am
when you say
(Again, I'm talking about the size of file representing the dump of the transaction log not the size of the transaction log itself.)
Do you mean the transaction log back-up?
February 17, 2009 at 9:41 am
>>> Do you mean the transaction log back-up?
Yes, somehow I couldn't think of the words yesterday!
Barkingdog
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply