SQL Server 2005 Restore?

Question

Im trying to transfer my backup files from a production SQL Srvr 2000 instance into an instance of SQL Server 2005 Dev. Edition(Windows Server 2003 - Virtual Server). When I go through the Restore process it errors out looking for a D: drive. We only have a c: drive cause we're just testing on a Virtual Server. Why does it need a D: drive, is it because the instance it came from was backed-up to a D: drive? Also, what stored proc runs the restore process? Thanks!!

Answer 1

Possible Cause -

The backup file from which you are trying to restore database had its Primary Data File (mdf) or Transaction Log File (ldf) on drive d.



Solution :

In the Restore dialog window, correct the location of Primary Data File and Transaction Log File to (C:) drive.



.

Answer 2

bypass to homes on the database, ideas section, set the compatibility point to Server 2005. back up the database now and attempt restoring it back. outdoors of this, you are able to not fix or connect an 08 DB to an 05 server. Or fix it to an 08 server, exchange this putting and re-back it as much as fix it on the 05 server.

Answer 3

Simply copy/paste .mdf and .ldf files

and attach them to SS2005. It works.