This post is more than 5 years old
100 Posts
1
6109
Client initiated sql db backup with avamar
Hi,
I tried to initiate sql db backup on command line from client with avsql command but it was failing with below error.
C:\Program Files\avs\bin>avsql --brtype=full --hfsaddr=ave --id=MCUser --ap=MCUsr1 --label=testsql --logfile=C:\sqlbackuplogs --ntauthentication
avsql Info <5241>: Logging to C:\sqlbackuplogs
avsql Error <6967>: SQL plugin must be started with ctl interface specification
avsql Info <6451>: avsql returning with exitcode 536870914
Is there any way to initiate sql db backup from client ?
Thanks.
Amol
207 Posts
0
August 8th, 2012 11:00
If you are using Avamar Client/Server 6.1 you can perform the SQL backup using CLI
Full backup
avsql --operation=backup --server=
--id= --ap=
--path= ( )/
Incremental backup
avsql --operation=backup --server=
--id= --ap=
--path= --brtype=incremental ( )/
Differential backup
avsql --operation=backup --server=
--id= --ap=
--path= --brtype=differential ( )/
Anonymous
5 Practitioner
5 Practitioner
•
274.2K Posts
0
March 28th, 2010 15:00
No, you cannot run avsql directly. Only avtar command can invoke it.
Run a manual SQL backup using the client GUI with the options you need and then check the logs for the correct avtar syntax, i.e.
2010-03-05 09:07:09 avtar Info <5551>: Command Line: avtar ...
rpervan
266 Posts
0
March 29th, 2010 02:00
Hi Can,
you can involve "avtar" from client side or "mccli" form Avamar server side ...
Avtar synapsis:
# avtar --create --id= --path= --label=<"LABEL_NAME">
MCCLI synapsis:
#mccli client backup-target --domain= --name= --plugin= --target=
regards,
Rej
Can2
100 Posts
0
March 29th, 2010 03:00
Thanks for your replies .I will try them. By the way ı can't see any option to backup sql db from client gui ? How can be initiated from client console ?
rpervan
266 Posts
0
March 29th, 2010 03:00
Hello Can,
> Thanks for your replies .I will try them.
you are welcome .
> By the way ı can't see any option to backup sql db from client gui ? How can be initiated from client console ?
As far as I know there is no GUI possibilities to perform client initiated backup on it, but using command line itself (avtar) from client side or (mccli) directely from utill node you can start a backup on it.
regards,
.R
Anonymous
5 Practitioner
5 Practitioner
•
274.2K Posts
0
March 29th, 2010 10:00
I meant to say run an on-demand backup using Avamar Administrator. Sorry about the confusion..
siya1
4 Posts
1
August 8th, 2012 08:00
Hi
Have you any of you used SQL 2012 and backup the secondary replica(copy only database ) using "AVSQL" if so can you send me the command and have you encounter any errors , please share your thoughts.
Thanks
SK
Can2
100 Posts
0
August 9th, 2012 04:00
Hi All,
Thanks for your helps..
siya1
4 Posts
0
August 9th, 2012 06:00
Hi,
I know "avsql" command work on primary replica for SQL2012 , same functionality work on secondary replica on SQL2012 with Client /Server 6.1 for read-only database ?
Has anyone tested it. ?
Thanks