This article guides to resolved, How to resolve Cannot export bacpac in SQL Server Error SQL71564? | The element has been orphaned from its login and cannot be deployed What is bacpac? Bacpac is backup file imported from AZURE SQL database or SQL Server. Bacpac is used to to migrate databases from SQL Server to … Read more
This article helps to resolve, The transaction log for database ‘msdb’ is full due to ‘ACTIVE_TRANSACTION.’ or Sql server – log is full due to ACTIVE_TRANSACTION As a DBA we face issue like the transaction log for database ‘msdb’ is full due to ‘ACTIVE_TRANSACTION. Because of that disk is getting full and we are not … Read more
This article will guide you How to capture deadlock using extended events? What is deadlock? Deadlock is a situation in SQL Server where two or more transactions are waiting for each other to release a resource, such as a table or a row, that is locked by the other transaction. This results in a circular … Read more
This Article guide about How to configure VM backup in azure recovery vault? Azure Recovery Services vault is place where you can keep your backup. This act as storage space on Azure.It is used to keep data backup, as well as backup like SQL Server in case of Disaster Recovery scenarios. Azure Recovery Services vault … Read more
This article guides, How to create bacpac file from SQL server? How to create a BACPAC file from SQL Server database? or export bacpac file sql server AZURE SQL Database is pass offering from Microsoft. We can use AZURE SQL Database as service if you want to minimize the server management. AZURE SQL Database support … Read more
This Article guide to resolve, SQL Database backup failure due to AZURE VM Backup or Cannot perform a differential backup because current backup does not exist This article has step by step process of Troubleshoot Azure backup conflict with SQL database backup chain What is AZURE VM Backup? Azure Backup provides independent and isolated backups … Read more
This article guide to, Get azvm size using PowerShell or How to get VM size on AZURE? Many time we get requirement to Get all vms in subscription for audit purpose or to remove unwanted VM for cost saving purpose. We will have many virtual machines in different Azure subscription for all environment like PROD, … Read more
This Article describe, How do I copy files using AzCopy? or how to copy files from one container to another in Azure storage using AzCopy? AzCopy is a command-line utility designed for copying data to/from Microsoft Azure Blob, File, and Table storage, using simple commands designed for optimal performance. It can be used to transfer … Read more
This article provide guide for How to create SQL job in SQL server? Below script Create SQL job in SQL server using PowerShell. You can create same job on multiple SQL Server. This will automate process and reduce manual efforts to create same SQL Server jobs on Multiple SQL Server Instance. Step 1: Create List … Read more