Sunday, January 23, 2005

Small Business Server Backup Failed - A Simple Problem

Last week I had a Backup Failure on Windows Small Business Server Premium. The Shadow Copy failed on drive C. When that happens SBS Backup reports failure because of the large number of open files it skips.

This is a simple problem. One of the SQL Databases had been set to a full recovery model instead of “simple” recovery model.

According to the Microsoft Small Business Server troubleshooting page, “SQL ServerTM?2000 is installed and one or more databases have a recovery model that is not set to Simple. Windows Small Business Server?2003 Backup can back up a database only if its recovery model is set to Simple.”

How do you fix this?

If this happens you will have an critical error in the Monitoring and Reporting screen in Server Management that will tell you which database has a problem.

Open SQL Server Enterprise Manager and find the database container from the name in the critical error. Right click on it and select properties. Go to the Options tab and look at the recovery Option in the middle of the screen and set the model back to simple. Click OK and close SQL Server Enterprise Manager. Whey you run the backup again it will have a nice green checkmark in the status column indicating success.

Posted by Stevereno on 01/23 at 12:58 PM

Wednesday, January 05, 2005

Bootable CD Saves The Day

Travis has a great article, What’s in your tool bag?  He uses a bootable CD for system recovery.  Bart’s PE bootable XP CD could be a great addition to your set of tools.


Posted by Stevereno on 01/05 at 07:59 PM

Tuesday, January 04, 2005

Sharepoint Lists - Powerful Stuff!

Serge van de Over writes about Sharepoint lists functionality  right out of the box. There is a lot of power in Sharepoint. Here is an under the hood look at what you can do with lists.

Posted by Stevereno on 01/04 at 05:39 PM