Solved

Logical and physical name

Posted on 2001-08-26
3
1,869 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
ID: 6427786
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]
ID: 6603610
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
ID: 6605243
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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

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.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
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.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

808 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