Post reply

Backup file logical Names

  • November 16, 2015 at 3:20 pm

    #306500

    Hi All,

    I have an issue where the logical name of the backup that gets uploaded every night was changed automatically. Hence my job uploading the file to database failed.

    Is there is any scenario where the logical name of the file can get updated automatically ? What could have caused this ? The name was export_1 earlier and suddenly , it got changed to export_2

    Thanks,

    Lee

  • November 17, 2015 at 5:27 am

    #1840283

    How are your backups being done? Is it a SQL Server maintenance job? Is it a third party tool? Is it a T-SQL job you created?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • November 17, 2015 at 8:15 am

    #1840352

    Hi ,

    Backup files are created by unzipping the file loaded on the server. This file gets uploaded by the filezilla process. we are using first Winscp to download file and then using 7-z to unzip the file. Once unzipping is done, it creates .bak file. This .bak is the loaded in the database using SSIS task where it failed. As the logical name of the database file was changed !

    Thanks,

    Sailee

  • November 17, 2015 at 8:17 am

    #1840354

    Sounds like someone at the source of the chain who provide you with the zip file of the database backup has changed the logical file names.

  • November 17, 2015 at 8:42 am

    #1840372

    As Anthony said, you need to talk to the person providing these backups to you.

    EDIT: To be clear, unzipping a file does not "create" a backup file. What's happening is 7-Zip is extracting the file to the designated folder. The file was named that way when it was zipped, so this happened on the other end of the chain and is not a part of anything you are doing.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • November 17, 2015 at 9:29 am

    #1840391

    Thanks alot Brandie and Anthony ! Would check with source team ..

    Thanks

    Lee

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

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