1

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?

Dhaust
  • 5,470
  • 9
  • 54
  • 80
Michael Kniskern
  • 24,792
  • 68
  • 164
  • 231

1 Answers1

3

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
  • 4,990
  • 2
  • 21
  • 28
  • 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 Mar 31 '09 at 15:46
  • Any tips on how to discover the path to the MDF sql server is using withou running it? I'm having the same problem, but i'm not sure wich .mdf file is the one sql is actually using (i've some old others). Is it in registry or someplace like that? – Marlon Apr 27 '13 at 13:01
  • The only MDF which is stored is the registry is the path to the master database files. Everything else is stored in the master database. You would need to start the SQL Server and query from sys.database_files or sys.master_files to see which physical files are attached to the database. – mrdenny Apr 28 '13 at 09:08
  • If Windows won't boot normally, getting SQL Started is the least of your problems. – mrdenny Apr 26 '17 at 01:17