SQL Server 2008 Bring Database Online trying to open a file from a drive that doesn't exist

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/04/28 10:33 UTC
Read the original article Hit count: 338

Filed under:

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 domain keys and 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?

© Server Fault or respective owner

Related posts about sql-server-2008