SQL Server 2008 Unique Problem for bring DB Online...
Posted
by Nai
on Server Fault
See other posts from Server Fault
or by Nai
Published on 2010-04-28T10:28:40Z
Indexed on
2010/05/04
17:38 UTC
Read the original article
Hit count: 605
This is my error I am facing
TITLE: Microsoft.SqlServer.Smo
Set offline failed for Database 'Go3D_Retailer
------------------------------ ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Unable to open the physical file "E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\ftrow_Go3D_catalog.ndf". Operating system error 2: "2(failed to retrieve text for this error. Reason: 15105)". Database 'Go3D_Retailer' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. ALTER DATABASE statement failed. (Microsoft SQL Server, Error: 5120)
Background to this error I've been trying to move my destination logshipping database to another physical server for analysis purposes. Because I do not have active directory set up, I had to hack my process by using the same username/password for both the source and destination servers to get the process to work.
Following that, I used this guy's solution to move the destination database to another server. However, this error occurs when I try to bring the database back online.
I don't have an E drive on my server and I have no idea why it's trying to open a file from E drive. I have over a 100gb left on my hard disk so it's definitely not a space issue. This sounds like a bug... Any ideas?
I'm running SQL Server 2008 Enterprise edition on Windows Server 2008 R2 64bit
© Server Fault or respective owner