Microsoft SQL Server 2005
--
Questions
--
Followers
Top Experts
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
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
https://www.experts-exchange.com/questions/20465860/automatically-shrink-the-log-file.html?anchorAnswerId=7777626#a7777626
~Raj
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
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 say "you have to monitor the db growth", so this means I still have to watch it manually, right?
DBA100.
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
Get a FREE t-shirt when you ask your first question.
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
Microsoft SQL Server 2005
--
Questions
--
Followers
Top Experts
Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.