469,573 Members | 1,676 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,573 developers. It's quick & easy.

Logical Name

Hi,
I want to change the logical name of the database. My database name and
.MDF has the same name, but the logical name is different. Will
changing it impact anything?

--sharif
Jul 17 '07 #1
1 2437
Sharif Islam (mi****@spam.uiuc.edu) writes:
I want to change the logical name of the database. My database name and
.MDF has the same name, but the logical name is different. Will
changing it impact anything?
Very little. There are a few places where the logical name is used,
DBCC SHRINKFILE and RESTORE WITH MOVE are two that comes to mind. If
you happen to have any such scripts they would break.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jul 17 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Ryan | last post: by
reply views Thread by Roald | last post: by
3 posts views Thread by anchitgood | last post: by
1 post views Thread by Jose Barragan | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.