Using SQL Server 2008R2 Express.
My db is a .mdf, 9GB in size. The .ldf is 23gb in size.
I am trying to attach my .mdf to SQL Server 2008R2 Express. The DB was take from our live environment. I am working in a test environment with 2008R2 Express.
When try attach - receive error:
___________________________________________________
Attach database failed for server "myserver/name". (Microsoft.SqlServer.Smo)
Additional information:
-> An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
-> Unable to open the physical file "e:\Myfile\name". Operating system error 2: "2(The system cannot find the file specified)". (Microsoft SQL Server, Error 5120)
___________________________________________________
I do not know why "cannot find the file specified" i ...
Go to the complete details ...