sherlock1
asked on
Batch file to shrink the log file of a SQL server express database
Hi Experts,
We are running a server with SQL server express which has the recovery model set to simple.
Is it possible to shrink the log file from a batch file?. Id like setup a schedule to shrink the log file within task scheduler since i believe our version of MS SQL server express doesnt have the management jobs to setup tasks that the full versions of SQL server have.
Thanks
We are running a server with SQL server express which has the recovery model set to simple.
Is it possible to shrink the log file from a batch file?. Id like setup a schedule to shrink the log file within task scheduler since i believe our version of MS SQL server express doesnt have the management jobs to setup tasks that the full versions of SQL server have.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes will try to find out the root cause of whats causing the log file to grow so much