Showing related tags and posts across the entire site.
-
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...
-
You may want to do transaction log backups during the day, depending on the workload and concurrent users. Heavy systems should try for hourly transaction log backups. Its not really necessary to back up the master database, since Attain doesn't use it for anything other than the storage of the licsense...