PDSWSS
asked on
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?
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
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
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.
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.
Should databases be in Full recovery model and log should not grow forever, there should be t-log backup scheduled.
ASKER
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
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
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?
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?
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?
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?
ASKER
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.
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.
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?
ASKER
"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
I am making backups with the Maintenance plan and by job. Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.