Friday, February 24, 2012

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:
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,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')|||Thank you. I will be working with this later today.

No comments:

Post a Comment