Re: Backup software for SBS2003 Standard



I configured my test server with Windows Server 2003 and SCE, which runs on a SQL or MSDE database. With the system configured and running, did a SP backup to a network share. Booted into the controller firmware and deleted the RAID array, then created a new array. Booted from the SP CD and restored the server. When it came back up, there was some drive letter confusion and SQL did not start. Fixed the drive letters, manually started SQL, and went right back to work like nothing happened.

So the short answer is yes, Exchange and SQL can be backed up without any special considerations. As you say, I'd continue to do the online Exchange backups, maybe to file so they're included in the SP backups. For databases I care about, I do Enterprise Manager backups to file a few times a day, and those get included in the SP backups as well. (For something like WSUS or monitoring, I'm less concerned than I am with databases that effect the actual users).

StorageCraft recommends that if you're using SP on SBS, you enable the Exchange VSS writer, which is disabled by default.

How to turn on the Exchange writer for the Volume Shadow Copy service in Windows Small Business Server 2003
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q838183


"MM" <nosend2me@xxxxxxxxxxx> wrote in message news:3b7e3fec-effa-406f-b181-f5f5d53854fb@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Mar 29, 4:25 pm, "Dave Nickason [SBS MVP]"
<gwdib...@xxxxxxxxxxxxxxxxxxxxxx> wrote:
I would use SBS Backup. At least try it to see if you're satisfied. It's
documented, well-supported by the community, you have it already, and it
works. Using the built-in backup will save you from having to evaluate,
install, configure, monitor and learn a 3rd party app.

Backing Up and Restoring Windows Small Business Server 2003http://www.microsoft.com/downloads/details.aspx?FamilyID=487736F8-F6F...

If you end up deciding to go the 3rd party route, I strongly urge you to
take a look at ShadowProtect. I have a couple of servers running Arcserve,
bought before I became aware of ShadowProtect. I've grown increasingly
dissatisfied with Arcserve, including that I'm running it on a 64-bit server
where it's been constant trouble from the beginning. Having used
ShadowProtect on two member servers and been 100% satisfied, I plan to use
either built-in or SP for everything going forward. There's SBS pricing, so
make sure you find that if you're interested. (Note that SP doesn't do
tape). http://www.storagecraft.com/

"Steve" <wonderl...@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message

news:%23cspPKbkIHA.1168@xxxxxxxxxxxxxxxxxxxxxxx

>I have a question about what backup software is needed for Windows Small
>Business Server 2003 standard in an enviroment where Exchange and
>Sharepoint are not utilized. Some applications use MSDE or something
>similar such as Quickbooks Enterprise using SQL for their database >[though
>not requiring Microsoft SQL server]. When these types of applications are
>used can something like Backup Exec for SBS 2003 Standard properly backup
>and restore the databases of such applications or would the Premium >version
>be needed/desired. Thanks for any advice.

> Steve

I've just d/l'd and started testing Shadow protect server. I know I
still need to do Exchnage Online backups, what about sql? Does this
have the ability to handle point in time restores like transaction log
backups? Is it recommended to STOP exchnage and Sql before doing a
complete image?

I plan to try a bare metal restore this month - I'll pull all the six
drives out and stick my shelf spare and see what happens when I try to
restore just drive C....

MM

.



Relevant Pages

  • Re: Side-by-side upgrade - moving master, msdb and model
    ... MVP - Windows Server - Clustering ... "In some cases, you may want to copy the system databases, including ... from the source SQL Server 2000 instance to the SQL ...
    (microsoft.public.sqlserver.clustering)
  • Re: BizTalk Server 2004 ConfigFramework.exe error
    ... one BizTalk is installed on? ... machines (both for SQL and DTC) is not blocked by firewalls and new MSDTC ... Multi-computer configuration using Windows Server 2003 or Windows XP ... >>all associated databases. ...
    (microsoft.public.biztalk.general)
  • RE: Clustering a standalone SQL server + storage array
    ... working as expected with out error your ready to install sql server. ... log files to the data and log shared drives you setup as part of the cluster. ... Our apps team look after a trading system that uses an HP DL360 server ... running SQL 2000 SP3a with a few small databases on it. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Side-by-side upgrade - moving master, msdb and model
    ... MVP - Windows Server - Clustering ... "In some cases, you may want to copy the system databases, including the ... from the source SQL Server 2000 instance to the SQL ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2005 servers with multiple instances
    ... Microsoft SQL Server MVP ... given the same number of user databases. ... we've decided to use SQL 2005. ... SQL 2005 clustering? ...
    (microsoft.public.sqlserver.setup)