Solved

Sharepoint WSS3.0 backup script required

Posted on 2010-09-24
7
877 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
Business Impact of IT Communications

What are the business impacts of how well businesses communicate during an IT incident? Targeting, speed, and transparency all matter. Find out more in this infographic.

 
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

Are your AD admin tools letting you down?

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.

Question has a verified solution.

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

You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
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 give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

734 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