?
Solved

Sharepoint WSS3.0 backup script required

Posted on 2010-09-24
7
Medium Priority
?
886 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 2000 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
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 
LVL 2

Assisted Solution

by:nomisp
nomisp earned 2000 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
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 show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

777 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