May 4, 2010 at 10:57 am
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][1] 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? Thanks!
I'm running SQL Server 2008 Enterprise edition on Windows Server 2008 R2 64bit
[1]: http://www.jwc3.net/2008/12/sql-server-cannot-attach-database-that.html
May 4, 2010 at 5:40 pm
Are you trying to do this from script or from the GUI?
It needs that secondary data file, and you can remap it to another location but you need that file.
Long story short, you don't have all the files for this database.
CEWII
May 5, 2010 at 3:05 am
Elliott W (5/4/2010)
Are you trying to do this from script or from the GUI?It needs that secondary data file, and you can remap it to another location but you need that file.
Long story short, you don't have all the files for this database.
CEWII
I am writing to do this from the GUI. I understand that it needs the file but why is it trying to open it from E drive? I don't have an E drive on my system. I've tried this on 2 different machines and both met the same error.
May 5, 2010 at 7:03 am
From the GUI on the bottom of the window does it list the file on E:, if it does (and it should) it should say error or something next to it. You then use the elipsis (...) to find the file and it should work..
CEWII
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply