Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2003
    Posts
    5

    Unanswered: SQL Server DB Recovery

    Had to re-install SQL server and reformat the hard drive. Prior to doing this, detached the database and saved it. I have re-installed SQL Server (personal edition) and re-attached the database. Only problem is that the database shows "read-only" and I got an error when I unchecked the read only box. Any ideas?

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: SQL Server DB Recovery

    What was the error you're getting?

  3. #3
    Join Date
    Dec 2003
    Posts
    454
    Did you use your "sa" account to do that?

  4. #4
    Join Date
    Dec 2003
    Posts
    5
    Error message is as follows:

    Error 5105. Device activation error. The physical name "c:\program files\microsoft SQL server\mssql\intelaTrac" may be incorrect.
    Device activation error. The physical name "c:\program files\microsoft SQL server\mssql\intelaTrac_log.ldf" may be incorrect.
    Could not restart database IntelaTrac. Reverting back to old state.
    Activate database failed.
    Device activation error. The pysical name ""c:\program files\microsoft SQL server\mssql\intelaTrac_log.ldf" may be inccorrect.
    sql.dboption command failed.

  5. #5
    Join Date
    Dec 2003
    Posts
    5
    went into enterprise manager. don't remember if it asked for a log-in.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •