mike 57299 (12/10/2012)
That is why I want to have a script to restore it each night.
your script will need to restore and recover the following each night
Log backups every 30 mins, thats 48 log backups per day!
After 5 days alone you have over 200 log backups to restore.
mike 57299 (12/10/2012)
Also - why would I need a new backup each week if I am always keeping the database updated?
New backup would be needed for the reason above. Otherwise after 2 weeks you'd have more log backups than you could shake a stick at and what if one became lost or corrupt.
Not sure what you mean by "always keeping the database updated", please explain
mike 57299 (12/8/2012)
Just won't work for us.
Sounds like replication could be your best route then, whether your dba will be keen to implement this though is what you'll need to find out.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉