I'm trying to restore a database from the Alpha server to an Intel server.

With this statement: Load database PEOPLE From disk='D:ackuppeople.DAT'

I get this error

Msg 3102, Level 16, State 1
Specified file 'D:ackuppeople.DAT' is not in valid dump database format.

people.dat is a database backup file from an Alpha server.

This also fails in Enterprise Manager's Restore/Backup
Help!!

------------
Ray Miao at 12/10/99 1:25:18 PM

Try "load database ... from disk = 'pathfile' ...".


------------
Angel at 12/10/99 1:02:56 PM

Hi,

I'm trying to move a database over from an Alpha to an Intel-base PC. The SQL Server database is on an Alpha server. The 2nd machine is an Intel. When I make a backup of the database from Alpha, copy over the file to the 2nd PC (Intel) and then try to restore it from the 2nd PC, it doesn't sure up on the list of restores when I click on 'Add Device'

The only other way I can get this to work successfully is with a Database Object Transfer, which takes too long (several hours) and limits me to being on site. I need to do this every few weeks so I need a better way to transfer the database over ?

Anyone have any experience with SQL Server on Alpha??