Backup problems with MSSMLBIZ

C

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
 
L

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
 
C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cannot open this item,error loading form, some of the needed controls may not 1
Error : "Cannot open database XXX requested by login." 2
SQLDMO attachDB error with filenames including space character 4
Can't Use BCM! Please Help! 2
Rolling my own Install w/ MSDE 3
Create SQL Db on SQL server 3
"Business Tools" does not appear in Outlook with Outlook in "Start 1
Firewall Settings for SQL Server 1

Top