July 20, 2015 at 8:17 am
Hi,
I am using H/A SQL2014A.
I am looking for a way to backup my listener from my main server.
I have tried creating a linked server with readonly intent. But when I can't seem to get my syntax to work:
select * from openquery([SQLNODEB\SQL2014A],'BACKUP LOG [pec_prod] TO DISK = N''nul'' WITH NOFORMAT, INIT,
NAME = N''pec_prod-Full Database Backup'', SKIP, NOREWIND, NOUNLOAD, COMPRESSION, STATS = 10
')
The above gives the error:
Msg 7357, Level 16, State 2, Line 46
Cannot process the object "BACKUP LOG [pec_prod] TO DISK = N'nul' WITH NOFORMAT, INIT,
NAME = N'pec_prod-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, COMPRESSION, STATS = 10
". The OLE DB provider "SQLNCLI11" for linked server "SQLNODEB\SQL2014A" indicates that either the object has no columns or the current user does not have permissions on that object.
I am open to any suggestions on how to execute the backup log from the primary. I need to be able to execute the backup log from script. I tried it in an SSIS package but it gave me the "THe Database is currently in High Avail and inaccessible". So, I'm trying to get it to run as a job..but willing to change it to whatever works.
July 20, 2015 at 9:24 am
are you using Alwayson availability groups?
Are you attempting to backup the log on a secondary database?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 20, 2015 at 9:33 am
Perry Whittle (7/20/2015)
are you using Alwayson availability groups?Are you attempting to backup the log on a secondary database?
Yes and yes
I am looking for a way to backup the secondary log via a script, job, package.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply