Re: A question about restore database

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Adrian Edwards (a.n.other_at_hotmail.com)
Date: 09/17/04 

Date: Fri, 17 Sep 2004 13:26:44 +0000 (UTC)

When you restore a backup file in Enterprise Manager it gives you the
option of path\folder\filename.

Adrian

jack.lee wrote:

> Hi
> I wanted to change the logical file name of the database when I restored
> a database from a file.But it raised an error.I want to know can I change
> logical file name.Any Answers will be appreciated!
>
> Thanks in advance!
> Jack
>
>

Relevant Pages

  • Re: 2nd Post: MSDN Subscriber - Sql Server 2005 Restore from tape fails ...
    ... I obviously don't understand the mechanics of restoring a database from tape ... Use RESTORE FILELISTONLY to list the logical file names. ... Ultrium2 tape drive. ...
    (microsoft.public.sqlserver.tools)
  • Re: 2nd Post: MSDN Subscriber - Sql Server 2005 Restore from tape fails ...
    ... After following Jeff's advice and executing a RESTORE FILELISTONLY I realized that the logical file names on the tapes did not have the .mdf / .ldf suffixes. ... I obviously don't understand the mechanics of restoring a database from tape as opposed to restoring from a set of .bak files on the hard drive. ...
    (microsoft.public.sqlserver.tools)
  • Re: 2nd Post: MSDN Subscriber - Sql Server 2005 Restore from tape fails ...
    ... Use RESTORE FILELISTONLY to list the logical file names. ... This message is telling you that you cannot MOVE the database with a logical file name 'sec_2008-11-08.mdf'. ... As the error message states - Use RESTORE FILELISTONLY to identify the actual logical file names for the database you are restoring. ...
    (microsoft.public.sqlserver.tools)
  • Re: 2nd Post: MSDN Subscriber - Sql Server 2005 Restore from tape fails ...
    ... executing a RESTORE FILELISTONLY I realized that the logical file names on ... the RESTORE worked great! ... MOVE N'sec_data_001' TO N'C:\Sql Server ... I obviously don't understand the mechanics of restoring a database from ...
    (microsoft.public.sqlserver.tools)
  • Re: 2nd Post: MSDN Subscriber - Sql Server 2005 Restore from tape fails ...
    ... You are using the physical file name instead of the logical file name in the "WITH MOVE clause. ... I obviously don't understand the mechanics of restoring a database from tape as opposed to restoring from a set of .bak files on the hard drive. ... Use RESTORE FILELISTONLY to list the logical file names. ...
    (microsoft.public.sqlserver.tools)