Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2008-06-13
5
Medium Priority
?
172 Views
Last Modified: 2010-03-19
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.
0
Comment
Question by:erin027
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 60

Expert Comment

by:chapmandew
ID: 21783088
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
0
 

Author Comment

by:erin027
ID: 21783156
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?
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 21783161
Try to use the TSQL instead....
0
 

Author Comment

by:erin027
ID: 21783295
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
0
 
LVL 60

Accepted Solution

by:
chapmandew earned 2000 total points
ID: 21783549
>>What is 'UNCpathtofile' and 'logicallogfilename'?
UNC path is the UNC path to the file...in the format of \\servername\driveletter$\filename.bak

logicallogfilename is the name that SQL server uses for the file.  To get this information, you need to use the RESTORE FILELISTONLY command....look it up in Google.

Also, the .bak file contains the data file and the log file....think of it as a big zipped file that contains all necessary information to get your db back up and running.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question