Data & Storage
379 TopicsTroubleshooting - Trusted root certificates (error code 151066)
You may receive an error message “Site Recovery configuration failed.” while configuring Azure to Azure VM replication. Most of these issues occurred due to the required trusted root certificates used for authorization and authentication aren't present on the machine. This troubleshooting article details some of the possible causes and recommended actions to resolve this issue.3.7KViews0likes1CommentLinking containers in azure storage blockblob
Hi! I need to link two containers to each other, much like a soft link in a file system. I need it to avoid using storage for the same exact file twice, which I want under two containers. i.e The file https://account.blob.core.windows.net/1/image.jpg under container 1 needs to be accessible via https://account.blob.core.windows.net/2/image.jpg as well (under container 2). Notice that the whole point is to have one blob named image.jpg under two containers, not two identical files! Does anybody have any idea about how to make this happen? I did not find any documentation enabling such a feature. Thanks!3.3KViews0likes2CommentsTroubleshooting - Unable to delete Recovery Services Vault?/Can't delete Azure Backup Vault?
You may receive " Vault deletion error Vault: 'Vault name' cannot be deleted as there are existing resources within the vault. Please delete any replicated items, registered servers, Hyper-V sites (Used for Site Recovery), policy associations for System Center VMM clouds (Used for Site Recovery) and then delete the vault." when trying to remove the azure recovery services vault. Most of the Vault deletion errors that we encounter at support are due to the dependency resources exist in the vault. Please follow the steps metnioned in below articles to resolve this issue. For the site recovery resources Delete Recovery Services vault For the backup resources Delete an Azure Backup vault If you testing the product, want to rapidly delete the vault and not concerned about data loss, then you can use force delete method to remove vault and all its dependencies.Solved33KViews0likes11CommentsReplicated Tables now generally available in Azure SQL Data Warehouse
We are excited to announce that Replicated Tables, a new type of table distribution, are now generally available in Azure SQL Data Warehouse (SQL DW). SQL DW is a fully managed, flexible, and secure cloud data warehouse tuned for running complex queries fast and across petabytes of data. The key to performance for large-scale data warehouses is how data is distributed across the system. When queries join across tables and data is distributed differently, data movement is required to complete the query. The same can be said when transforming data to load, enrich, and apply business rules. With Replicated Tables, the data is available on all compute nodes, hence data movement is eliminated, and queries run faster. In some cases, such as small dimension tables, choosing a Replicated Table versus a Round Robin table, can increase performance because data movement is reduced. As with all optimization techniques, performance gains may vary and should be tested. Read about it in the Azure blog.1.2KViews0likes2CommentsAzure Site Recovery breaking SQL Server log chain
I'm protecting a SQL Server with ASR and doing backups with Commvault. Commvault is telling me that transaction log backups are being converted to fulls because it detected a break in the log chain probably caused by another backup product. I dug into it and found that ASR's VSS writer is taking a snapshot once an hour and SQL Server is seeing this as a full backup. Has anyone had experience with this? I feel like the ASR VSS snapshot shouldn't be counted as a full backup of the database2.4KViews0likes1CommentAzure Recovery purging recovery points?
If you have setup a backup job using Azure, and you have decided at a later date that you do not need quite as many recovery points as you once thought. Is it possible to take for instance Azure backups that are currently holding 198 recovery points and trim it down to say 30? Without losing all your backup jobs? Or do you have to delete all your old backups and start completely over?4.3KViews0likes2CommentsASR Replication Issue - Error ID 70171
Hi. I'm new to using this forum so hopefully someone can help me I have 2 x on-premise Hyper-V Windows 2012 R2 which replicate 10 servers into an Azure Recovery Vault which is used for ASR. I have a configured ASR policy which has been working for most of the year with no issues. On Thursday last week I received notification to upgrade my Hyper-V Hosts from Azure ACS to AAD for ASR. I did this and it all went well and they're on Agent Ver 5.1.2700.0 (latest) and I updated the MARS Agents to the latest too as I had a notice about these needing updating to the latest version. When I now list my 10 servers in Azure they are all RED and Replication Health is Critical and RPO column is blank. If I open ALL the servers they correctly state the App-and Crash resistance times : so why are they RED and stated as Replication Health Critical ?? The on-premise hyper-v replications says all is working and I used this article to check the finer points that replication is indeed being sent: https://docs.microsoft.com/en-us/azure/site-recovery/site-recovery-azure-to-azure-troubleshoot-errors#outbound-connectivity-for-site-recovery-urls-or-ip-ranges-error-code-151037-or-151072). Any ideas ?6.9KViews0likes2CommentsProblems mapping Azure file shares on-premises
Hi. I'm new to Azure. I'm an MSP and a Microsoft Partner. I just created my Storage Account and first file share. I'm trying to map the file share from an on-premises Windows 10 workstation and Windows Server 2012. Neither work. I keep getting the error "network path not found"...error code 0x80070035. I tried to map the drive using PowerShell and Windows map drive from the GUI using the instructions for the Azure Portal (connect). I have verified that port 445 is open. Is this supported from on-premises locations?33KViews0likes6CommentsReference to database and/or server name in 'Azure.dbo.XXX' is not supported in this version of SQL
I am getting an error that seemingly indicates that I'm trying to use linked server or cross-database query when I am in no way trying to. I've opened a stackexchange question w/ full details but no one has seen this scenario. Reference to database and/or server name in 'Azure.dbo.XXX' is not supported in this version of SQL Server (where XXX is my table name) See full details on StackExchange but basically I can SELECT, INSERT, and UPDATE to this particular table but cannot DELETE from it. When I try to run a DELETE statement, I receive the error above. Have tried disabling TRIGGERs, have tried various combinations of schema/database/tablename in the FROM clause. Pulling my hair out here.Solved105KViews0likes8CommentsAzure Storage Explorer High CPU Usage
For some reason when I install Azure Storage Explorer v1.0.0 (from here: https://azure.microsoft.com/en-us/features/storage-explorer/) and run it, it seems to nearly lock up my computer, launching a bunch of child processes and maxing out my CPU. Any ideas?1.9KViews0likes1Comment