I have 2 ideas for my backup solution and was looking to get feedback from the community about this. I'm running SQL Server 2008 Enterpise.
1) Once a week full back up daily incremental back ups locally. Then setting up a scheduler to copy the files to my backup server.
2) Use log shipping. To be honest, I haven't done this before but it looks relatively straight forward to implement. I am not sure of the overheads involved though. This could also be a problem if the network goes down.
I'm actually for the log shipping solution even if I have no prior experience with it. Whadya guys think? Replication is out cos I don't want any schema changes. Just looking for a fuss free easy set up.