Solved

Microsoft BCM backup on WHS 2011

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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Follow this checklist to learn more about the 15 things you should never include in an email signature from personal quotes, animated gifs and out-of-date marketing content.
Finding original email is quite difficult due to their duplicates. From this article, you will come to know why multiple duplicates of same emails appear and how to delete duplicate emails from Outlook securely and instantly while vital emails remai…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
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: …

808 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