SSMS 21/22 Error Upload BACPAC file to Azure Storage
Hello All In my SSMS 20, I can use "Export Data-tier Application" to export an BACPAC file of Azure SQL database and upload to Azure storage in the same machine, the SSMS 21 gives error message when doing the same export, it created the BACPAC files but failed on the last step, "Uploading BACPAC file to Microsoft Azure Storage", The error message is "Could not load file or assembly 'System.IO.Hashing, Version=6.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies. The system cannot find the file specified. (Azure.Storage.Blobs)" I tried the fresh installation of SSMS 21 in a brand-new machine (Windows 11), same issue, Can anyone advice? ThanksFull 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
