SQLTeam.com | Weblogs | Forums

Hard drive failure on sqlserver machine


#1

Hello,

The D drive on the SQL server machine ( version 2008 ) has failed and therefore the sqlserver service is not running.

( sql server executable was installed on D drive : D:\program files\MSSqlserver)

We have wiped reconfigured the drive and it is now clean and empty.

All the files on this drive gets backed up everynight on some other location and if we copy all the backup files

to this drive, will the sqlserver will start without any problems?

or we need to reinstall the software again on the D drive

Please let me know

Thanks

venkat


#2

You said that sql server executable was installed on D drive and that you wiped reconfigured the drive and it is now clean and empty. if you have a complete image backup of the drive before failure, you should be able to restore it and go.


#3

As long as none of the database files were on that drive. It isn't clear from your statement whether or not the system databases were on that drive or not.


#4

What about the Windows registry? Can you restore that as well? Just putting the software folders and files back will not be enough if it doesn't include the &^*(%$ registry.


#5

Sounds like he only lost the sql drive so the registry should be as it was beforehand.