Showing related tags and posts across the entire site.
-
Now I just need to find out which additional jobs to run on a weekly basis to make the database even faster...
-
Thank you all. The backups now run perfectly the last two weeks. Not as MP's but as Jobs. But they run!
-
[quote user="DenSter"] Useful command to truncate transaction log: BACKUP LOG <MyDatabase> WITH TRUNCATE_ONLY This will get rid of all committed transactions in the log file, and leave you with a mostly empty file. At this point, the file is still the same size. Truncating the file only...
-
Thanks. Then I "only" need to solve my problem with the error when creating maintenance plans...