How to backup and restore databases through stored procedure in Azure SQL using Elastic Pool?
I have a C# ASP.NET MVC based web application in which there is a functionality of Archiving (backup) and Restoring Databases on the click of button. Currently, our system is On-Prem and so we are using the stored procedures in SQL Server to do the backup and restore.
Now we are migrating to Azure PaaS and are using Elastic Pool. As the backup and restore T-SQL commands do not work in Azure SQL, so can someone please help me in finding a way to do the backup and restore of DBs manually through T-SQL?
Any help would be highly appreciated!
Auto backups is a feature of Azure SQL database.
In SQL Azure, database backups are executed automatically and it is not possible to change this behavior. This is a service offered when you create a SQL Azure database and the first full backup occurs immediately after you create a new SQL Azure database and the rest of the backups are scheduled by SQL Azure itself.
There is no way can help you backup and restore of DBs manually through T-SQL.
Hope this helps.
- Delete duplicate records in SQL Server?
- In a junction table, should I use a Primary key and a unique constraint, or a compound/composite key?
- Convert to ASCII char in SQL Server
- SQL transaction locks query weird behavior
- Update SQL with consecutive numbering
- Export stored procedure results as CSV (UTF 8 BOM format) to external server from SQL Server 2012
- What does the new stored procedure default content mean?
- Why does a WHERE IN query on a uniqueidentifer column result in a "range seek" (greater than/less than)?
- Get size of all tables in database
- How to grant database user read/write access roles the "new way"?
- Dynamic sql script to generate list of drop table statement
- How do I remove non-breaking spaces from a column in SQL server?
- Select query to remove non-numeric characters
- Calculate Date Difference for Non-Consecutive Months
- Show only one database on SQL Server
- When using multiple WHEN MATCHED statements, do they all execute, or does only one get executed?
- Join SQL tables back together to create a report
- Create a Range From n to 1 in SQL
- How to DROP multiple columns with a single ALTER TABLE statement in SQL Server?
- Split a string based on multiple variable substring
- sp_execute_remote only outputs one result set?
- CASE or AND/OR in WHERE condition. What is the best practice?
- TSQL rollup -return not null
- Multiple Security Predicates (FILTER|BLOCK) on same Table
- Parsing JSON nodes in the same string
- How can I use LEFT & RIGHT Functions in SQL to get last 3 characters?
- SQL Get "ISO Year" for ISO Week
- Case expression for Order By clause with Desc/Asc sort
- How to create and use database directly after creation in SQL Server?
- Database Naming Conventions by Microsoft?