Sql-server – Attach database failed for Server ‘{SERVER_NAME}\{INSTANCE_NAME}’. (Microsoft.SqlServer.Smo)

sql-server-2008

Strange, I tried to attach the database AdventureWorks from this site – http://sqlserversamples.codeplex.com/

However, I encounter the following problem while attaching AdventureWorks2008R2_Data.mdf

Attach database failed for Server '{SERVER_NAME}{INSTANCE_NAME}'. (Microsoft.SqlServer.Smo)

Additional Information:

An Exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Directory Lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL10.50.MSSQLSERVER\MSSQL\DATA\AdventureWorks2008R2_Log.ldf" failed with the operating system error 3 (The system cannot find the path specified.). (Microsoft SQL Server, Error: 5133)

Best Answer

You need the "AdventureWorks2008R2_Log.ldf" file. And put it in this folder: "C:\Program Files\Microsoft SQL Server\MSSQL10.50.MSSQLSERVER\MSSQL\DATA\"

The easiest thing to do is download the "full backup" file from that site and then restore it, (instead of attaching.)

Related Solutions

Sql-server – How to restore multiple backups

Using SSMS, you cannot chain a restore of the backups in one operation. You would have to do multiple restores. You'll want to use T-SQL in order to be more efficient.

--Restore the most recent full backup
RESTORE DATABASE <mydb>
FROM DISK = 'Path to full backup'
WITH NORECOVERY, STATS=10 --If only restoring the full, change to RECOVERY

--Restore the most recent diff backup
RESTORE DATABASE <mydb>
FROM DISK = 'Path to diff backup'
WITH RECOVERY, STATS=10

More info on RESTORE: http://msdn.microsoft.com/en-us/library/ms186858.aspx

Sql-server – How to Setup SQL Server 2008 R2 Mirror

Have you checked the connection from mirror to principal with telnet? Have you restored a log backup at the mirror?

I posted a couple of diagnostic queries in an earlier q/a on mirroing. Run those and update your answer with the output.

Best Answer

Related Solutions

Sql-server – How to restore multiple backups

Sql-server – How to Setup SQL Server 2008 R2 Mirror

Related Question