Hello,
I need some advice on how to set up my backups för SQL 2008. At this point we take a full backup every sunday and a level1 (differential) every wednesday. My problem is that i would like to keep logfiles as small as possible or at least logfiles should not be 99% used.
Now, when truncate only option is history in SQL 2008, how can i keep logfiles small?
Networker client version 5.2.1.299
Database is in FULL mode, Auto shrink.
Thanks
I need some advice on how to set up my backups för SQL 2008. At this point we take a full backup every sunday and a level1 (differential) every wednesday. My problem is that i would like to keep logfiles as small as possible or at least logfiles should not be 99% used.
Now, when truncate only option is history in SQL 2008, how can i keep logfiles small?
Networker client version 5.2.1.299
Database is in FULL mode, Auto shrink.
Thanks