Video Screencast Help

BE2012 and SQL2012

Created: 07 Aug 2012 • Updated: 10 Aug 2012 | 8 comments
FZ2H's picture
This issue has been solved. See solution.

Hello,

i have a problem when i try to run backup job for the database server "Windows 2008 R2 and SQL 2012"

"DB.XXX.Local Backup 00019-Backup -- The job failed with the following error: Unable to attach to a resource.  Make sure that all selected resources exist and are online, and then try again.  If the server or resource no longer exists, remove it from the selection list. Edit the selection list properties, click the View Selection Details tab, and then remove the resource

Any requirement for SQL 2012 from the Backup Exec 2012

Comments 8 CommentsJump to latest comment

AmolB's picture

Is the remote agent service started on the SQL server?

FZ2H's picture

Yes ithe remore agent services is running

AmolB's picture

Are you taking backup of the entire server or only SQL DB?

FZ2H's picture

Full Server Backup

AmolB's picture

Refer to http://www.symantec.com/docs/TECH71780

FZ2H's picture

My problem releted backup not restore

FZ2H's picture

Hello,

How to configure the below

The following best practices help you with security and database access with the SQL Agent:

  • Ensure that the Windows user account that you use to back up the SQL instances has System Administrator privileges.

  • Ensure that Backup Exec has rights to the following registry keys:

    • HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server

    • HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQL

Do not apply the credentials that you use to make SQL backup and restore selections to an actual SQL instance. The credentials that you use to make SQL backup and restore selections must be applied to the Windows computer where SQL is installed. Apply the SQL credentials to the SQL server.

http://www.symantec.com/business/support/index?pag...

FZ2H's picture

Hello,

now i am able to start the backup by follow the documents below...

http://www.symantec.com/business/support/index?pag...

Note :

i made a user called BackupAdmin to be used it for Backup Exec Services my question how to use that user name as sql admin or i have to create a new user logon

SOLUTION