SQL 9 upgrade Copy backup to network
kmregion7
Posts: 3 Bronze 1
in SQL Backup
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
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
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.
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
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