If the two servers can be reached from a workstation you can use the tools at
www.sqlaccessories.com - this worked for me in more than one ocassion.
-R!
>>I have a backup file from a database on SQL 2008 and wanted to restore it to my SQL 2005. Is this possible? I get an error when I try. If I just attach the MDF file will that work?
>>Thanks
>>Tim
>
>Script your database with insert scripts from SQL 2008 and target for SQL 2005. This way you would be able to restore your database with data files on the SQL Server 2005.
Ricardo A. Parodi
eSolar, Inc.