Solved

Microsoft BCM backup on WHS 2011

Posted on 2014-01-30
4
394 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Are you unable to connect or configure Hotmail email account in Microsoft Outlook 2010, 2007? Or Outlook.com emails are not downloading to Outlook? Lets’ see the problem and resolve Outlook Connector error syncing folder hierarchy (0x8004102A).
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…

822 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