Solved

backup sql server 2008 using backup exe 1,25

Posted on 2009-07-14
6
380 Views
Last Modified: 2013-12-01
I am trying to backup the sql server 2008 through Symantec backup exe 12,5 but can only do that when using domain admins under login in sql database. On the server domain admin is in the administrator group. When removing the domain admin group in the sql under logins it won´t work. I tried to put the service account that runs sql server as the account which will authenticate in backup exe but it won´t work, it will not give me right to the sql database. It must be some kind of account rights in the sql database that I am missing?
0
Comment
Question by:syssju
6 Comments
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 24989116
syssju,

As indicated, I have added zones above as ZA to hopefully attract experts in the area of Backup Exec and SQL Server 2008 to speak from that perspective as I have neither in my production environment currently.

Note, though, there is a db_backupoperator role that can be assigned to security logins for a database that will give the necessary rights for that user to backup data.

You can give that a try.

Regards,
Kevin
0
 
LVL 51

Accepted Solution

by:
Mark Wills earned 250 total points
ID: 25365378
Have you seen : http://www.experts-exchange.com/Software/System_Utilities/Q_24108652.html

basically you want to install BE SQLAgent for SQl Server : http://shop.symantecstore.com/store/symnasmb/en_US/DisplayProductDetailsSmbPage/productID.107515800/ThemeID.106400/pgm.13399900?resid=hV-F5goHAisAACmV69YAAAAl&rests=1253277988441

In essence the agent for backup exec must be a privileged account as far as SQL Server is concerned, and that does mean sufficient privilege to run as backupoperator as mwvisa1 mentions above.

Failing that, then most BE installs I have seen do use the admin group - and if it is working for you that way, not sure why that would be a problem for you - could you explain a little bit more please ?
0
 
LVL 23

Assisted Solution

by:Iamthecreator
Iamthecreator earned 250 total points
ID: 25446795
About using Backup Exec logon accounts for SQL resources
To back up SQL, use a Backup Exec logon account that stores the credentials of a Windows user account. The Windows user account must have been granted the System Administrator role on the SQL instance.
In the backup selections list or in the resource credentials list, apply that logon account to the Windows server that SQL is installed on, not to the actual SQL instance.
Figure: How logon account is applied
If you are using SQL Server Authentication, then add a Backup Exec logon account that stores the credentials of the SQL user account.
In the backup selections list, apply the Backup Exec logon account for the Windows user account to the Windows server that SQL is installed on, and then apply the logon account for the SQL user account to the SQL instance.
Figure: Applying SQL user account credentials
If you use a Backup Exec logon account that does not have the proper rights, you will receive an error message stating that the username and password are invalid.

About using Backup Exec logon accounts for SQL resources                            

                                                                          http://support.veritas.com/docs/300172
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
I have a large data set and a SSIS package. How can I load this file in multi threading?
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now