Forum Discussion

FZ2H's avatar
FZ2H
Level 6
13 years ago
Solved

BE2012 and SQL2012

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

2012
Backup and Recovery
Backup Exec
Troubleshooting
  • FZ2H's avatar
    FZ2H
    13 years ago

    Hello,

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

    http://www.symantec.com/business/support/index?page=content&id=TECH160370&actp=search&viewlocale=en_US&searchid=1344488849846

     

    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

  • AmolB's avatar
    AmolB
    Moderator
    13 years ago

    Is the remote agent service started on the SQL server?

     

  • AmolB's avatar
    AmolB
    Moderator
    13 years ago

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

  • FZ2H's avatar
    FZ2H
    Level 6
    13 years ago

    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?page=content&id=HOWTO74429

     

  • FZ2H's avatar
    FZ2H
    Level 6
    13 years ago

    Hello,

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

    http://www.symantec.com/business/support/index?page=content&id=TECH160370&actp=search&viewlocale=en_US&searchid=1344488849846

     

    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