Why doing Backup-SPFarm for our sharepoint 2013 will update the sql databases “Last Database backup”
Clash Royale CLAN TAG#URR8PPP
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
17911
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
17911
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
17911
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
17911
asked Jan 11 at 3:20
SharePoint TestDevSharePoint TestDev
17911
asked Jan 11 at 3:20
SharePoint TestDevSharePoint TestDev
17911
asked Jan 11 at 3:20
SharePoint TestDevSharePoint TestDev
17911
asked Jan 11 at 3:20
SharePoint TestDevSharePoint TestDev
17911
17911
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 Jan 11 at 10:37
MHeld
4,03811634
answered Jan 11 at 3:23
Trevor SewardTrevor Seward
19.9k31744
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
Jan 11 at 16:17
1
That's correct, however I usually encourage taking SQL backups and useBackup-SPFarm -ConfigurationOnlyinstead.
– Trevor Seward
Jan 11 at 16:28
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
Jan 11 at 16:40
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
Jan 11 at 16:42
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 Jan 11 at 10:37
MHeld
4,03811634
answered Jan 11 at 3:23
Trevor SewardTrevor Seward
19.9k31744
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
Jan 11 at 16:17
1
That's correct, however I usually encourage taking SQL backups and useBackup-SPFarm -ConfigurationOnlyinstead.
– Trevor Seward
Jan 11 at 16:28
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
Jan 11 at 16:40
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
Jan 11 at 16:42
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 Jan 11 at 10:37
MHeld
4,03811634
answered Jan 11 at 3:23
Trevor SewardTrevor Seward
19.9k31744
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
Jan 11 at 16:17
1
That's correct, however I usually encourage taking SQL backups and useBackup-SPFarm -ConfigurationOnlyinstead.
– Trevor Seward
Jan 11 at 16:28
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
Jan 11 at 16:40
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
Jan 11 at 16:42
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 Jan 11 at 10:37
MHeld
4,03811634
answered Jan 11 at 3:23
Trevor SewardTrevor Seward
19.9k31744
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 Jan 11 at 10:37
MHeld
4,03811634
answered Jan 11 at 3:23
Trevor SewardTrevor Seward
19.9k31744
edited Jan 11 at 10:37
MHeld
4,03811634
edited Jan 11 at 10:37
MHeld
4,03811634
edited Jan 11 at 10:37
MHeld
4,03811634
4,03811634
answered Jan 11 at 3:23
Trevor SewardTrevor Seward
19.9k31744
answered Jan 11 at 3:23
Trevor SewardTrevor Seward
19.9k31744
answered Jan 11 at 3:23
Trevor SewardTrevor Seward
19.9k31744
19.9k31744
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
Jan 11 at 16:17
1
That's correct, however I usually encourage taking SQL backups and useBackup-SPFarm -ConfigurationOnlyinstead.
– Trevor Seward
Jan 11 at 16:28
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
Jan 11 at 16:40
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
Jan 11 at 16:42
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
Jan 11 at 16:17
1
That's correct, however I usually encourage taking SQL backups and useBackup-SPFarm -ConfigurationOnlyinstead.
– Trevor Seward
Jan 11 at 16:28
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
Jan 11 at 16:40
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
Jan 11 at 16:42
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
Jan 11 at 16:17
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
Jan 11 at 16:17
1
1
That's correct, however I usually encourage taking SQL backups and use
Backup-SPFarm -ConfigurationOnly instead.– Trevor Seward
Jan 11 at 16:28
That's correct, however I usually encourage taking SQL backups and use
Backup-SPFarm -ConfigurationOnly instead.– Trevor Seward
Jan 11 at 16:28
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
Jan 11 at 16:40
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
Jan 11 at 16:40
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
Jan 11 at 16:42
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
Jan 11 at 16:42
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