Solved

Logical and physical name

Posted on 2001-08-26
3
1,841 Views
Last Modified: 2006-11-17
Hi,
I have a question about restoring databasa. First I made a database dump for which database I want to backup. And then I will create a database to restore the database dump. I name the new database as different name with the previous database which I made the database dump, and it shouldn't be problem. But what make me confuse what's the difference between logical file name and physical file name for the data which I need to specify when I do restoration. For the logical name I must not change the name, if I do then SQL server will give me an error. Why I cannot change the logical file name for that database, and if like that it means that the logical name is always be the same as for each database we backup. Could somebody explain?

Thank you very much.
0
Comment
Question by:kayz
3 Comments
 
LVL 3

Accepted Solution

by:
krispols earned 50 total points
Comment Utility
The logical database name is store in the database file. Then when you restore it, sql check if the device have the same name than the target database. This it's to avoid that you accidently erase a wrong data base. If you want to restore a data base with an another name, you must restore your database with move option.
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
Hi kayz,
 please respect the EE guidelines and follow-up your questions. See this page for all your question:

http://www.experts-exchange.com/jsp/memberProfile.jsp?mbr=kayz&showQHistory=true

CHeers
0
 

Expert Comment

by:ComTech
Comment Utility
kayz, it is against the rules to have more that 3 questions open at a time, you have 12, and this could lead to suspension.

I will take care of the questions over 21 days old, which is also the rule of EE.

ComTech
Community Support Moderator

Ps. You are in SEVER violation of the rules of EE and permanent suspension has been requested.
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

772 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now