Rename Logical and Physical Database Filename in SQL server || Ms SQL
In this video I have explained the step by step process on how to rename logical database file name and physical database file name for a SQL server database in a very detailed manner.
Points covered in this video:
Logical Database filename?
Physical Database filename?
How to find these in SSMS (T-SQL query/GUI)?
How to Rename these Filenames and steps to be followed?
Why do we rename them ?
Why is it important to know these filenames ?
The logical filename is the name used to refer to the physical file in all Transact-SQL statements
The physical file name is the name of the actual file in the Windows operating system.
When we rename a Database, the database name changes but the Logical & Physical database file name remains same. This creates a confusion in identifying the corresponding database files for that database.
When we restore a database, the logical database file names don't change and are the same as the source database. So if you are restoring to multiple databases with the same backup file, the logical file names will be the same for all of the restored databases.
We should rename the database files to match the database name to avoid any confusion.
Watch video Rename Logical and Physical Database Filename in SQL server || Ms SQL online without registration, duration hours minute second in high quality. This video was added by user Right to Learn @BK 09 February 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 6,875 once and liked it 132 people.