Showing related tags and posts across the entire site.
-
Hi I would like to put forward a situation here I am currently dealing with and ask some good advice before I go ahead. Our company has its own website on one database and we are planning to move NAVISION 5 near soon. The architecture I am thinking of holding the entire customer related data into NAVISION...
-
Look in SQL Server books online for the DBCC SHRINKDATABASE and DBCC SHRINKFILE statements, along with "Shrinking the transaction log". You can shrink the transaction log only depending on the state of the 'virtual logs' that are created within it, which is essentially something that...
-
Have a look at functions such as Dbshrink.
-
Thanks for your help. As part of my regular db plan for all of the db's on that server I dump the tlogs every hour and do a db dump daily. Any comments about transaction log size. Mine is getting quite large (650MB on a db of 1.2GB). We backup/restore companies into the db sometimes - is it this...