How can I recover a SQL Server database when all I have left is the .DAT device?

A. For SQL 6.5 and below use the DISK REINIT and REFIT commands. These are documented in the Books-Online.

For SQL 7.0 use the sp_attach_db sp - also documented in the books online.


Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish