How to restore sql 2005 database on sql 2008 server from mdf when older copy of database already on new server
Posted on 2016-11-01
I have a SQL Server 2005 Express database on a Windows 2003 server which recently crashed. I had been working on a new server using Server 2008 and SQL 2008 R2, but the project had been sidelined due to more pressing matters. I wasn't able to get SQL Server Management Studio Express to open on the old server, but I did locate the mdf and ldf files for the database and copied them to a flash drive. I then copied the files into the SQL data location on the new database, though Windows balked since there's already a database with that name. I did make a backup of the database on the new server, which I copied off of the server, before this process. The question is, since a SQL database with the same name already exists on the new server, how can I import the new data into the existing database? I searched on the issue of restoring databases using only mdf and ldf files, and apparently it is possible, though I'm getting errors (see attached Word document with screenshots).
Thanks in advance,