Protecting Virtualized SSIS and SSRS servers
I have a stand alone instance of SSIS and SSRS running on 2 seperate VM's in production. And I want to know if the Servers can be protected with some kind of Snapshot method like Veeam to restore them back in case they blow up. Please let me know if something like this is possible at all.
backup ssrs virtualisation ssis-2014
asked Mar 3 '17 at 19:29
user2923332user2923332
361112
bumped to the homepage by Community♦ 9 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I have a stand alone instance of SSIS and SSRS running on 2 seperate VM's in production. And I want to know if the Servers can be protected with some kind of Snapshot method like Veeam to restore them back in case they blow up. Please let me know if something like this is possible at all.
backup ssrs virtualisation ssis-2014
asked Mar 3 '17 at 19:29
user2923332user2923332
361112
bumped to the homepage by Community♦ 9 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
What virtal server platform are you using? VMware? Hyper-V?
– Molenpad
Mar 3 '17 at 19:47
They are hosted on Vmware
– user2923332
Mar 3 '17 at 19:54
1
If you have access to the vcentre console you can easily create scheduled snapshots of the VM's. I have found them to be super reliable for all my SQL, SSIS and SSRS instances.
– Molenpad
Mar 3 '17 at 20:03
Okay. Can I restore the entire vm along with the servers with veeam along with the encryption keys for ssrs ?
– user2923332
Mar 3 '17 at 20:08
The snapshot holds everything on the VM within the snapshot. The VM will be restored exactly as it is taken. Remember to quiesce memory when taking snapshots with VMWare to ensure memory cache's are flushed to disk and to avoid any corruption.
– Molenpad
Mar 3 '17 at 20:35
add a comment |
I have a stand alone instance of SSIS and SSRS running on 2 seperate VM's in production. And I want to know if the Servers can be protected with some kind of Snapshot method like Veeam to restore them back in case they blow up. Please let me know if something like this is possible at all.
backup ssrs virtualisation ssis-2014
asked Mar 3 '17 at 19:29
user2923332user2923332
361112
I have a stand alone instance of SSIS and SSRS running on 2 seperate VM's in production. And I want to know if the Servers can be protected with some kind of Snapshot method like Veeam to restore them back in case they blow up. Please let me know if something like this is possible at all.
backup ssrs virtualisation ssis-2014
backup ssrs virtualisation ssis-2014
asked Mar 3 '17 at 19:29
user2923332user2923332
361112
asked Mar 3 '17 at 19:29
user2923332user2923332
361112
asked Mar 3 '17 at 19:29
user2923332user2923332
361112
asked Mar 3 '17 at 19:29
user2923332user2923332
361112
asked Mar 3 '17 at 19:29
user2923332user2923332
361112
361112
bumped to the homepage by Community♦ 9 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 9 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
What virtal server platform are you using? VMware? Hyper-V?
– Molenpad
Mar 3 '17 at 19:47
They are hosted on Vmware
– user2923332
Mar 3 '17 at 19:54
1
If you have access to the vcentre console you can easily create scheduled snapshots of the VM's. I have found them to be super reliable for all my SQL, SSIS and SSRS instances.
– Molenpad
Mar 3 '17 at 20:03
Okay. Can I restore the entire vm along with the servers with veeam along with the encryption keys for ssrs ?
– user2923332
Mar 3 '17 at 20:08
The snapshot holds everything on the VM within the snapshot. The VM will be restored exactly as it is taken. Remember to quiesce memory when taking snapshots with VMWare to ensure memory cache's are flushed to disk and to avoid any corruption.
– Molenpad
Mar 3 '17 at 20:35
add a comment |
What virtal server platform are you using? VMware? Hyper-V?
– Molenpad
Mar 3 '17 at 19:47
They are hosted on Vmware
– user2923332
Mar 3 '17 at 19:54
1
If you have access to the vcentre console you can easily create scheduled snapshots of the VM's. I have found them to be super reliable for all my SQL, SSIS and SSRS instances.
– Molenpad
Mar 3 '17 at 20:03
Okay. Can I restore the entire vm along with the servers with veeam along with the encryption keys for ssrs ?
– user2923332
Mar 3 '17 at 20:08
The snapshot holds everything on the VM within the snapshot. The VM will be restored exactly as it is taken. Remember to quiesce memory when taking snapshots with VMWare to ensure memory cache's are flushed to disk and to avoid any corruption.
– Molenpad
Mar 3 '17 at 20:35
What virtal server platform are you using? VMware? Hyper-V?
– Molenpad
Mar 3 '17 at 19:47
What virtal server platform are you using? VMware? Hyper-V?
– Molenpad
Mar 3 '17 at 19:47
They are hosted on Vmware
– user2923332
Mar 3 '17 at 19:54
They are hosted on Vmware
– user2923332
Mar 3 '17 at 19:54
1
1
If you have access to the vcentre console you can easily create scheduled snapshots of the VM's. I have found them to be super reliable for all my SQL, SSIS and SSRS instances.
– Molenpad
Mar 3 '17 at 20:03
If you have access to the vcentre console you can easily create scheduled snapshots of the VM's. I have found them to be super reliable for all my SQL, SSIS and SSRS instances.
– Molenpad
Mar 3 '17 at 20:03
Okay. Can I restore the entire vm along with the servers with veeam along with the encryption keys for ssrs ?
– user2923332
Mar 3 '17 at 20:08
Okay. Can I restore the entire vm along with the servers with veeam along with the encryption keys for ssrs ?
– user2923332
Mar 3 '17 at 20:08
The snapshot holds everything on the VM within the snapshot. The VM will be restored exactly as it is taken. Remember to quiesce memory when taking snapshots with VMWare to ensure memory cache's are flushed to disk and to avoid any corruption.
– Molenpad
Mar 3 '17 at 20:35
The snapshot holds everything on the VM within the snapshot. The VM will be restored exactly as it is taken. Remember to quiesce memory when taking snapshots with VMWare to ensure memory cache's are flushed to disk and to avoid any corruption.
– Molenpad
Mar 3 '17 at 20:35
add a comment |
1 Answer
1
active
oldest
votes
We are using Veeam to backup our sql db, ssis and ssrs servers. We are using native storage snapshot integration, which makes them happen faster. Still we have some issues when running a snapshot when an SSIS package is running. I would advise avoiding running snapshots during your SSIS package runs.
SSIS and SSRS encryption keys are stored on the machine and don't rely on any externals, so a restore of an entire machine will not require an additional key restore, although it is a good idea to back up your keys in case you have to rebuild and manually restore a machine for some reason.
We still run sql backups of all of our databases including ssis catalog to a network share. We are planning to use Veaam for those 'application level' backups in the future.
answered Jan 7 at 16:32
SamSam
24228
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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%2fdba.stackexchange.com%2fquestions%2f166129%2fprotecting-virtualized-ssis-and-ssrs-servers%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
We are using Veeam to backup our sql db, ssis and ssrs servers. We are using native storage snapshot integration, which makes them happen faster. Still we have some issues when running a snapshot when an SSIS package is running. I would advise avoiding running snapshots during your SSIS package runs.
SSIS and SSRS encryption keys are stored on the machine and don't rely on any externals, so a restore of an entire machine will not require an additional key restore, although it is a good idea to back up your keys in case you have to rebuild and manually restore a machine for some reason.
We still run sql backups of all of our databases including ssis catalog to a network share. We are planning to use Veaam for those 'application level' backups in the future.
answered Jan 7 at 16:32
SamSam
24228
add a comment |
We are using Veeam to backup our sql db, ssis and ssrs servers. We are using native storage snapshot integration, which makes them happen faster. Still we have some issues when running a snapshot when an SSIS package is running. I would advise avoiding running snapshots during your SSIS package runs.
SSIS and SSRS encryption keys are stored on the machine and don't rely on any externals, so a restore of an entire machine will not require an additional key restore, although it is a good idea to back up your keys in case you have to rebuild and manually restore a machine for some reason.
We still run sql backups of all of our databases including ssis catalog to a network share. We are planning to use Veaam for those 'application level' backups in the future.
answered Jan 7 at 16:32
SamSam
24228
add a comment |
We are using Veeam to backup our sql db, ssis and ssrs servers. We are using native storage snapshot integration, which makes them happen faster. Still we have some issues when running a snapshot when an SSIS package is running. I would advise avoiding running snapshots during your SSIS package runs.
SSIS and SSRS encryption keys are stored on the machine and don't rely on any externals, so a restore of an entire machine will not require an additional key restore, although it is a good idea to back up your keys in case you have to rebuild and manually restore a machine for some reason.
We still run sql backups of all of our databases including ssis catalog to a network share. We are planning to use Veaam for those 'application level' backups in the future.
answered Jan 7 at 16:32
SamSam
24228
We are using Veeam to backup our sql db, ssis and ssrs servers. We are using native storage snapshot integration, which makes them happen faster. Still we have some issues when running a snapshot when an SSIS package is running. I would advise avoiding running snapshots during your SSIS package runs.
SSIS and SSRS encryption keys are stored on the machine and don't rely on any externals, so a restore of an entire machine will not require an additional key restore, although it is a good idea to back up your keys in case you have to rebuild and manually restore a machine for some reason.
We still run sql backups of all of our databases including ssis catalog to a network share. We are planning to use Veaam for those 'application level' backups in the future.
answered Jan 7 at 16:32
SamSam
24228
answered Jan 7 at 16:32
SamSam
24228
answered Jan 7 at 16:32
SamSam
24228
answered Jan 7 at 16:32
SamSam
24228
24228
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- 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%2fdba.stackexchange.com%2fquestions%2f166129%2fprotecting-virtualized-ssis-and-ssrs-servers%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
What virtal server platform are you using? VMware? Hyper-V?
– Molenpad
Mar 3 '17 at 19:47
They are hosted on Vmware
– user2923332
Mar 3 '17 at 19:54
1
If you have access to the vcentre console you can easily create scheduled snapshots of the VM's. I have found them to be super reliable for all my SQL, SSIS and SSRS instances.
– Molenpad
Mar 3 '17 at 20:03
Okay. Can I restore the entire vm along with the servers with veeam along with the encryption keys for ssrs ?
– user2923332
Mar 3 '17 at 20:08
The snapshot holds everything on the VM within the snapshot. The VM will be restored exactly as it is taken. Remember to quiesce memory when taking snapshots with VMWare to ensure memory cache's are flushed to disk and to avoid any corruption.
– Molenpad
Mar 3 '17 at 20:35