Why doing Backup-SPFarm for our sharepoint 2013 will update the sql databases “Last Database backup”
2
we have SharePoint enterprise 2013, and i run the following command to do a farm backup:-
Backup-SPFarm -Directory \****backups -BackupMethod full -BackupThreads 10 -Force
now on the generated backup folder i got many .bak files ranging from 2kb size to 10 GB... also i have noted that for our sharepoint sql databases the "Last Database backup" date will be updates as follow:-
so can i conclude that the Backup-SPFarm will mainly do a pure sql databases backups ? also what are the .bak files which have small sizes such as 3 kb ?
2013 administration backup sharepoint-farm
asked Jan 11 at 3:20
SharePoint TestDevSharePoint TestDev
8110
add a comment |
2
we have SharePoint enterprise 2013, and i run the following command to do a farm backup:-
Backup-SPFarm -Directory \****backups -BackupMethod full -BackupThreads 10 -Force
now on the generated backup folder i got many .bak files ranging from 2kb size to 10 GB... also i have noted that for our sharepoint sql databases the "Last Database backup" date will be updates as follow:-
so can i conclude that the Backup-SPFarm will mainly do a pure sql databases backups ? also what are the .bak files which have small sizes such as 3 kb ?
2013 administration backup sharepoint-farm
asked Jan 11 at 3:20
SharePoint TestDevSharePoint TestDev
8110
add a comment |
2
2
2
we have SharePoint enterprise 2013, and i run the following command to do a farm backup:-
Backup-SPFarm -Directory \****backups -BackupMethod full -BackupThreads 10 -Force
now on the generated backup folder i got many .bak files ranging from 2kb size to 10 GB... also i have noted that for our sharepoint sql databases the "Last Database backup" date will be updates as follow:-
so can i conclude that the Backup-SPFarm will mainly do a pure sql databases backups ? also what are the .bak files which have small sizes such as 3 kb ?
2013 administration backup sharepoint-farm
asked Jan 11 at 3:20
SharePoint TestDevSharePoint TestDev
8110
we have SharePoint enterprise 2013, and i run the following command to do a farm backup:-
Backup-SPFarm -Directory \****backups -BackupMethod full -BackupThreads 10 -Force
now on the generated backup folder i got many .bak files ranging from 2kb size to 10 GB... also i have noted that for our sharepoint sql databases the "Last Database backup" date will be updates as follow:-
so can i conclude that the Backup-SPFarm will mainly do a pure sql databases backups ? also what are the .bak files which have small sizes such as 3 kb ?
2013 administration backup sharepoint-farm
2013 administration backup sharepoint-farm
asked Jan 11 at 3:20
SharePoint TestDevSharePoint TestDev
8110
asked Jan 11 at 3:20
SharePoint TestDevSharePoint TestDev
8110
asked Jan 11 at 3:20
SharePoint TestDevSharePoint TestDev
8110
asked Jan 11 at 3:20
SharePoint TestDevSharePoint TestDev
8110
asked Jan 11 at 3:20
SharePoint TestDevSharePoint TestDev
8110
8110
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
5
Backup-SPFarm does a few things:
- Backups all applicable databases. This also updates the
Last Database Backupentry - Exports information from the configuration database (which cannot be restored)
- Backups the search index
This is why you see smaller files along side your database backups.
edited 2 days ago
MHeld
4,02811533
answered Jan 11 at 3:23
Trevor SewardTrevor Seward
19.7k31644
ok thanks for your reply. so if we are doingBackup-SPFarmthen we do not have to take sql backup from the sql database itself? as we will have redundant data? is this correct?
– SharePoint TestDev
2 days ago
1
That's correct, however I usually encourage taking SQL backups and useBackup-SPFarm -ConfigurationOnlyinstead.
– Trevor Seward
2 days ago
can i know why you prefer to do it in this way? based on my reading running this commandBackup-SPFarm -Directory \****backups -BackupMethod full -BackupThreads 10 -Forcewill allow us to get a full backup for every setting,configuration and data we have...
– SharePoint TestDev
2 days ago
In a good number of farms you would use SQL transaction log backups/incremental backups. UsingBackup-SPFarmbreaks the log chain which causes problems restoring to a particular point in time.
– Trevor Seward
2 days ago
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "232"
};
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
});
}
});
draft saved
draft discarded
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%2fsharepoint.stackexchange.com%2fquestions%2f255607%2fwhy-doing-backup-spfarm-for-our-sharepoint-2013-will-update-the-sql-databases-l%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
5
Backup-SPFarm does a few things:
- Backups all applicable databases. This also updates the
Last Database Backupentry - Exports information from the configuration database (which cannot be restored)
- Backups the search index
This is why you see smaller files along side your database backups.
edited 2 days ago
MHeld
4,02811533
answered Jan 11 at 3:23
Trevor SewardTrevor Seward
19.7k31644
ok thanks for your reply. so if we are doingBackup-SPFarmthen we do not have to take sql backup from the sql database itself? as we will have redundant data? is this correct?
– SharePoint TestDev
2 days ago
1
That's correct, however I usually encourage taking SQL backups and useBackup-SPFarm -ConfigurationOnlyinstead.
– Trevor Seward
2 days ago
can i know why you prefer to do it in this way? based on my reading running this commandBackup-SPFarm -Directory \****backups -BackupMethod full -BackupThreads 10 -Forcewill allow us to get a full backup for every setting,configuration and data we have...
– SharePoint TestDev
2 days ago
In a good number of farms you would use SQL transaction log backups/incremental backups. UsingBackup-SPFarmbreaks the log chain which causes problems restoring to a particular point in time.
– Trevor Seward
2 days ago
add a comment |
5
Backup-SPFarm does a few things:
- Backups all applicable databases. This also updates the
Last Database Backupentry - Exports information from the configuration database (which cannot be restored)
- Backups the search index
This is why you see smaller files along side your database backups.
edited 2 days ago
MHeld
4,02811533
answered Jan 11 at 3:23
Trevor SewardTrevor Seward
19.7k31644
ok thanks for your reply. so if we are doingBackup-SPFarmthen we do not have to take sql backup from the sql database itself? as we will have redundant data? is this correct?
– SharePoint TestDev
2 days ago
1
That's correct, however I usually encourage taking SQL backups and useBackup-SPFarm -ConfigurationOnlyinstead.
– Trevor Seward
2 days ago
can i know why you prefer to do it in this way? based on my reading running this commandBackup-SPFarm -Directory \****backups -BackupMethod full -BackupThreads 10 -Forcewill allow us to get a full backup for every setting,configuration and data we have...
– SharePoint TestDev
2 days ago
In a good number of farms you would use SQL transaction log backups/incremental backups. UsingBackup-SPFarmbreaks the log chain which causes problems restoring to a particular point in time.
– Trevor Seward
2 days ago
add a comment |
5
5
5
Backup-SPFarm does a few things:
- Backups all applicable databases. This also updates the
Last Database Backupentry - Exports information from the configuration database (which cannot be restored)
- Backups the search index
This is why you see smaller files along side your database backups.
edited 2 days ago
MHeld
4,02811533
answered Jan 11 at 3:23
Trevor SewardTrevor Seward
19.7k31644
Backup-SPFarm does a few things:
- Backups all applicable databases. This also updates the
Last Database Backupentry - Exports information from the configuration database (which cannot be restored)
- Backups the search index
This is why you see smaller files along side your database backups.
edited 2 days ago
MHeld
4,02811533
answered Jan 11 at 3:23
Trevor SewardTrevor Seward
19.7k31644
edited 2 days ago
MHeld
4,02811533
edited 2 days ago
MHeld
4,02811533
edited 2 days ago
MHeld
4,02811533
4,02811533
answered Jan 11 at 3:23
Trevor SewardTrevor Seward
19.7k31644
answered Jan 11 at 3:23
Trevor SewardTrevor Seward
19.7k31644
answered Jan 11 at 3:23
Trevor SewardTrevor Seward
19.7k31644
19.7k31644
ok thanks for your reply. so if we are doingBackup-SPFarmthen we do not have to take sql backup from the sql database itself? as we will have redundant data? is this correct?
– SharePoint TestDev
2 days ago
1
That's correct, however I usually encourage taking SQL backups and useBackup-SPFarm -ConfigurationOnlyinstead.
– Trevor Seward
2 days ago
can i know why you prefer to do it in this way? based on my reading running this commandBackup-SPFarm -Directory \****backups -BackupMethod full -BackupThreads 10 -Forcewill allow us to get a full backup for every setting,configuration and data we have...
– SharePoint TestDev
2 days ago
In a good number of farms you would use SQL transaction log backups/incremental backups. UsingBackup-SPFarmbreaks the log chain which causes problems restoring to a particular point in time.
– Trevor Seward
2 days ago
add a comment |
ok thanks for your reply. so if we are doingBackup-SPFarmthen we do not have to take sql backup from the sql database itself? as we will have redundant data? is this correct?
– SharePoint TestDev
2 days ago
1
That's correct, however I usually encourage taking SQL backups and useBackup-SPFarm -ConfigurationOnlyinstead.
– Trevor Seward
2 days ago
can i know why you prefer to do it in this way? based on my reading running this commandBackup-SPFarm -Directory \****backups -BackupMethod full -BackupThreads 10 -Forcewill allow us to get a full backup for every setting,configuration and data we have...
– SharePoint TestDev
2 days ago
In a good number of farms you would use SQL transaction log backups/incremental backups. UsingBackup-SPFarmbreaks the log chain which causes problems restoring to a particular point in time.
– Trevor Seward
2 days ago
ok thanks for your reply. so if we are doing
Backup-SPFarm then we do not have to take sql backup from the sql database itself? as we will have redundant data? is this correct?– SharePoint TestDev
2 days ago
ok thanks for your reply. so if we are doing
Backup-SPFarm then we do not have to take sql backup from the sql database itself? as we will have redundant data? is this correct?– SharePoint TestDev
2 days ago
1
1
That's correct, however I usually encourage taking SQL backups and use
Backup-SPFarm -ConfigurationOnly instead.– Trevor Seward
2 days ago
That's correct, however I usually encourage taking SQL backups and use
Backup-SPFarm -ConfigurationOnly instead.– Trevor Seward
2 days ago
can i know why you prefer to do it in this way? based on my reading running this command
Backup-SPFarm -Directory \****backups -BackupMethod full -BackupThreads 10 -Force will allow us to get a full backup for every setting,configuration and data we have...– SharePoint TestDev
2 days ago
can i know why you prefer to do it in this way? based on my reading running this command
Backup-SPFarm -Directory \****backups -BackupMethod full -BackupThreads 10 -Force will allow us to get a full backup for every setting,configuration and data we have...– SharePoint TestDev
2 days ago
In a good number of farms you would use SQL transaction log backups/incremental backups. Using
Backup-SPFarm breaks the log chain which causes problems restoring to a particular point in time.– Trevor Seward
2 days ago
In a good number of farms you would use SQL transaction log backups/incremental backups. Using
Backup-SPFarm breaks the log chain which causes problems restoring to a particular point in time.– Trevor Seward
2 days ago
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to SharePoint 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.
draft saved
draft discarded
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%2fsharepoint.stackexchange.com%2fquestions%2f255607%2fwhy-doing-backup-spfarm-for-our-sharepoint-2013-will-update-the-sql-databases-l%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
