Backup on a Locally Connected Drive

[create_share]

Hi!

Is it possible to let the SQL Server Agent or BE Server take the backup on the Backup Drive that is locally connected to the SQL Server where the SQL Agent is installed and not on the backup drive or hard disk on BE Server itself?

Backup Exec 2010.

Thanks.
 

[RahulG]

Yes that is possible . SQl agent is used to backup SQl database and on the SQl server you dont install the SQL agent , you just install a backup exec remote agent. So you can backup all local drives on the SQl server .

[pkh]

You can do that if you create a shared directory on the SQL Server machine and backup to that directory.  However, note that  in this case the backup data will flow from the SQL machine to the media server and then back again to the SQL machine.  You cannot write directly to a disk in the SQL machine.

[Colin_Weaver]

To be honest if you just want to backup SQL to a local drive on the SQL server then you would use Microsoft's in built processes to export/dump to a disk based backup target (as a .BAK file) and you wouldn't involve Backup Exec at all.

However if you want to Backup using Backup Exec then PKH's answer is the only way to get the backup to save it on  a local disk in the SQL server. BE currently has to be a media server to write to a B2D device (unless you have a Linux system and can use RMAL anyway)

[create_share]

Thanks but i need to backup SQL Databases on a Tape Drive and not on a hard disk partition on SQL Server. The Tape Drive is connected to the SQL Server Machine.

Thanks.

[pkh]

BE can only use devices which are attached to the media server.  It cannot use a tape drive attached to your SQL Server machine if it is a remote server.

[create_share]

Ok Thanks.