Showing related tags and posts across the entire site.
-
DBCC SHRINKFILE (filename, size, option) option = EMPTYFILE | NOTRUNCATE | TRUNCATEONLY
-
Ok, thank you. I just understood that it would actually truncate the file size upon the transaction log backup. What's the syntax of the DBCC SHRINKFILE command?
-
Truncating the transaction log does not shrink its size. It only frees up space for re-use. You must use DBCC SHRINKFILE to reduce its size. (Not always a good idea.) You can use the command DBCC SQLPERF(LOGSPACE) to see how mcuh each of your transaction logs is using. This will list the size of the...
-
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...