Solved

Sharepoint WSS3.0 backup script required

Posted on 2010-09-24
7
882 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

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.

Question has a verified solution.

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

A safe way to clean winsxs folder from your windows server 2008 R2 editions
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

688 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