by George Chrysovaladis Grammatikos | Apr 5, 2019 | Azure, Storage
There are many ways we can backup up the SQL Databases in Azure services, even if these are running on SQL Azure or a SQL Server Virtual Machine. In this post, we will talk about Azure Backup for SQL Server Virtual Machines, a way that previously became General...
by George Chrysovaladis Grammatikos | Feb 19, 2019 | Azure, Azure SQL Database
In this post we will make a brief mention to the latest updates in the Azure SQL service and we see how someone can migrate a database to Azure SQL from an on-premise infrastructure.Before we begin the procedure we must know what Azure Database Services offer. ...
by George Chrysovaladis Grammatikos | Jan 8, 2019 | Azure, Azure SQL Database
In this post we will see how we can easily restore database in Azure SQL ManagedInstance. There are two ways to do this, using T-SQL and Powershell. Using Powershel Before executing the following Powershell Script to restore the database we must be sure for the...
by George Chrysovaladis Grammatikos | Apr 19, 2018 | SQL Server, Troubleshooting
If there is a break in the restore process then we can follow the steps below to try solve the problem. First, Open SSMS and execute the following command to look at database Status. SELECT NAME, STATE_DESC FROM SYS.DATABASES As soon as you confirm that database is in...
