SQL Server 2008 Unique Problem for bring DB Online...
- by Nai
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