i've started working @ company guy left told me use transaction backup (i'm quite new sql server, never heard of before) , full backup 6 servers have.
the servers use replication, 1 publisher , others suscribers.
in every server jobs run @ night create .bak file (11gb) , around 25 .trn each night.
are these .trn necessary? guy told me if trn backups not done server starts failing because "it fills" don't know means think it.
do need backup on every server? or should backup in publisher?
also, during backup process replication starts failing , have manually hit "restart" option every morning.
Comments
Post a Comment