Posted by Erland Sommarskog on 07/17/07 21:46

Sharif Islam (mislam@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, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Combining many records into 1
• Prev in forum: Re: problem with login list
• Thread view: Re: Logical Name

[Reply to this message]