• You can restore through the GUI or through T-SQL commands, but you'll have to get everything set correctly. If there are 10 data files that define this database, you need to ensure that all 10 files have a WITH MOVE command to move them to appropriate storage locations on the new server (assuming the drive layouts are different). You can look at the backup file itself to identify the logical file names so that you can use WITH MOVE. This link describes how[/url] to get that information. This link shows basic restore[/url] processes, including WITH MOVE.

    To get better help, please post actual error messages. Just saying "it doesn't work" over and over doesn't help us. There are large numbers of places where things can go wrong and we're not sitting at your desk to see what you see.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning