Thursday, March 22, 2012

Changing a db's logical file name

Good day all,
Does anyone have any ideas on how I can change the Logical File Name from
'IA_Dev_Data' to 'BDOpp_Data' for a database? If the graphic isn't visible,
I'm referring to the logical name in the File Name field on the General Tab
when viewing a database's properties in EM. We're running SQL 7.
Any and all contributions are greatly appreciated ...
Regards TJHi,
In SQL 2000 you can use
Alter Database YourDB
Modify File
(Name = CurrentFileName,
Newname = NewFileName)
There is no supported proper way to do this on SQL Server 7
Thanks
Hari
MCDBA
"TJ" <nospam@.nowhere.com> wrote in message
news:ubyxRbW2DHA.2868@.TK2MSFTNGP09.phx.gbl...
quote:

> Good day all,
> Does anyone have any ideas on how I can change the Logical File Name from
> 'IA_Dev_Data' to 'BDOpp_Data' for a database? If the graphic isn't

visible,
quote:

> I'm referring to the logical name in the File Name field on the General

Tab
quote:

> when viewing a database's properties in EM. We're running SQL 7.
>
>
>
> --
> Any and all contributions are greatly appreciated ...
> Regards TJ
>
>
>
>
|||Thanks so much Hari. Have a good one!
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:ueHdzbY2DHA.2604@.TK2MSFTNGP09.phx.gbl...
quote:

> Hi,
> In SQL 2000 you can use
> Alter Database YourDB
> Modify File
> (Name = CurrentFileName,
> Newname = NewFileName)
> There is no supported proper way to do this on SQL Server 7
>
> Thanks
> Hari
> MCDBA
> "TJ" <nospam@.nowhere.com> wrote in message
> news:ubyxRbW2DHA.2868@.TK2MSFTNGP09.phx.gbl...
from[QUOTE]
> visible,
> Tab
>
|||Will this cause any problems by not changing the name? When is this name
used?
"TJ" <nospam@.nowhere.com> wrote in message
news:uLXLuQe2DHA.1744@.TK2MSFTNGP12.phx.gbl...
quote:

> Thanks so much Hari. Have a good one!
> "Hari" <hari_prasad_k@.hotmail.com> wrote in message
> news:ueHdzbY2DHA.2604@.TK2MSFTNGP09.phx.gbl...
> from
General[QUOTE]
>

No comments:

Post a Comment