Solved

Microsoft BCM backup on WHS 2011

Posted on 2014-01-30
4
393 Views
Last Modified: 2014-02-07
hi,

we have Microsoft BCM data being hosted on a Windows Home Server 2011 machine with SQL Server Express 2088.

currently, we are using the Business Contact Manager for 2010 Database Tool to perform manual backups - not the ideal situation.

will the built-in WHS 2011 backup work when backing up our BCM SQL database?

if not, what are some cost-effective solutions for automatic backup of our BCM database?


Thanks in advance.
0
Comment
Question by:Go-Bruins
  • 2
  • 2
4 Comments
 
LVL 22

Accepted Solution

by:
David Atkin earned 500 total points
ID: 39823508
The built in Windows Server backup will do an image of the entire server.  

However, to be able to recover an application / database then the application needs to registered with Windows Server Backup for showing it as a recoverable item in the recovery wizard.

Please have a look at the below:
http://social.technet.microsoft.com/Forums/windowsserver/en-US/5d09965f-9de4-46c3-93d8-90575412efb9/windows-server-backup-server-2008-r2-x64-and-sql?forum=windowsbackup

I would suggest doing a scheduled backup from SQL Server Management Studio if it is installed.  If not installed then taking a backup with the BCM Database tool would also be acceptable.
0
 

Author Comment

by:Go-Bruins
ID: 39830130
Thank you for your response.

Can SQL Server Management Studio be set up to do automatic backups w/o any user intervention?
0
 
LVL 22

Expert Comment

by:David Atkin
ID: 39831804
In previous versions of the studio you can so I imagine so.  

It can always be done via a script and a scheduled task as well - You can probably do this with the BCM Database tools.
0
 

Author Comment

by:Go-Bruins
ID: 39842517
Thank you very much, David!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you don't know how to downgrade, my instructions below should be helpful.
This process describes the steps required to Import and Export data from and to .pst files using Exchange 2010. We can use these steps to export data from a user to a .pst file, import data back to the same or a different user, or even import data t…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now