Full Transaction Log disk
Hello all, I have two databases and problems with the transaction disk growing up too much and getting don't less. Using the query: select name, recovery_model_desc, log_reuse_wait_desc from sys.databases I can see both databases have the Recovery Model set to FULL. The files .ldf get values too high. How can I change the default configuration to NEVER have problems with the full disk? Because once the disk is full the web application can't do more transactions/requests queries. Thank you.
Join us for the free Azure SQL digital event
Digital event: Transform Your Applications with Azure SQL Discover how to adapt and scale in response to rapidly changing needs, boost the resilience of your mission-critical workloads, and make deployment more cost-effective. During this hour-long event, you’ll hear from Bob Ward, Principal Architect, Microsoft Azure Data, on how Azure SQL can help solve your modern data challenges, and will take you on a deeper dive into two of the newest and most exciting service tiers for Azure SQL Database: Serverless and Hyperscale. Through demos and interviews with current customers, you’ll learn how to use these capabilities to create groundbreaking deployments that are both cost effective and highly performant. Attend this digital event to: Find the right deployment option to create the lowest-friction path to the cloud. Select, set up, operate, and scale your database quickly by putting your existing SQL Server experience to work in the cloud. Hear directly from customers about how Azure SQL helped them optimize their applications for the cloud. See demonstrations of Azure SQL database features, including built-in high availability, self-tuning performance, and hands-free scale or pause with serverless compute. Get answers to your questions from Azure SQL subject-matter experts. Transform Your Applications with Azure SQL Wednesday, October 14, 2020 10:00 AM–11:00 AM Pacific Time Register now
