Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

WSS 3.0 backup queries

  Asked By: Jordan    Date: Feb 22    Category: Sharepoint    Views: 1370

I have few questions for WSS backup. Please be kind enough to reply.

1) Firstly what is suggested a web app back up or a full back up.
I would prefer a web app back if its easy to restore..

2) Also if I need to schedule back up to run daily, do I need to
do it through stsadm and run it as schedule task or can I do it through
Central Admin.

3) Finally if I put differential backup, how easy it is to
restore. Somehow I am not comfortable with this term.

4) I am trying to take backup of my web app or full farm, it gives
below error:-

Object WSS_NewDelhi failed in event OnBackup. For more information, see
the error log located in the backup directory. SqlException: The backup
of the file or filegroup "sysft_ix_DB_NewDelhi" is not
permitted because it is not online. BACKUP can be performed by using the
FILEGROUP or FILE clauses to restrict the selection to include only
online data. BACKUP DATABASE is terminating abnormally.

WSS_NewDelhi is the name of the database connected to my Web App.



2 Answers Found

Answer #1    Answered By: Jan Chen     Answered On: Feb 22

If you use the backups in Central Admin you must write to a UNC instead
of a local directory. Part of that backup  process is done on the SQL
server, so you must use a UNC if SQL is running on another server. Are
you using a UNC? Also, since part of the Farm backup is performed on
the SQL server, the account SQL is running as must have read and write
access to the UNC share you provide or the backups will fail.

You can do the same backups with "STSADM -o backup -directory." If you
want to schedule  them STSADM is the only way. You cannot schedule them
in Central Admin. If you do them in STSADM the user you run  them as
must also have read and write access to the UNC you use for the

I've never recovered a Farm level backup with a differential backup, but
I would assume it would be as easy  as restoring your last full  and then
the Differential.

Answer #2    Answered By: Britni Shepard     Answered On: Feb 22

Just one more question:-

I am using a UNC path and my SQL server is on same machine.I made sure
that the account has full  access on database  but no go.

However If I run  it through command prompt through stsadm, its running
fine........should that be ok or any issue with that....??

Didn't find what you were looking for? Find more on WSS 3.0 backup queries Or get search suggestion and latest updates.