Post reply

Backup database

  • October 9, 2012 at 9:59 am

    #265511

    We have a SQL server that hosts a vendor product.

    The vendor setup a backup for the database.

    I see in the SQL job it has a T-SQL

    BACKUP DATABASE [RenaissanceServer] TO [RenaissanceServer] WITH INIT , NOUNLOAD , NAME = N'RenaissanceServer backup', NOSKIP , STATS = 10, NOFORMAT

    What does this mean?

    I thought after the word TO it has to be device name, but this one is the database name, what this means?

    Thanks

  • October 9, 2012 at 10:15 am

    #1547279

    It is entirely possible that a backup device has been created with the same name as the database.

    Does that name appear within sys.backup_devices?

    Steve Hall
    Linkedin
    Blog Site

  • October 9, 2012 at 10:21 am

    #1547282

    Thanks,

    I got this:

    nametypetype_descphysical_name

    RenaissanceServer2DISKE:\MSSQL\DataRenaissanceServer.bak

    RenaissanceServer_LOG2DISKE:\MSSQL\DataRenaissanceServer_log.bak

    MASTER_MSDB2DISKE:\MSSQL\DataMASTER_MSDB.bak

    I noticed the vendor didn't put the device to our backup drive which is G:\Backup,

    How can I change the device to it?

    Thanks,

  • October 9, 2012 at 4:15 pm

    #1547393

    Maybe you should engage the vendor that set it all up to find out why they have set it up that way?

  • October 9, 2012 at 4:21 pm

    #1547396

    I found this is a logical backup device,

    We have to drop it first then recreate it with different path.

    Thanks

  • October 10, 2012 at 1:37 am

    #1547501

    sqlfriends (10/9/2012)

    Thanks,

    I got this:

    nametypetype_descphysical_name

    RenaissanceServer2DISKE:\MSSQL\DataRenaissanceServer.bak

    RenaissanceServer_LOG2DISKE:\MSSQL\DataRenaissanceServer_log.bak

    MASTER_MSDB2DISKE:\MSSQL\DataMASTER_MSDB.bak

    I noticed the vendor didn't put the device to our backup drive which is G:\Backup,

    How can I change the device to it?

    Thanks,

    Use sp_dropdevice to delete the current backup device and recreate it using sp_addumpdevice. Both are detailed in Books Online.

    Point out to the vendor that backing up to a dump device with INIT will be overwriting backup sets, do you really want to do this? What is your SLA for "getting the data back"?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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