SQLServer - disaster recovery

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Griff (Howling_at_The.Moon)
Date: 09/09/04 

Date: Thu, 9 Sep 2004 15:17:47 +0100

I understand that if a machine running SQLServer crashes [Standard Edition]
then the data and log files may well be left in an open (attached) state.
This means that one couldn't stick the disks into a new machine and start
using the databases because they would need to be closed (detached) first
and one needs the now dead server to achieve this.

I'm wondering whether the following scenario may help solve this issue.

If I used a machine running some sort of virtual server technology (such as
VMWare's GSX server) then this could run a virtual GUEST server whose disk
image was stored on a SAN (or similar device). If the machine died, then I
could simply replace that machine with another that had (say) GSX server on
it and point it to the existing virtual image on the SAN. This virtual
image contains the SQLServer, so there's no problem having to
detach/reattach the databases.

Have you attempted something similar? If so, was it successful?

If you haven't attempted this, does it sound sensible?

I guess that I'd need to identify whether the virtual Guest could be left in
a similar "open" state, thus preventing another HOST from running it.

Griff

Relevant Pages

  • SQLServer - disaster recovery
    ... I understand that if a machine running SQLServer crashes ... If I used a machine running some sort of virtual server technology (such as ... it and point it to the existing virtual image on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • Zero administration sshd on windows?
    ... We are running a small peer to peer network, ... each machine running an SFTP/SCP client and server. ...
    (comp.security.ssh)
  • Search not working in MOSS 2007
    ... Im running a farm setup with one machine running all the services. ... When try to search for something I get no error in the event log. ... When i remove the search service from the server i get the following ...
    (microsoft.public.sharepoint.portalserver)
  • Re: OT: Network music players
    ... but it does need to have a server that runs ... But then I need a machine running itunes... ... Personally I'd go for a Slim devices thing, ... Linn Genki CD, Kolektor pre-amp, Linn LK140 power amp, passively bi-wired to ...
    (uk.rec.motorcycles)