Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

SQL Backup versus SharePoint backup

Asked By: Loren Morse Date: Feb 10, 2010 Category: Sharepoint Views: 488

We are still in a beta mode with MOSS and working out procedures before
we go live. Here, SQL is managed entired by another department and the
SQL dba is telling me that she runs a backup every night on all of the
databases. When I run back up from Central Admin the only messages I
get are warnings on each web app says this:

"The previous full SQL backup for the database xxxxxxxxx was performed
by another backup tool and may not be restored correctly."

Is the SQL db backup all that is really required or is the SharePoint
backup doing other things that we will need to have to successfully
restore the farm or components of the farm? Should I be doing the
SharePoint backup in addition to the SQL backup and just ignore those
warnings?

Tagged:sql backup versus sharepoint

4 Answers Found

Answer #1 Answered By: Rosanna Parrish Answered On: Feb 10, 2010

The sharepoint backup also backs up things like the indexes and lets you restore
lower down the tree

Its nice to have the SQL backup in case you have an out and out disaster but you
cant beat a sharepoint backup for restoring sharepoint.

Answer #2 Answered By: Kalash Karmakar Answered On: Feb 10, 2010

There are also a bunch of things you need to back on
the file system of the SharePoint machines themselves.

Answer #3 Answered By: Mauricio Tanner Answered On: Feb 10, 2010

I just finished
writing a chapter for an upcoming book so I'm in that mode. I know
those periods get me, but the site of the sentence ending without one
was too much for me.

Answer #4 Answered By: Gina Freeman Answered On: Feb 10, 2010

I really thought there was more
to the backup than just SQL.

Didn't find what you were looking for? Find more on SQL Backup versus SharePoint backup Or get search suggestion and latest updates.