My computer has recently crashed and I can only run it in Safe Mode. I need to back up a SQL server 2005 database and transfer it a computer that works.
Is there anyway to run SQL server 2005 in Windows Vista Safe Mode?
+3
A:
I'm pretty sure that SQL won't start.
However you can take the MDF, NDF (if any) and LDF files and copy them to another computer, attach them to the SQL Instance on that computer and you will be up and running.
mrdenny
2009-03-31 04:15:36
Thanks - I was able to copy the MDF file from my broken computer and attach to the application that uses it through a db utiltiy provided by the vendor.
Michael Kniskern
2009-03-31 15:46:02
Glad it got fixed.
mrdenny
2009-04-02 23:51:17