Post reply

a datafile manually restored, db yet inaccessible

  • September 18, 2011 at 8:23 pm

    #247874

    Hi,

    I'm using SQL Server 2008 on Windows 2003 Server.

    I've the done the following:

    1. I opened SQL Server Confi guration Manager and stopped the SQL Server service

    3. I renamed the datafile of a filegroup (named as FG1) which belongs to PERTTEST database.

    4. I started the SQL Server service

    5. I connected to the instance with SSMS.

    6. I observed that although the entry for the PERTTEST database still exists, the database is completely inaccessible because the data file no longer exists.

    7. I manually renamed the data file back to its original name.

    My question is: How can I make the database accessible without restarting the SQL Server service?

    Putting it in Offline mode and then to Online mode didn't work with me.

    Thanks in advance.

  • September 18, 2011 at 8:28 pm

    #1383142

    sorry guys.. it seems taking the db offline and then online resolves the issue.

    It was my mistake becuase I actually didn't rename it to its original filename.

    Good day!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply