Do we have to manually change the logical file name in the new database?
what is the use of logical name?
Please help!
The logical file will not change while u restore a db. you have to change it explicitly
alter database gpx mODIFY FILE (NAME=oldLogicalFilename,NEWNAME=NewLogicalFilename)
Madhu
|||
what is the use of logical name?
The name to represent the database data file. The logical name for each file is contained in the name column
The logical design of the database, including the tables and the relationships between them, is the core of an optimized relational database. A good logical database design can lay the foundation for optimal database and application performance. A poor logical database design can hinder the performance of the whole system.
No comments:
Post a Comment