![]() We copy from Production to all three other databases roughly once every two months to limit drift and allow us to test upgrades. I also have three non-Production databases Training, Development and Test which reside together on a separate DB Server. I have a 1.2TB database occupying roughly 1.5TB of diskspace on Production across 8 Data and 8 Index files. So, I have got the scenario in which I need to find a way to automate SHRINKFILE, or at least, to automate the effect. Contact us for a free 30-minute sales consultation. SQL Critical Care® – Don’t have time to learn the hard way? We’re here to help with our quick, easy day process that gets to the root cause of your database health and performance pains. ![]() We start at backups and work our way up to performance tuning. Our Free 6-Month DBA Training Plan – Every Wednesday, you get an email with our favorite free SQL Server training resources. sp_Blitz® gives you a prioritized list of health and performance issues, plus gives you URLs for more details about each issue. Sp_Blitz®: Free SQL Server Health Check – You’ve inherited a SQL Server from somebody, and you have no idea why it’s slow. Learn More About Why Your SQL Server is Slow If you still think you want to shrink a database, check out how to shrink a database in 4 easy steps. This kind of advice shouldn’t clear any kind of SQL Server editorial team either.Ĭoming next month: “How to Reduce Your Backup Times with the Truncate Table Command!” I feel bad going nuclear on this article, but I’m not just venting about the author. Tripp – “8 Steps to Better Transaction Log Throughput”
0 Comments
Leave a Reply. |