How do I create a new database using Backup?

Question

How do I create a new database using Backup?

Doctor Who 2

SSCrazy Eights

Points: 8195
More actions
July 16, 2016 at 8:45 am

#327773

I'm trying, once again, to get my database into Azure. I've gone through the process of creating a new logical server. Now I'm trying to create a SQL Server database in that server. I'm on the page to create that in Azure and naturally I want to use the backup I made of my SQL Server database on my machine. The Select source option lists 3 things: Blank database, Sample and Backup. Of course I figure I've got to use Backup. But if I do, it requires me to specify a backup in Azure. Huh? I haven't even gotten the database into Azure! How in heck can I create a new database from a backup in Azure that doesn't exist yet?
And more to the point, how do I get my .bak on my machine, up into Azure SQL?
Rod

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

HappyGeek SSCoach Points: 18729 More actions · Answer 1

Have not actually done this but I believe you need to backup the database to Azure, which is a URL backup and which requires a storage account. HTH.

Before anyone shouts foul, can I add this was presented on the MVA Course https://mva.microsoft.com/en-US/training-courses/designing-solutions-for-sql-server-8484?l=ZemEq0Xz_6604984382.

...

Doctor Who 2 SSCrazy Eights Points: 8195 More actions · Answer 2

Do you mean I've got to get into SSMS and perform the backup to Azure? I've already done a backup of the database and have the .bak file, can I upload that to Azure?

Rod

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 3

You can't restore to an Azure database. You can create a BACPAC and deploy that to Azure to create a new database, but a backup/restore won't work.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Rod at work SSC-Dedicated Points: 34008 More actions · Answer 4

Grant Fritchey (7/18/2016)
You can't restore to an Azure database. You can create a BACPAC and deploy that to Azure to create a new database, but a backup/restore won't work.

Grant, thank you for your response. How does one create a BACPAC?

Kindest Regards, Rod Connect with me on LinkedIn.

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 5

Try this: https://blogs.msdn.microsoft.com/brunoterkaly/2013/09/26/how-to-export-an-on-premises-sql-server-database-to-windows-azure-storage/

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 6

Rod at work (7/18/2016)
Grant Fritchey (7/18/2016)
You can't restore to an Azure database. You can create a BACPAC and deploy that to Azure to create a new database, but a backup/restore won't work.
Grant, thank you for your response. How does one create a BACPAC?

What Steve has posted is pretty much it. There is a way to do the same thing from Powershell too, so you can script the process.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Doctor Who 2 SSCrazy Eights Points: 8195 More actions · Answer 7

Doctor Who 2

SSCrazy Eights

Points: 8195

July 18, 2016 at 9:50 pm

#1890756

Thank you Grant and Steve.

Rod

Doctor Who 2 SSCrazy Eights Points: 8195 More actions · Answer 8

Hi Steve,

Tonight I have a chance to go through the MSDN article you've posted in response to my question. It looks as though I need to first start a Windows Azure Storage Account? Just double-checking.

Rod

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 9

Doctor Who 2 (7/19/2016)
Hi Steve,
Tonight I have a chance to go through the MSDN article you've posted in response to my question. It looks as though I need to first start a Windows Azure Storage Account? Just double-checking.

You could try (I haven't tested it) doing the import through SSMS connected up to Azure. Not sure if it works. Setting up Azure Storage works for sure.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

BLOB EATER SSChampion Points: 14609 More actions · Answer 10

Grant Fritchey (7/19/2016)
Doctor Who 2 (7/19/2016)
Hi Steve,
Tonight I have a chance to go through the MSDN article you've posted in response to my question. It looks as though I need to first start a Windows Azure Storage Account? Just double-checking.
You could try (I haven't tested it) doing the import through SSMS connected up to Azure. Not sure if it works. Setting up Azure Storage works for sure.

Have a look at this article I wrote.

http://www.sqlservercentral.com/articles/SQL+Server/139998/

usually it will ask you for storage URL and Account key details