compdigit44
asked on
SQL 2008 R2 DR Restore Question
We practice restoring our core servers twice a year. My question is in regards to restoring one of our SQL servers that has failed to be restored in the past. Please note the SQL databases are backed up via SQL then backed up as a flat file via TSM.
I was going to restore the data drive first since this is where the service reside before restoring the C and system state so the directory structure is in place for the services. After the server comes back up hopefully I will need to restore the master DB followed by the application DB's correct
I was going to restore the data drive first since this is where the service reside before restoring the C and system state so the directory structure is in place for the services. After the server comes back up hopefully I will need to restore the master DB followed by the application DB's correct
ASKER
A system state restore & data restore should cover this correct?
Correct or complete VM (VMDK) + DB
ASKER
My concern if with the master & system databases. Since these are active DB's they are backed up via a SQL job which TSM then grabs the flat file. If I do a system state restore the master DB would be missing correct?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
So after I do the system state restore I "should" not reboot the host but restore the master DB corrcet?
Hi,
That's not exactly what I mean. After system restore you need to recover SQL Server system databases, master at least (plus mssqlsystemresource database files). It doesn't matter if you perform SQL Server recovery before or after restart.
I'm not sure where you have installed SQL Server, only shared components are always installed in %systemroot%\program files. If that is the case you need to always backup your SQL Server binaries along with system backup.
Regards,
Daniel
That's not exactly what I mean. After system restore you need to recover SQL Server system databases, master at least (plus mssqlsystemresource database files). It doesn't matter if you perform SQL Server recovery before or after restart.
I'm not sure where you have installed SQL Server, only shared components are always installed in %systemroot%\program files. If that is the case you need to always backup your SQL Server binaries along with system backup.
Regards,
Daniel
ASKER
What will happen to the original SA password will it change?
Please read thru links I provided before, SA password needs to be provided during master rebuild procedure. In that other case when you recover system databases backed up as flat files your SA password will be from the time when backup was taken.
Regards,
Daniel
Regards,
Daniel
1. Restore the VM from backup.
2. Then Restore the SQL database.
So your practice is similar, we use DPM to backup our SQL servers.