Recover Database(7.0) on 2000

Recover Database(7.0) on 2000

Post by franki » Sat, 09 Mar 2002 18:03:44



Hi all,
I have a MDF file which is the data file of a SQL Server 7.0 Database. Now I
want to recover it on SQL Server 2000.
Can I simpliy use sp_attach_single_file_db ? Thanks.
 
 
 

Recover Database(7.0) on 2000

Post by Narayana Vyas Kondredd » Sat, 09 Mar 2002 19:39:58


Yes, it should work, as long as the .mdf was cleanly detached from 7.0
--
HTH,
Vyas, MVP (SQL Server)

http://vyaskn.tripod.com/


Quote:> Hi all,
> I have a MDF file which is the data file of a SQL Server 7.0 Database. Now
I
> want to recover it on SQL Server 2000.
> Can I simpliy use sp_attach_single_file_db ? Thanks.