asked on

On MS SQL 2005, I want to restore a backup file that was created from different server

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?
Thank you.

chapmandew

Yes...you could try to type in the exact UNC path to the file in the box:

\\servername\d$\filename.bak

OR...you could just type in the TSQL to restore it:

restore database yourdbname
from disk = 'UNCpathtofile'
with move
'logicaldatafilename' to 'C:\whereyouwanttostorethedatafile.mdf'
move
'logicallogfilename' to 'C:\whereyouwanttostorethelogfile.mdf', recovery

erin027

ASKER

I have located the file and added, but after I added the backup file, it took me to the first step and on the bottom of that section, I should see the file that I have added, but I do not see any list there.
What should I do?

chapmandew

Try to use the TSQL instead....

erin027

ASKER

Thank you.
I am new to SQL and I am not familiar with the TSQL.
What is 'UNCpathtofile' and 'logicallogfilename'?
Also, it seems like I need to have log file as well, but I only have .bak file that was create in different server.
Where do I get log files from?
Thanks

ASKER CERTIFIED SOLUTION

chapmandew

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial