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]
>

---

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...
> 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 TJ
>
>
>
>|||Thanks so much Hari. Have a good one!
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:ueHdzbY2DHA.2604@.TK2MSFTNGP09.phx.gbl...
> 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...
> > 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 TJ
> >
> >
> >
> >
> >
> >
> >
>|||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...
> Thanks so much Hari. Have a good one!
> "Hari" <hari_prasad_k@.hotmail.com> wrote in message
> news:ueHdzbY2DHA.2604@.TK2MSFTNGP09.phx.gbl...
> > 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...
> > > 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 TJ
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
>

Changing a db logical file name

Good day all,
Does anyone have any ideas on how I can change the Logical File Name from 'I
A_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 file on the General Tab whe
n viewing a database's properties in EM. We're running SQL 7.
--
Any and all contributions are greatly appreciated ...
Regards TJHi TJ,
Thank you for using MSDN Newsgroup! It's my pleasure to assist you with
your issue.
From your information, you are running SQL 7 and want to change the logical
file name of a database, right?
Based on my experience, it is possible to change the physical file name by
using sp_detach_db and sp_attatch_db. But for logical file name, there is
no way to change that now.
In SQL Server 2000, it could be possible, which is described in the
following article:
http://support.microsoft.com/?id=814576
Hope this helps! If you still have questions on this issue, please feel
free to post new message here and I am ready to help!
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Thanks so much Baisong. Have a good one!
"Baisong Wei[MSFT]" <v-baiwei@.online.microsoft.com> wrote in message
news:YR7WMSb2DHA.2900@.cpmsftngxa07.phx.gbl...

quote:

---

> Hi TJ,
> Thank you for using MSDN Newsgroup! It's my pleasure to assist you with
> your issue.
> From your information, you are running SQL 7 and want to change the

---

logical

quote:

---

> file name of a database, right?
> Based on my experience, it is possible to change the physical file name by
> using sp_detach_db and sp_attatch_db. But for logical file name, there is
> no way to change that now.
> In SQL Server 2000, it could be possible, which is described in the
> following article:
> http://support.microsoft.com/?id=814576
> Hope this helps! If you still have questions on this issue, please feel
> free to post new message here and I am ready to help!
> Best regards
> Baisong Wei
> Microsoft Online Support
> ----
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only. Thanks.
>
>

---

sql