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 |
|
debug
Starting Member
29 Posts |
 Posted - 2003-06-13 : 18:03:51
|
| Please let me no the fastest ways to recover the SQL server ASAP.DU |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-13 : 18:11:02
|
| Are you just trying to recover the database or the entire server? Do you have a full backup of the database, how about the server? Fastest way is to attach your database if you have the MDF file. You could also restore your database using your database backup. But I'm unclear as to what the problem is. What exactly is the problem that you are having?Tara |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-13 : 18:12:37
|
| I just looked at your profile and you say that you are a DBA. Don't you know how to recover your SQL Server? That's a fundamental responsibility of a DBA.Tara |
|
|
|
debug
Starting Member
29 Posts |
Posted - 2003-06-13 : 18:53:05
|
| Tara,I asked for fastest way to recover the sql server when the OS crashes..I am aware about the attach and detach business..I just wanted some other more faster way.Please let me know.DU |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-13 : 19:01:24
|
| Well you didn't mentioned when the OS crashes, so there wasn't enough information to provide the answer.Here are some answers:Fastest way would be to failover to the other node in your cluster. Without clustering though, another way would be to fail over to the standby server or recover your log shipped database. There are lots of ways to recover the server, but it depends on what your environment is doing. Clustering is the best way to go because SQL Server can fail over in about 30 seconds. We use clustering AND log shipping.Tara |
|
|
|
debug
Starting Member
29 Posts |
Posted - 2003-06-13 : 19:14:21
|
| thanks Tara...I will be implementing Clustering for my critical servers...as the the money has been approved.DU |
|
|
|
|
|
|
Immediate Server recovery