Solved

Sharepoint WSS3.0 backup script required

Posted on 2010-09-24
7
855 Views
Last Modified: 2012-05-10
I am looking for a backup script that will probably use STSADM that will back all of my sites and all of my subsites.

I have tried a few, and the best one seems to be a script called spsitebackup.wsf which is invoked from a batch file.  (http://ptgmedia.pearsoncmg.com/images/9780672329470/downloads/SPSiteBackup.wsf.txt) is a sample of this.

I have got this working, but when it enumerates my sites, it only finds 2.  I need one that will enumerate my subwebs and then add them to the backup list to.


So, all I need is a simple backup script that I can put into a scheduled task that backs up the entire farm without having to spend money on a sharepoint agent for Backup Exec.

Has anybody actually found anything that works?

0
Comment
Question by:Coast-IT
  • 5
  • 2
7 Comments
 
LVL 2

Accepted Solution

by:
nomisp earned 500 total points
ID: 33752667
I just run the below from a batch file to back up the whole farm.

cd\
cd C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN
stsadm -o backup -directory D:\Backups\SharePoint\SPS -backupmethod full
0
 
LVL 11

Author Comment

by:Coast-IT
ID: 33752831
I have already tried that.  When I back up from the GUI, it is 3GB.  When I backup using the standard STSADM command I get 335KB :-)

I know in theory that should work.

Any more ideas?
0
 
LVL 11

Author Comment

by:Coast-IT
ID: 33752895
I also tried a similar command which backs up to a .dat file that is nearly 3GB.


stsadm -o backup -url http://rootofintranet -filename e:\sharepointbackup\backup.dat -backupmethod full

much the same, but it does not give me the results of the GUI backup and does not back up the whole farm.
0
Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

 
LVL 2

Assisted Solution

by:nomisp
nomisp earned 500 total points
ID: 33753259
0
 
LVL 11

Author Comment

by:Coast-IT
ID: 33753525
That just gives me the same answer as nomisp.

I am sure that should work, but doesn't :/

stsadm -o backup -directory \\server\backupshare -backupmethod full

Strange
0
 
LVL 11

Author Comment

by:Coast-IT
ID: 33753600
Ok, after much deliberation I got the command working.

I actually changed the logon for the SQL instance to an administrator and restarted the service.

I then ran the command and it worked.

Thanks
0
 
LVL 11

Author Closing Comment

by:Coast-IT
ID: 33753610
Good answer, thanks for the pointer.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Setting up a Microsoft WSUS update system is free relatively speaking if you have hard disk space and processor capacity.   However, WSUS can be a blessing and a curse. For example, there is nothing worse than approving updates and they just have…
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now