asked on
shrink database
Dear all,
Is there anyway that we can set the SQL server in a way that when the Database size is growth and the disk is full, the SQL server will automatically shink the DB growthing ?
DBA100
Is there anyway that we can set the SQL server in a way that when the Database size is growth and the disk is full, the SQL server will automatically shink the DB growthing ?
DBA100
Microsoft SQL Server 2005
Last Comment
marrowyung
no.
you have to monitor the db growth, and act accordingly to the reason of the db growing.
if it's just the transaction log file, the issue could be that transaction log backups are not in place, or a replication not working.
if it's the data files, you might need to either ensure more disk space in time, or delete/move data, or ....
you have to monitor the db growth, and act accordingly to the reason of the db growing.
if it's just the transaction log file, the issue could be that transaction log backups are not in place, or a replication not working.
if it's the data files, you might need to either ensure more disk space in time, or delete/move data, or ....
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
angelIII,
You say "you have to monitor the db growth", so this means I still have to watch it manually, right?
DBA100.
You say "you have to monitor the db growth", so this means I still have to watch it manually, right?
DBA100.
You don't have to watch it manually if you properly implement the stored proc I posted.
ASKER
I will try it.
ASKER
I find the script has some problem, let me look for help
https://www.experts-exchange.com/questions/20465860/automatically-shrink-the-log-file.html?anchorAnswerId=7777626#a7777626
~Raj