Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2007
    Location
    California, USA
    Posts
    520

    Unanswered: Copied database maintains original name in backups

    I made a copy of a database "sac_prod" and named the new copy "vgs_prod". Now, when I do a backup of the new database, it still shows the name of the original. Is there any way to change this so it will be the same as the new database name?
    Here is the BACKUP script:
    Code:
    
    BACKUPdatabase vgs_prod TODISK=
    '\\sac-srvr1\data$\Technical\Shared\Production\SQLBackup\LasVegas\vgs_prod_CopyOnly.BAK' 
    with COPY_ONLY
    
    Here is the messages I received from this BACKUP:
    Processed 1752 pages for database 'vgs_prod', file 'sac_prod' on file 1.
    Processed 6 pages for database 'vgs_prod', file 'sac_prod_log' on file 1.
    BACKUP DATABASE successfully processed 1758 pages in 0.412 seconds (34.955 MB/sec).

    I would like to change the file 'sac_prod' to be 'vgs_prod' in lines 1 and 2 just above.

    Thanks,

  2. #2
    Join Date
    Feb 2003
    Location
    India
    Posts
    216
    it is the logical file name being displayed. it should not create any problem anywhere. still if u want to change

    alter database vgs_prod modify file (NAME = 'sac_prod' , NEWNAME = 'vgs_prod')

  3. #3
    Join Date
    Jan 2007
    Location
    California, USA
    Posts
    520
    Thank you. I will be working with this later today.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •