metalfubar
asked on
backup restore options for wss 3.0 on windows server 2003
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
ASKER
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
Yeah you should grab them all. The WSS ones are where your actual site content resides.
ASKER
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.
SharePoint doesn't need those system databases, but most people back up at least the first three.
ASKER
thx much and take care.
ASKER
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