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.
| 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 service3. 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 |
 |
|
|
|
|
|
a datafile manually restored, db yet inaccessible