Backup problems with MSSMLBIZ

[Colin Foster]

Hi,
Don't know if this is the correct forum, but thought I'd start somewhere as
it's an issue linked to BCM2007.

We're running Small Business Server 2003 & using Veritas Backup Exec for
Wiindows Servers V10.0 to backup to tape.

At the moment, we're receiving a number of error messages as follows;
however, if we add these files to the backup, it "hangs"

So, the question is... has anyone else experienced these problems?
Obviously, until I'm sure that we're maintaining an up to date backup, I'm
reluctant to rely too much on BCM2007 in case we lose data. In addition, I'm
looking to install SBA2008, but have the same concerns that it won't be
backed up

And now the error messages...

Backup- C: Unable to open the item C:\Documents and
Settings\Administrator\Local Settings\Application Data\Microsoft\Business
Contact Manager\MSSmallBusiness.ldf - skipped.
Unable to open the item C:\Documents and Settings\Administrator\Local
Settings\Application Data\Microsoft\Business Contact
Manager\MSSmallBusiness.mdf - skipped.
Unable to open the item C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\master.mdf - skipped.
Unable to open the item C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\mastlog.ldf - skipped.
Unable to open the item C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\model.mdf - skipped.
Unable to open the item C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\modellog.ldf - skipped.
Unable to open the item C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\msdbdata.mdf - skipped.
Unable to open the item C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\msdblog.ldf - skipped.
Unable to open the item C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\ReportServer$MSSMLBIZ.mdf - skipped.
Unable to open the item C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\ReportServer$MSSMLBIZTempDB.mdf - skipped.
Unable to open the item C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\ReportServer$MSSMLBIZTempDB_log.LDF - skipped.
Unable to open the item C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\ReportServer$MSSMLBIZ_log.LDF - skipped.
Unable to open the item C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\tempdb.mdf - skipped.
Unable to open the item C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\templog.ldf - skipped

Regards
Colin Foster

 

[Lon Orenstein]

It looks like Veritas is not stopping the SQL service before it tries to do
a backup. BCM and all other SQL databases have a "hold" on them by the SQL
service and I thought that programs like Veritas could handle that.

You might also check the BCM Team Blogs for a SQL backup solution for the
BCM databases (that could work for other databases also...).
http://blogs.msdn.com/bcm/default.aspx

HTH,
Lon

___________________________________________________________
Lon Orenstein
pinpointtools, llc
(e-mail address removed)
Author of Outlook 2007 Business Contact Manager For Dummies
Author of the eBook: Moving from ACT! to Business Contact Manager
www.pinpointtools.com

 

[Colin Foster]

Cheers for this, Ron.

It confirmed something that I'd had hinted at by others (but 2+ "hints" = 1
"near certainty"!!!), so I've passed your comments (& MSDN link) on to my
techie guy to take a look at.

Thanks for your help