I am looking for a comprehensive DR plan for a MAS 500 V7.4 hosted on Windows 2008 Server R2 in a SQL Server 2008 R2 (64-Bit).
I want to keep the transaction log and data files a reasonable size and be able to recover if needed. We are using the bulk-logged method (which I inherited) - is this the best way to go?
I want to be able to size or truncate the transaction logs without loosing the ability to recover my DB.
FYI - We have a relitvely small number of transactions and only use the GL.
Thanks In Advance,