Showing related tags and posts across the entire site.
-
[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...
-
Well it's actually not about a NAV database, but regarding the database I'm using to run this website. I have two problems: One is that I'm not able to delete (or shrink) the transaction log. Even though I'm clicking yes to "Truncate the transaction log" during backup of the...
-
My plan is: Job 1: DBCC REINDEX [Table] x (n = processing tables) - daily Job 2: DBCC REINDEX [Table] x (n = entry tables) - weekly Job 3: DBCC REINDEX [Table] x (n = other tables) - monthly Job 4: DelZeroSift - daily (ref: http://www.mibuso.com/dlinfo.asp?FileID=812 ) Job 5: Update Stats - daily (as...