recommend backup stratery please
the SAP operation is from Mon to Sat. if i carry out the following backup plan on MSSQL, is it fine?
Sat night: full backup
Mon - Fri night: incremental backup
every half hr: transaction log backup
read Note #44449
_________________
Mit Warmen Beachtungen,
VS
Hi,
Some shops are not 24x7, only 9-5. If the latter is your case you should consider offline backup nightly. This will make restore easier if you lose everything. (avoids rolling forward DB from the tr logs which is time-consuming)
Rgds,
Claudio