transactional Replication- Two log files

Question

Post reply

transactional Replication- Two log files

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

muthyala_51 (12/14/2012)
When compared to yesterday's both the files are of same size(149 GB).

So, despite you asking several times why the files are growing simultaneously, they're actually not growing?

I added space used column also now. Why almost the same numbers are appearing in both the log files.

Perhaps if you explained how you got those numbers it would help....

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

deep_kkumar Hall of Fame Points: 3243 More actions · Answer 2

Probably used this query--

select

a.FILEID,

[FILE_SIZE_MB] =

convert(decimal(12,2),round(a.size/128.000,2)),

[SPACE_USED_MB] =

convert(decimal(12,2),round(fileproperty(a.name,'SpaceUsed')/128.000,2)),

[FREE_SPACE_MB] =

convert(decimal(12,2),round((a.size-fileproperty(a.name,'SpaceUsed'))/128.000,2)) ,

NAME = left(a.NAME,15),

FILENAME = left(a.FILENAME,30)

from

dbo.sysfiles a

Dhruva_51 SSChampion Points: 10521 More actions · Answer 3

When I said files are growing what I mean to say is it's using the free space. I used the query