Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

SPS Backup

  Asked By: Mackenzie    Date: Nov 09    Category: Sharepoint    Views: 1816

I want to try and automatically take backup of SPS 2003 through
scripts at a certain interval of time each day.

How can I do that?



18 Answers Found

Answer #1    Answered By: Brooks Bond     Answered On: Nov 09

I would suggest creating a batch file that runs spsbackup.exe, and schedule the batch file to run through your Windows Scheduled Tasks.

Answer #2    Answered By: Gregg Wilkinson     Answered On: Nov 09

In practice, many organizations use SQL backup  scripts to back up their SharePoint environments.

spsbackup.exe is only really needed to backup the index catalogs (if you choose to back them up at all).

One "gotcha" with using SQL backup scripts is that you have to manually keep them up-to-date (i.e. the list of databases to be backed up).

Answer #3    Answered By: Darrel Sexton     Answered On: Nov 09

spsbackup.exe hasnt worked...

Could you be a little more specific!!! As in the detailed steps to follow....

Answer #4    Answered By: Tory Sellers     Answered On: Nov 09

1. Open SQL Enterprise Manager
2. Identify the databases that are part of your WSS and/or sps  environment.
3. Use the SQL Query Analyser to develop and test your T-SQL commands to backup  the database files. (This also includes writing and *testing* the db restore scripts at the same time.)

Answer #5    Answered By: Agustin Miranda     Answered On: Nov 09

The batch file script will be like this.

spsbackup /portal http://pcfbg96049:8222/ /file D:\spsbak\8222.bak /overwrite
spsbackup /portal http://pcfbg96049/ /file d:\spsbak\defa.bak /overwrite

Let me know how your back goes.

My backup  stopped after fifteen days.

I dont know the reason but script runs but backup does not happen.

Answer #6    Answered By: Arron Middleton     Answered On: Nov 09

Is it possible that you've run out of disk space?

Answer #7    Answered By: Vance Hardin     Answered On: Nov 09

Disk space is abundant.

I have got around 12 Gig of free space present.

so i dont think this is the issue.

But this same command ofcourse with a change in portal name works fine in my test server.

I dont know how to identify what went wrong all of a sudden.

Answer #8    Answered By: Kareem Flynn     Answered On: Nov 09

Yes..... I have tried this out... and exactly the same thing happened
to me..... only that mine stopped after only a single use.....

The script has stopped working since then.... i.e. they run but no
backup happens...

Anyone that can daignose the issue??

Answer #9    Answered By: Tyron Calderon     Answered On: Nov 09

Did you make any changes recently ?

In our case it stopped after quite many days.

The same thing runs fine on my test server everyday.

My team might have made changes which has affected this but we are not able to pin point which change caused this effect.

Answer #10    Answered By: Irvin Foley     Answered On: Nov 09

I have made no changes after running the SPSbackup script
This is really frusturating...... I tried the script on another server
as well... and the same thing happened......

My Script: (running in BAT file)

@echo off
echo ===============================
echo backup  sites on the SharePoint Portal 2003 Server
echo ===============================
cd \Program Files\SharePoint Portal Server\Bin
@echo off
SPSBACKUP.EXE /all /portal http://myserver:8085 C:\SPS_BACKUP\MYBackup
echo completed

The directory C:\SPS_BACKUP\MYBackup is already inplace before running
the script.

Answer #11    Answered By: Deonte Stein     Answered On: Nov 09

Have you found any solution to this.

Or have you adopted any other backup  strategy.

Please let me know as i do not have backup and i am at my wits end.

Answer #12    Answered By: Stephon Valentine     Answered On: Nov 09

I havent found any solution....

I have also thrown in the question at other newsgroup but the support
has been almost non-existent.....

For the while.. I am taking manual backup.... which in no way is a
permanent solution.....

Answer #13    Answered By: Leif Cardenas     Answered On: Nov 09

My backup  started working there was some lock on the job.

Check the application pool identity in the IIS also the check which id the share pint services is using to start this.

My batch file is in the location c:\Program Files\SharePoint Portal Server\Bin

spsbackup /portal http://hpcepmportal:2001/ /file :\spsdata\FoodPortal\hpcFood.bak /overwrite

I run this from admin login scheduled task.

Also i noticed in your script it is

cd \Program Files\SharePoint Portal Server\Bin

This should be CD c:\Program Files\SharePoint Portal Server\Bin.

I dont know if you orginal script is like this but here you have missed the c:

If you have not missed it then try checking all the stuff i told you before.

Hope yours also start working.

Answer #14    Answered By: Jasper Hatfield     Answered On: Nov 09

If a third party solution is an option, see

Answer #15    Answered By: Rashawn Hopper     Answered On: Nov 09

Can you summarize the question/problem again. We are successfully taking
automated SPS backups every night. I didn't set it up but I could
certainly talk with our network admin and ask her how it differs from
your situation.

Answer #16    Answered By: Horace Coffey     Answered On: Nov 09

I had written a back up like this.

spsbackup /portal http://hpcepmportal/ /file f:\spsdata\HPCEPMPORTAL\hpc1.bak /overwrite

spsbackup /portal ttp://hpcepmportal:2001/ /file :\spsdata\FoodPortal\hpcFood.bak /overwrite

spsbackup /portal http://hpcepmportal:2000/ /file f:\spsdata\Unilever-rsd\Unilever-RSD.bak /overwrite

spsbackup /portal http://hpcepmportal:11000/ /file :\spsdata\HPCEPM\EPMSupport.bak /overwrite

It was going on fine and My backup  stopped after fifteen days.

I dont know the reason but script runs but backup does not happen.

My Team might have changed some setting which led to this but we are unbale to locate this issue.

This batch file runs as a schedule task from the location C:\Program Files\SharePoint Portal Server\Bin

It runs using the Local admin account.

There is enough space for the backup in f:\spsdata so that discounts any issues due to space constraint.

Answer #17    Answered By: Rigoberto Beard     Answered On: Nov 09

I'm looking at MindSharp's back-up and restore documents that I found


On page 10, it gives us an SPSBackup.exe command that looks like this:

spsbackup.exe /all /file e:\spsbackup\daily\dailybak190104 [BACKUP

I don't understand the "e:\spsbackup\daily\dailybak.190104" part.

I'd like the backup  files to go into my c:\temp\spbackups\050531
folder and the server does not have an e:\

Answer #18    Answered By: Alphonso Mckay     Answered On: Nov 09

Just change the e: to whatever drive letter you want to use.

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