Course Of The Month
11 days, 5 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
backup restore options for wss 3.0 on windows server 2003
Posted on 2013-01-23
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.
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.
[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
4-
4
8 Comments
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
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
Active today
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
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
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.
Active today
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
do I need to backup all of these individually including content?
todd
sql-backup-dbs.jpg
Active today
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.
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.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Microsoft will be releasing the Windows 10 Creators Update in just a matter of weeks. Are you prepared? Follow these steps to ensure everything goes smoothly and you don't lose valuable data on your PC.
- Storage Software
- Windows 10
- PC
- Acronis
- Microsoft
- *Backup Software
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention.
Multiple USB devices need t…
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target.
To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month11 days, 5 hours left to enroll
628 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.