Why doing Backup-SPFarm for our sharepoint 2013 will update the sql databases “Last Database backup”

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:-

enter image description here

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 ?

asked Jan 11 at 3:20

SharePoint TestDev

17911

add a comment |

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

enter image description here

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 ?

asked Jan 11 at 3:20

SharePoint TestDev

17911

add a comment |

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

enter image description here

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 ?

asked Jan 11 at 3:20

SharePoint 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

enter image description here

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 TestDev

17911

asked Jan 11 at 3:20

SharePoint TestDev

17911

asked Jan 11 at 3:20

SharePoint TestDev

17911

asked Jan 11 at 3:20

SharePoint TestDev

17911

asked Jan 11 at 3:20

SharePoint TestDev

17911

add a comment |

1 Answer
1

active

oldest

votes

Backup-SPFarm does a few things:

Backups all applicable databases. This also updates the Last Database Backup entry

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 Seward

19.9k31744

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

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

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 |

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

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

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

Backup-SPFarm does a few things:

Backups all applicable databases. This also updates the Last Database Backup entry

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 Seward

19.9k31744

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

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

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 |

Backup-SPFarm does a few things:

Backups all applicable databases. This also updates the Last Database Backup entry

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 Seward

19.9k31744

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

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

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 |

Backup-SPFarm does a few things:

Backups all applicable databases. This also updates the Last Database Backup entry

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 Seward

19.9k31744

Backup-SPFarm does a few things:

Backups all applicable databases. This also updates the Last Database Backup entry

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 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

answered Jan 11 at 3:23

Trevor Seward

19.9k31744

answered Jan 11 at 3:23

Trevor Seward

19.9k31744

answered Jan 11 at 3:23

Trevor Seward

19.9k31744

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

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

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 |

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

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

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

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

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

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

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

搜尋此網誌

mjhjmtu