What are the challenges you face when working across database platforms? Take the survey
Options

SQL 9 upgrade Copy backup to network

kmregion7kmregion7 Posts: 3 New member
I upgraded from sql backup 7 to sql backup 9. Now when the backups run they are great on the current server, but the copy backup to network option does not work. I have tried running through the jobs and then recreate the jobs and still no backups copied to the network drive.
Tagged:

Comments

  • Options
    Eddie DEddie D Posts: 1,789 Rose Gold 5
    Hi

    Thank you for your forum post.

    The account you have given to the SQL Backup Agent service for V9, does it have security permissions to the network share you wish to copy to?

    You can check that the SQL backup Agent service has the correct security permissions by running this query on the SQL Instance:

    USE master
    GO
    EXECUTE master..sqbutility 999, 'RWE', '<network location>'
    GO

    --where '<network location>' = the unc path to your network share, for example '\\MyServer\MyBackupFolder\'

    If successful and the SQL Backup Agent service has Read Write and Execute permissions, the query will return:
    <SQBUTILITYRESULT>:1:

    If there is a problem, the query will return 0, followed by a message, for example:
    <SQBUTILITYRESULT>:0:Folder does not exist:
    <network location>

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • Options
    I have the same issue with 9.1.4.177.
    I ran the posted query which returned "<SQBUTILITYRESULT>:1:" .
    The SQL Agent backup job completes successfully. It also runs successfully from an SSMS Connection.
    However, the file is not copied to the network share.
  • Options
    Eddie DEddie D Posts: 1,789 Rose Gold 5
    Hi RayH

    I suspect that you maybe confusing the SQL Agent and the SQL Backup Agent, they are two different services.

    SQL Backup uses the SQL Agent to trigger a call to the SQL Backup extended stored procedure to perform the backup or restore job.

    The SQL Agent completing successfully normally indicates it was able to call the SQL Backup extended stored procedure to start the SQL Backup process.

    Using the SQL Backup GUI, is there an entry in the Activity History tab for the job? If yes, right click the entry and select 'show log'. Is there any message or entry that indicates as to why the copy to the network share has failed?

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • Options
    ClearViewClearView Posts: 12 Bronze 1
    Thanks Eddie. First, the issue seems to have resolved itself by magic.
    The backup process did complete, the backup was produced and the backup file had the proper name in the proper primary location. The Log indicated that the backup completed and that the file had been copied to the network share.
    However the secondary copy was not in place on the network share. I checked permissions, event logs, Red Gate logs, fiddled with settings etc. Magically, the file appeared the next morning.
    Phase of the Moon I guess :)
Sign In or Register to comment.