Re: Logical filename

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Kurt Callebaut (Kurt.Callebaut_at_AucxisTrading.com)
Date: 09/06/04 

Date: Mon, 6 Sep 2004 12:18:24 +0200

Thanks.

Kurt

"Itzik Ben-Gan" <itzik@REMOVETHIS.SolidQualityLearning.com> wrote in message
news:ObsJ2k$kEHA.1904@TK2MSFTNGP09.phx.gbl...
> Not that you should have any issues/problems keeping the original logical
> file names, if you want to revise them for any purpose, SQL Server 2000
> supports this.
>
> Use the syntax:
>
> ALTER DATABASE <dbname>
> MODIFY FILE (NAME = logical_file_name, NEWNAME = new_logical_name)
>
> --
> BG, SQL Server MVP
> www.SolidQualityLearning.com
>
>
> "Kurt Callebaut" <Kurt.Callebaut@AucxisTrading.com> wrote in message
> news:%23D304D$kEHA.3520@TK2MSFTNGP11.phx.gbl...
> > Hi,
> >
> > When a make a backup of a database and restore it to a new database,
> > then i have to change the fysical filename, but cannot change the
logical
> > filename.
> > Otherwise i get an error when restoring.
> >
> > When restored, looking at the properties of the new database i still
show
> > the logical filename of the other database?
> > Is there a way to change this filename and if not, can it cause problems
> > on
> > the new database?
> >
> > Thanks.
> >
> > Kurt
> >
> >
>
>

Relevant Pages

  • Re: Use SQL to get Filename...
    ... That example builds a TSQL command from string constants plus ... SQL Server MVP ... > FILENAME = @dbFileName, ... >> Take a look at the sysfiles table, available in each database. ...
    (microsoft.public.sqlserver.server)
  • Re: Logical filename
    ... Kurt ... >> When a make a backup of a database and restore it to a new database, ... >> then i have to change the fysical filename, ...
    (microsoft.public.sqlserver.programming)
  • Re: Table index and file system index
    ... select * from openquery(file,'select doctitle, filename from web..scope() ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Logical filename
    ... BG, SQL Server MVP ... > When a make a backup of a database and restore it to a new database, ... > then i have to change the fysical filename, ...
    (microsoft.public.sqlserver.programming)
  • Re: List of all databases with their data & log files?
    ... > select name, filename from sysdatabases ... Tibor Karaszi, SQL Server MVP ... > This will give you a quick list of all the database on the SQL Server ...
    (microsoft.public.sqlserver.server)