Forum Discussion

rakesh_gupta's avatar
rakesh_gupta
Level 4
13 years ago

Backup Exec backup of cluster SQL Server with Microsoft Cluster

Hi

My customer have two node cluster SQL Server (Microsoft cluster) and database present on the SAN volume  and want to take the SQL database backup throgh backup Exec on robotic libraries directly connected to the SAN swich.

Should i need to deploy Media server on each Cluster SQL server for taking the backup on the robotic libraries(2 drives) directly connected to SAN switch or I need to deploy only remote agent for SQL Server on agent on the SQL server.

Regards

Rakesh

2010
Agent for Microsoft SQL Server
Backing Up
Backup and Recovery
Backup Exec
Backup Exec (media server only)
Central Admin Server Option
Installing
Library Expansion Option
NDMP Option

3 Replies

Sort By
  • pkh's avatar
    pkh
    Moderator
    13 years ago

    If you want to backup directly to the tape library from each server, then you would need a full BE licence on each server and a SSO licence for each server to share the tape library.

  • newsolutionBE's avatar
    newsolutionBE
    Level 6
    13 years ago

    Hi

    1 Please install remote agent on both the cluster node for SQL

    2 Then from backupexec access the cluster node & then select the SQL database to backup to tape library

     

    Ensure your backup exec account should have sys admin, server admin & db creator right you can ensure that by going to SQL studio & connect to the instance & then go to Security & then click on login & then add the backupexec user account if it is not there & then go to server roles to add these rights

    Should work fine

     

    Thanks