Hi Guy,
Yes, I was able to restore the database and SQL Server converted the database from older version to the new one on-the-fly. I used options WITH MOVE when restoring in order to get around the problem that the database was in a different directory when it was backup up.
Thank you very much for your input.
>I don't know if there are other alternatives, but that's what I did. CReate the DB manually, and then restore the backup (that came from another server).
>
>You may also have to modify the file paths (DB & log) at the time of the restore to match the target server/database (assuming the datapaths are different on each server).
>
>Guy
>
>
>
>
>>If you want to restore a database that was backup up from another server (on another system) do you have to create a database of the same name first?
>>
>>I am trying to restore a database from a .bak file on a disk but I don't see a choice in my Restore Database window to specify where the backup resides?
>>
>>Any suggestions, please?
>>
>>Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham