PC Review


Reply
Thread Tools Rate Thread

Backup problems with MSSMLBIZ

 
 
Colin Foster
Guest
Posts: n/a
 
      26th Nov 2007
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
 
Reply With Quote
 
 
 
 
Lon Orenstein
Guest
Posts: n/a
 
      26th Nov 2007
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 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" <(E-Mail Removed)> wrote in message
news:604D6C3F-8FBD-43DB-9BAF-(E-Mail Removed)...
> 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


 
Reply With Quote
 
Colin Foster
Guest
Posts: n/a
 
      26th Nov 2007
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


"Lon Orenstein" wrote:

> 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 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" <(E-Mail Removed)> wrote in message
> news:604D6C3F-8FBD-43DB-9BAF-(E-Mail Removed)...
> > 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

>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
MSSQL$mSSMLBIZ Michael's Vista General Discussion 4 1st Jun 2011 08:23 AM
MSSMLBIZ zdaniel Microsoft Outlook BCM 0 2nd Nov 2009 02:10 PM
msSQL$MSSMLBIZ Not Started WFA Microsoft Outlook BCM 10 5th Nov 2008 03:18 PM
mssmlbiz.msi =?Utf-8?B?Q2hyaXMgU21pdGg=?= Microsoft Outlook BCM 0 31st Aug 2006 06:56 AM
Can anyone tell me what other Backup products have any of the problems that I have encountered with Veritas - Stomp's Backup MyPC? Richard A. Landkamer Windows XP General 6 8th Nov 2003 09:40 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:13 AM.