On MS SQL 2005, I want to restore a backup file that was created from different server
Posted on 2008-06-13
I am using MS SQL Server 2005 and I need to restore a backup file which was created on different server.
So I this was what I did:
1. Created a New Database on my SQL server
2. Right click the database
3. Tasks > Restore > Database
4. On "Source for restore" section, Selected "From Device"
5. Browse the file and selected the backup file and clicked "Ok"
After doing all of the above, I should see at least one list, but there is nothing to select.
Is it because the backup file is created from different server?
What should I do?