>>>>
>>>>
>>>>Start SSMS.
>>>>In Object Explorer, right click on Databases and select Restore Database.
>>>>IN "To Database" write the name of the database (new one).
>>>>
>>>>Other way.
>>>>Just create a DB with the same name before restore the backup file.
>>>
>>>I have another question, if I may. I get error on the SSMS Restore Database window:
>>>
>>>

>>>Restore Failed.
>>>System.Data.SqlClient.SqlError: Directory Lookup for the file "C:\Program Files\Microsoft SQL
>>> Server\MSSQL\Data\NameofDatabase.mdf" failed with the operating system error 3(The System cannot find the
>>>path specified)
>>>

>>>
>>>Note that I placed the NameofDatabase.bak file in another directory to which I am pointing in the field "Specify the source and location of backup sets .. From Device". And I see three backups in the grid below.
>>>
>>>What am I missing? Must I place the .bak file into the directory identified with the error above?
>>
>>
>>The path where you placed the BAK file didn't matter.
>>The path where you just created NameOfDatabase did :-).
>>If you choose second method, then you should rioght click on Database name And:
>>Tasks->Restore->Database.
>>And if you have more than one Backups in that BAK file you must choose the recent one. Just mark the one with recent datetime. Alsom you must go to the Options Node of treeview and check "Overwrite ...."
>
>I think I am doing everything that you suggest but still I get error. Let me ask you another question. On the Option Node, do I need to change anything in the choices Original File Name and Restore As. The Original File name shows the name that the author gave to the database. In the Restore As by default it shows the name of the database in my Program Files\Microsoft SQL Server\MSSQL\Data path. Do I need to change it? Or the Restore should just place the restored database in this .. DATA folder?


If you use SSMS on Vista comp. Start the SSMS as Administrator.
Nobody could write something in Program files if it is NOT an Administrator.