Re: Renaming DB

I may be wrong, but I think you'll have to detach/rename/attach to change
the o/s filenames. According to BOL, you can only rename o/s files for
tempdb and then it only takes effect after a restart.

ALTER Database

FILENAME
Specifies an operating system file name. When used with MODIFY FILE,
FILENAME can be specified only for files in the tempdb database. The new
tempdb file name takes effect only after SQL Server is stopped and
restarted.

'os_file_name'
Is the path and file name used by the operating system for the file. The
file must reside in the server in which SQL Server is installed. Data and
log files should not be placed on compressed file systems.
If the file is on a raw partition, os_file_name must specify only the drive
letter of an existing raw partition. Only one file can be placed on each raw
partition. Files on raw partitions do not autogrow; therefore, the MAXSIZE
and FILEGROWTH parameters are not needed when os_file_name specifies a raw
partition.



--

Kevin3NF
SQL Server dude

You want fries with that?
http://kevin3nf.blogspot.com/

I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.

Twitter: Kevin3NF

"Eric" <eric@xxxxxxxx> wrote in message
news:Oopntg4wJHA.5584@xxxxxxxxxxxxxxxxxxxxxxx
Hello,

I am running SQL 2000 and I just renamed one of my DB using:
alter database <OLD_DB> modify name= <NEW_DB>

The name of the DB did change when I look into the SQL server manager but
the name of the data file and the transaction log on the HD are still the
same (old name).

Is there a way to rename those files too?

Thank you.


Eric



.

Relevant Pages

  • Re: Renaming DB
    ... As Kevin mentioned, you must detach the database, move the file, then reattach. ... you can only rename o/s files for tempdb and then it only takes effect after a restart. ... The new tempdb file name takes effect only after SQL Server is stopped and restarted. ... If the file is on a raw partition, os_file_name must specify only the drive letter of an existing raw partition. ...
    (microsoft.public.sqlserver.setup)
  • Re: Renaming DB
    ... file must reside in the server in which SQL Server is installed. ... log files should not be placed on compressed file systems. ... If the file is on a raw partition, ... Is there a way to rename those files too? ...
    (microsoft.public.sqlserver.setup)
  • Re: Renaming DB
    ... Specifies an operating system file name. ... FILENAME can be specified only for files in the tempdb database. ... file must reside in the server in which SQL Server is installed. ... If the file is on a raw partition, ...
    (microsoft.public.sqlserver.setup)
  • Re: Renaming DB
    ... which you can change using Alter Database and ... SQL Server dude ... If the file is on a raw partition, ... Is there a way to rename those files too? ...
    (microsoft.public.sqlserver.setup)
  • Re: Renaming DB
    ... SQL Server dude ... you can only rename o/s ... Specifies an operating system file name. ... If the file is on a raw partition, ...
    (microsoft.public.sqlserver.setup)
Loading