Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 a datafile manually restored, db yet inaccessible

Author  Topic 

ozSQLServer
Starting Member

32 Posts

Posted - 2011-09-18 : 22:21:59
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.


Cheers,
ozSQL

ozSQLServer
Starting Member

32 Posts

Posted - 2011-09-18 : 22:31:31
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!

Cheers,
ozSQL
Go to Top of Page
   

- Advertisement -