AndyLee100
Technical User
Hi
I work for a company that distribute a SQL Server based visual basic application. Full backups are run every night from this program using a TSQL command line. The problem is that one customers transaction log file is not automatically shrinking and has now grown to a size of 6GB. The database is set to Auto Shrink but does not seem to be. How can we stop the trans. log getting so big without having to manually shrink the database.
Any help would be greatly appreciated
Thanks
Andy Lee
I work for a company that distribute a SQL Server based visual basic application. Full backups are run every night from this program using a TSQL command line. The problem is that one customers transaction log file is not automatically shrinking and has now grown to a size of 6GB. The database is set to Auto Shrink but does not seem to be. How can we stop the trans. log getting so big without having to manually shrink the database.
Any help would be greatly appreciated
Thanks
Andy Lee