Solved

backup restore options for wss 3.0 on windows server 2003

Posted on 2013-01-23
8
599 Views
Last Modified: 2016-03-20
hey there,

I've inherited a sharepoint site and am very novice about administering it.  Until last week, it was backing up via carbonite offsite but now we switched to Mozy pro and it's failing.

I'm getting vss sql writer errors in vss admin that's why that's occuring i'm guessing.

I tried doing a full farm backup in wss 3.0 console and that fails without backing up.

I'm also interested in using stsadm.exe to do site collection backups if possible. (I need to know what url to use for this and where and default directory is for this?

Once I have a good backup  then i'd like to use a script invoked by windows secheduled tasks to do a full and then differential backups on a two week schedule.

I have pretty limited space on the drives and the full farm is 18GB.  

Please help!  

metalfubar.
0
Comment
Question by:metalfubar
  • 4
  • 4
8 Comments
 
LVL 38

Accepted Solution

by:
Justin Smith earned 500 total points
Comment Utility
This is a great book on the subject.

What you go with depends on what your goals are as far as recovery.  Do you wish to provide very granular recovery, down to the document?  Or do you only want to protect from disasters, meaning you'll only ever need to restore an entire web app or farm?

If granular is your goal, a third party product like Idera, Quest, or MetaVis is probably your best bet.

If you want more of a disaster recovery, then the OOB backup in SharePoint or the OOB backup tools in SQL will work.  The problem with the SharePoint tools is there is no way to schedule them, without scripting.  So I tend to lean on SQL tools to backup all the databases.  As long as the databases are backed up, you could get your content back.


_________________________________________________________
Follow me on Twitter!  @justinsmith317
0
 

Author Comment

by:metalfubar
Comment Utility
Thanks for your post here.  I'll probably try the sq backup first see how it goes as they really only need disaster recovery.

So having said that, do I need to fix my vss sql writers to use this?  Is this accomplished in sql 5 or studio?  Ability to do full and diffs backups?

thx

todd
0
 
LVL 38

Expert Comment

by:Justin Smith
Comment Utility
The tools I'm speaking of are part of SQL Manager, the tool that comes with SQL Server.  Yes you can do full and diff backups.
0
 

Author Comment

by:metalfubar
Comment Utility
Ok.  Here's a snapshot of the manager below...

do I need to backup all of these individually including content?

todd
sql-backup-dbs.jpg
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 38

Expert Comment

by:Justin Smith
Comment Utility
Yeah you should grab them all.  The WSS ones are where your actual site content resides.
0
 

Author Comment

by:metalfubar
Comment Utility
thanks i'm getting an error while backup up on onedb error 845.  It may just be i/o busy?

the other is showing up as suspect and not allowed to be backed up.

do i need the system databases at all (master, model, msdb, tempdb)?

Other than that, i'm good to go, thx.
0
 
LVL 38

Expert Comment

by:Justin Smith
Comment Utility
SharePoint doesn't need those system databases, but most people back up at least the first three.
0
 

Author Comment

by:metalfubar
Comment Utility
thx much and take care.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

How to update Firmware and Bios in Dell Equalogic PS6000 Arrays and Hard Disks firmware update.
Create your own, high-performance VM backup appliance by installing NAKIVO Backup & Replication directly onto a Synology NAS!
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…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

744 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

15 Experts available now in Live!

Get 1:1 Help Now