September 18, 2011 at 8:23 pm
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
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