Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dewacorp.alliances
452 Posts |
 Posted - 2007-04-13 : 01:23:50
|
| Hi thereWe really want to test 2 following crashes:1. OS Crash2. SQL Server CrashWe have a SQL backup of all databases remotely as .bak file (including master, msdb etc etc). So from what I understand if the schenario 1 happens, we have to build the OS and SQL server and restore those system databases. If we want to cut the step by doing backup the system state inclduing files (Netbackup), if the OS crach happens, I guess this sort of thing will restore as it is using Netbackup and then restore the application database manually using SQL?Does any one have a clear procedure/approach this?Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-14 : 19:47:49
|
| Yes, but does Netbackup be able to back open db files? If so, why don't backup all db files? |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-04-15 : 20:30:16
|
| You should plan on recovering all SQL Server databases, both system and application databases, from SQL Server backup files only.CODO ERGO SUM |
|
|
|
|
|
|
Schenario for OS or SQL Server 2000 crash