Solved

Will a Bare Metal Recovery in Windows 2008 create a backup that will completely restore SQL 2008 R2, Sharepoint Foundation 2010 and all the associated databases?

Posted on 2011-03-13
9
807 Views
Last Modified: 2012-06-27
We have a Web Application with an SQL 2008 R2 backend and a Sharepoint Foundation 2010 site also with a SQL 2008 backend.

I am creating daily  Bare Metal recovery backups so we can restore the entire server in the case that one of the HDs crashes or gets corrupted.

Will Bare Metal Recovery completely restore SQL Server 2008, Sharepoint Foundation and all the associated databases onto another Server?

Thanks

0
Comment
Question by:PDSWSS
  • 5
  • 3
9 Comments
 
LVL 4

Expert Comment

by:CHutchins
ID: 35122091
If it is a true bare metal backup it should handle all software and settings to take i back to when the image was made.  
0
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 35122700
Please keep in mind that relying on bare metal backups only will not properly maintain databases log files.
Should databases be in Full recovery model and log should not grow forever, there should be t-log backup scheduled.
0
 

Author Comment

by:PDSWSS
ID: 35122814
Daniel_PL

What do you suggest?  I would like to avoid reinstalling all software on our other server which recently crashed (defective drive - replaced with a new one) by restoring
 with a  Bare metal backup from this server.
Thanks
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 14

Expert Comment

by:Daniel_PL
ID: 35122997
I'm suggesting you to not overlook some important considerations about database backup.
For system and other important files which you should backup it's ok to backup them. You can also backup database files using that kind of backups - like e.g. ntbackup utility. Are you also reponsible for database administration?
0
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 35122998
I'm suggesting you to not overlook some important considerations about database backup.
For system and other important files which you should backup it's ok to backup them. You can also backup database files using that kind of backups - like e.g. ntbackup utility. Are you also responsible for database administration?
0
 

Author Comment

by:PDSWSS
ID: 35123201
Thanks. Yes I am the database admin and I'm relatively new to SQL. Any advise is appreciated.   Which files won't work for this type of backup?
I am mainly concerned about SQL since in the case of breakdown, which we just had (RAID system got corrupted - one drive developed bad blocks and the other drive mirrored the bad blocks, need to be 100% sure I can recover all of the critical databases.
0
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 35123292
All files will work for this type of backup. This isn't the case. Are you taking backups using SQL Server, agent by job or by maintenance plan?
0
 

Author Comment

by:PDSWSS
ID: 35124847
"All files will work for this type of backup. This isn't the case."    This is not clear. Please clarify - Do you mean all files will NOT work with this type of backup?

I am making backups with the Maintenance plan and by job.  Thanks
0
 
LVL 14

Accepted Solution

by:
Daniel_PL earned 500 total points
ID: 35125701
Ok, by using backup utilities and taking 'bare metal' backups you are backing up raw data from disks. My point was to show you that by relying on that kind of backup only, you won't be able to e.g. backup transaction log.
If you are taking backups of your databases in SQL Server and also backing up your data, system files, etc. with apropriate utility you are in a good way to be able to restore your enviroment.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
DTS Connection Failed 7 66
SharePoint 2013 Link to File on Network Drive Not Working 3 21
Webservices in T-SQL 3 30
always on switch back after failover 2 32
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

776 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