recommendations for staging server db to live db 1

[kim20]

Hi

I have a CMS Database held on a staging server set as Full recovery, with
weekly full backup
trans logs run every 30 mins during daytime
diff run twice daily during daytime.
i also use a maintenance plan to check integrity and optimize to remove unused space from database file. default settings.
this works great.

i have the same CMS Database on a live web server which is synchronzied daily from the staging server.
in theory i guess i do not need to take backups of this as we have them for the staging server database.
In this case can i set the database as simple recovery, despite the fact the staging is full ?
in this case i would simply run a weekly full backup (just to be on the safe side)
if i need to set the live db as full then i don't really want regular transaction log backups, just a weekly backup? but is the db trans log going to grow out of control because i am not running log backups ?

some advice really ?
can you have different recovery types for synched databases.
and recommended backup strategy for my live db.

thank you
kim

 

[ptheriault]

As long as your staging server is really the source of all the content you could do that. But does anyone change content on the prod server.

>>In this case can i set the database as simple recovery, despite the fact the staging is full ? -YES

>>if i need to set the live db as full then i don't really want regular transaction log backups, just a weekly backup? but is the db trans log going to grow out of control because i am not running log backups ?
--If a database is set to FULL recovery then you have to backup the TLog for the reason you state.

>>can you have different recovery types for synched databases. --Yes you can.

If your stg server is the source of your content then that should be FULL Recovery. I would also backup the prod database daily. You can never be to safe.

- Paul
- If at first you don't succeed, find out if the loser gets anything.