how to make self backup to sql-server-2008 ?
-
hi how to make self backup to sql-server-2008 ? i need that backup every 2 hours and if the database is in work - it will be a problem ? thanks in advance
Gali1978 wrote:
and if the database is in work - it will be a problem
Why! Unless you have a high performance OLTP database backup should have minimal effect on the database. Do some reading on backup strategies, it is a large and complex subject with numerous options to achieve your requirements.
Never underestimate the power of human stupidity RAH
-
hi how to make self backup to sql-server-2008 ? i need that backup every 2 hours and if the database is in work - it will be a problem ? thanks in advance
Look into 1) Mirroring - One of several strategies that give you fail-over protection 2) Transaction log backup - This is the preferred method for frequent backup needs. You do one full backup then use the transaction log backup to update a database.