Size of a replicated DB

Question

Size of a replicated DB

Cláudia Sousa Rego

SSCommitted

Points: 1780
More actions
September 19, 2006 at 9:17 am

#94550

Hello!
I don't understand something..
I have two DB's that receive the same data.
In the first one, i have data since Aug.05 until today.
It's size is (aprox.)400 MB.
In the second, i have data since Aug.06 until today.
The second DB is being replicated. It's size is (aprox.)1400 MB. The DB at the subscriber has the same size.
WHY this difference if the first DB has much more data??
Thanks
Cláudia
Regards,
Cláudia Rego
www.footballbesttips.com

Viewing 7 posts - 1 through 6 (of 6 total)

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

Sreejith Sreedharan SSCertifiable Points: 5403 More actions · Answer 1

Are u doing Transaction log backup. If not Xaction log backup can keep growing?

Are they any long running xaction cos if u have long running xation then Xaction log keeps growing till u backup and shrink database.

Thanks

Sreejith

Cláudia Sousa Rego SSCommitted Points: 1780 More actions · Answer 2

I don't understood what is Xaction...

but, in fact, the data file has a reasonable size (294 MB). but the size of the transaction log is very big (1192 MB). I made the following:

use aveiro_aguas_2_REP

go

DBCC SHRINKFILE (aveiro_aguas_Log, 0)

GO

But the size is still the same!!

What can i do?

How i delete the data in the transaction log?

Thanks

Claudia

Regards,

Cláudia Rego

www.footballbesttips.com

Cláudia Sousa Rego SSCommitted Points: 1780 More actions · Answer 3

SOLVED!!

I use:

BACKUP LOG aveiro_aguas_2_REP

WITH NO_LOG

And then shrink!!

Thanks

Claudia

Regards,

Cláudia Rego

www.footballbesttips.com

Ronzo Hall of Fame Points: 3917 More actions · Answer 4

To prevent the log file from getting huge again, either set the database recovery model to Simple or schedule regular Transaction Log Backups.

Have Fun!
Ronzo

TL SSC-Addicted Points: 470 More actions · Answer 5

A database must be in full recovery mode to use replication (the change is made automaticly when replication is set up). In order to keep your transaction logs from getting huge, back them up on a regular basis (hourly is good).

Cláudia Sousa Rego SSCommitted Points: 1780 More actions · Answer 6

that's what i have done. schedule a transaction log backup

Regards,

Cláudia Rego

www.footballbesttips.com