Size of a replicated DB

Question

Size of a replicated DB

Viewing 6 posts - 1 through 7 (of 7 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: 479 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