Post reply

When is the logical file name referenced?

  • July 27, 2007 at 4:31 am

    #63085

    I've read on BOL.

    "SQL Server 2000 files have two names:

    logical_file_name is a name used to refer to the file in all Transact-SQL

    statements.

    The logical file name must conform to the rules for SQL Server identifiers

    and must be unique to the database."

    When is the logical file name referenced?

    I've found only ALTER DATABASE.

    Thanks

  • July 27, 2007 at 4:48 am

    #722814

    Another case where you can use the logical filename is BACKUP/RESTORE of a databasefile.

    Markus

    [font="Verdana"]Markus Bohse[/font]

  • July 27, 2007 at 10:23 am

    #722959

    I believe only in the ALTER or RESTORE statements.

  • July 27, 2007 at 11:18 am

    #722979

    Don't forget BACKUP.

    BACKUP DATABASE MyNwind

       FILE = 'MyNwind_data_1',

       FILEGROUP = 'new_customers',

       FILE = 'MyNwind_data_2',

       FILEGROUP = 'first_qtr_sales'

       TO MyNwind_1

  • July 27, 2007 at 11:19 am

    #722980

    There is also DBCC

    DBCC SHRINKFILE (DataFil1, 7)

  • August 2, 2007 at 7:59 am

    #724169

    Thank's a lot guys!!!!!

     

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply