• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 894
  • Last Modified:

Sharepoint WSS3.0 backup script required

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
Coast-IT
Asked:
Coast-IT
  • 5
  • 2
2 Solutions
 
nomispCommented:
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
 
Coast-ITAuthor Commented:
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
 
Coast-ITAuthor Commented:
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
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
Coast-ITAuthor Commented:
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
 
Coast-ITAuthor Commented:
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
 
Coast-ITAuthor Commented:
Good answer, thanks for the pointer.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now