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:14 +0200

Hi,

We were not sure if it could cause any problems,
so we have chosen for the most secure option and asked for advice with some
experts. :-)

thanks again.

Kurt

"Uri Dimant" <urid@iscar.co.il> wrote in message
news:#yiwOW$kEHA.3340@TK2MSFTNGP14.phx.gbl...
> Kurt
> Why do want to change it? As far as I remember you will have to deal with
> sysfiles1 systemt table to update the name column.
>
>
>
>
> "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: Logical filename
    ... Kurt ... > file names, if you want to revise them for any purpose, SQL Server 2000 ... >> 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: Logical filename
    ... > When a make a backup of a database and restore it to a new database, ... > then i have to change the fysical filename, ... > the logical filename of the other database? ...
    (microsoft.public.sqlserver.programming)
  • 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)
  • Logical filename
    ... When a make a backup of a database and restore it to a new database, ... then i have to change the fysical filename, ... the logical filename of the other database? ...
    (microsoft.public.sqlserver.programming)
  • Re: Backend Exchange migrate to New Hardware (Server)
    ... Exchange mailbox stores and Exchange public folder stores. ... When you use Backup to restore Exchange databases, ... Storage Engine to restore Exchange database files and their ...
    (microsoft.public.exchange.setup)