SQL Server

How do I backup my SQL Server database to Azure blob storage? | how to resolve SQL server backup to URL?

by

This article describes, How do I backup my SQL Server database to Azure blob storage? or how to resolve SQL server backup to url? SQL Server support URL backup from SQL Server 2012. We can directly take SQL database backup on Azure Blob Storage. Azure Blob storage is storage space which can store your file. … Read more

microsoft sql server error 1412 always on | Always on Error – The remote copy of database “DB Name” has not been rolled forward to a point in time that is encompassed in the local copy of the database log.

by

This article guides to resolve, microsoft sql server error 1412 always on Why we receive SQL Server Error Message 1412 alwayson in sql server? Sometime database’s part HA stopped synchronizing. When we try to resume data movement we get SQL Server Error Msg 1412 or microsoft sql server error 1412 always on – The remote … Read more

How to fix Error 9002 alwayson in sql server? | Resolve Always On availability databases in Recovery Pending or Suspect state in SQL Server

by

This article helps to resolved How to fix Error 9002 alwayson in SQL server? or Resolve Always On availability databases in Recovery Pending or Suspect state in SQL Server Whenever you see Database recovery pending SQL server error in always on in SQL server, SQL database went in to suspect mode or in recovery mode. … Read more

Get azvm size using PowerShell | How to get VM size on AZURE?

by

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

How to create SQL job in SQL server? | Create SQL job in SQL server using PowerShell

by

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

Detach And Attach Database in SQL Server | Detach multiple databases using sp_detach_db | detach attach database sql server

by

This article describes, Detach And Attach Database in SQL Server or Detach multiple databases using sp_detach_db What happens when you detach a SQL database? If you want to move database from one SQL server instance to another SQL Server instance, we can use detach method. We can use SSMS to detach database from SQL Server. … Read more

How to list all file names from a folder and sub-folders? | SQL Server Query to List Files

by

This Article Describe, how to list all file names from a folder and sub-folders? or SQL Server Query to List Files Most of the time as DBA we get request to restore multiple databases. We can perform SQL Server database restore using SSMS or T-SQL Restore commands.Doing this database restore task in SSMS, we need to restore database … Read more

How do I create a disk space alert in SQL Server? | How to solve disk space issue in SQL Server?

by

This Article guides, How do I create a disk space alert in SQL Server? or How to solve disk space issue in SQL Server? Many time we face disk space issue on SQL Server on Azure managed instance. If we configured alert for low disk space this can help to avoid database getting down. SQL … Read more