Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Microsoft BCM backup on WHS 2011

Posted on 2014-01-30
4
Medium Priority
?
417 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 2000 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

The core idea of this article is to make you acquainted with the best way in which you can export Exchange mailbox to PST format.
MS Outlook undoubtedly is the most widely used email client.Its user-friendliness, cost effectiveness, and availability with Microsoft Office Suite make it the most popular email application.  Its compatibility with Microsoft applications like Exch…
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
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: …
Suggested Courses

571 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