Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

SQL Backup versus SharePoint backup

  Asked By: Loren    Date: Feb 10    Category: Sharepoint    Views: 5384

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



4 Answers Found

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

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

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

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

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.