This is my answer too. Although some DBA believe that the shut down for the OS does it quickly, not giving enough time to complete the write operations to disk.

I...

I've had a sort of the same problem. Here is what we found out.

1) If the server has local disks that are not in use, use it for your TempDB....

Nicely done. I have a question about checking SQL Server Analysis services. When I check on a named instance, I get the proper status but on a default instance...

Thanks for help.

What about this location:

HKLM\System\CurrentControlSet\Services

It seems to have all the information even for the instances

I'm assuming that this would be the same if you wanted to check for Analysis Services, Integration Service and Full Text Search.

Do you know where I could find the information...

Interesting. I'll have to look into that.

The issues with this solution is that depending on the OS installed on the server, the location of that information may be in...

I forgot to mention that you may also want to look at LiteSpeed from Quest as it can do object level restores like tables, views and stored procedures to help...

I agree that HA products are not meant for correcting human errors like dropped tables. But the HA solutions can be used for hardware/electrical/AC failure and as a disaster recovery...

This is not required for the CA solution.

Thanks for the information, I'll have to keep it in case someone else I know may use it. 🙂

What a great place to...

[/quote]

Actually failover is automatic, you define the failover partner in the connection string. When the primary is unavailable the application attempts to connect to the failover machine. If you have...

I looked at database mirroring.

Here is what I found:

1) With mirroring, failing over (either way) requires work to be done at the application/workstation to point application to the new...

Hello,

I have several years of experience with CA's XOSoft. It works very well in both a disaster recovery or high availability scenario.

It works with the same hardware (or not) and...

Believe it or not but Microsoft's SQL server Books On Line (BOL) is very good too! If you don't have you can view it online or download it.

I think a...

Brent is a great place to start. You should also look at Microsoft's and VMWare's websites. VMWare is generally the vendor of choice.

You could also create a virtual server on your pc with Microsoft Virtual PC application. It's free! Once you installed it you would create a server and then install SQL...