How to get BAK files from SQL 2008 R2 to Azure
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I know from SQL 2012 you can backup directly to Azure, but I have a SQL 2008 R2 instance where I'm needing to get the backups up to Azure for off-site backup reasons.
Anyone have some good options for what could be considered here?
sql-server azure database-backups
add a comment |
I know from SQL 2012 you can backup directly to Azure, but I have a SQL 2008 R2 instance where I'm needing to get the backups up to Azure for off-site backup reasons.
Anyone have some good options for what could be considered here?
sql-server azure database-backups
add a comment |
I know from SQL 2012 you can backup directly to Azure, but I have a SQL 2008 R2 instance where I'm needing to get the backups up to Azure for off-site backup reasons.
Anyone have some good options for what could be considered here?
sql-server azure database-backups
I know from SQL 2012 you can backup directly to Azure, but I have a SQL 2008 R2 instance where I'm needing to get the backups up to Azure for off-site backup reasons.
Anyone have some good options for what could be considered here?
sql-server azure database-backups
sql-server azure database-backups
asked Nov 16 '18 at 12:52
PhilipPhilip
769519
769519
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You can write a PowerShell script, which will backup your database using Backup-SqlDatabase cmdlet, and then copy the BAK file to Azure Blob Storage using Set-AzureStorageBlobContent cmdlet. Of course, you can also use your existing backup solution, but it may be more difficult to plug the call to Set-AzureStorageBlobContent in it. If you use SQL Server Agent, you can add a step with PowerShell or call to external executable to upload the recently made backup.
# Upload file from local disk to Azure Blob Storage
Set-AzureStorageBlobContent -Container "SQLServerBackups" -File "E:BackupsMyDatabase-2018-01-01.bak" -Blob "MyDatabase-2018-01-01"
Thanks Andrey, that sounds like a really good solution. :) Will test it out.
– Philip
Nov 17 '18 at 0:52
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53338323%2fhow-to-get-bak-files-from-sql-2008-r2-to-azure%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You can write a PowerShell script, which will backup your database using Backup-SqlDatabase cmdlet, and then copy the BAK file to Azure Blob Storage using Set-AzureStorageBlobContent cmdlet. Of course, you can also use your existing backup solution, but it may be more difficult to plug the call to Set-AzureStorageBlobContent in it. If you use SQL Server Agent, you can add a step with PowerShell or call to external executable to upload the recently made backup.
# Upload file from local disk to Azure Blob Storage
Set-AzureStorageBlobContent -Container "SQLServerBackups" -File "E:BackupsMyDatabase-2018-01-01.bak" -Blob "MyDatabase-2018-01-01"
Thanks Andrey, that sounds like a really good solution. :) Will test it out.
– Philip
Nov 17 '18 at 0:52
add a comment |
You can write a PowerShell script, which will backup your database using Backup-SqlDatabase cmdlet, and then copy the BAK file to Azure Blob Storage using Set-AzureStorageBlobContent cmdlet. Of course, you can also use your existing backup solution, but it may be more difficult to plug the call to Set-AzureStorageBlobContent in it. If you use SQL Server Agent, you can add a step with PowerShell or call to external executable to upload the recently made backup.
# Upload file from local disk to Azure Blob Storage
Set-AzureStorageBlobContent -Container "SQLServerBackups" -File "E:BackupsMyDatabase-2018-01-01.bak" -Blob "MyDatabase-2018-01-01"
Thanks Andrey, that sounds like a really good solution. :) Will test it out.
– Philip
Nov 17 '18 at 0:52
add a comment |
You can write a PowerShell script, which will backup your database using Backup-SqlDatabase cmdlet, and then copy the BAK file to Azure Blob Storage using Set-AzureStorageBlobContent cmdlet. Of course, you can also use your existing backup solution, but it may be more difficult to plug the call to Set-AzureStorageBlobContent in it. If you use SQL Server Agent, you can add a step with PowerShell or call to external executable to upload the recently made backup.
# Upload file from local disk to Azure Blob Storage
Set-AzureStorageBlobContent -Container "SQLServerBackups" -File "E:BackupsMyDatabase-2018-01-01.bak" -Blob "MyDatabase-2018-01-01"
You can write a PowerShell script, which will backup your database using Backup-SqlDatabase cmdlet, and then copy the BAK file to Azure Blob Storage using Set-AzureStorageBlobContent cmdlet. Of course, you can also use your existing backup solution, but it may be more difficult to plug the call to Set-AzureStorageBlobContent in it. If you use SQL Server Agent, you can add a step with PowerShell or call to external executable to upload the recently made backup.
# Upload file from local disk to Azure Blob Storage
Set-AzureStorageBlobContent -Container "SQLServerBackups" -File "E:BackupsMyDatabase-2018-01-01.bak" -Blob "MyDatabase-2018-01-01"
answered Nov 16 '18 at 13:14
Andrey NikolovAndrey Nikolov
4,3983922
4,3983922
Thanks Andrey, that sounds like a really good solution. :) Will test it out.
– Philip
Nov 17 '18 at 0:52
add a comment |
Thanks Andrey, that sounds like a really good solution. :) Will test it out.
– Philip
Nov 17 '18 at 0:52
Thanks Andrey, that sounds like a really good solution. :) Will test it out.
– Philip
Nov 17 '18 at 0:52
Thanks Andrey, that sounds like a really good solution. :) Will test it out.
– Philip
Nov 17 '18 at 0:52
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53338323%2fhow-to-get-bak-files-from-sql-2008-r2-to-azure%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown