Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 DB Backup

Author  Topic 

allenjones
Starting Member

3 Posts

Posted - 2014-12-08 : 09:42:29
Is it possible to run a a backup job on Server A from Server B e.g. Backup SERVER A\DB Name and run it from SERVER B

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-12-08 : 10:46:02
Yes, assuming appropriate permissions are set up
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-12-08 : 12:39:36
We perform our Availability Group backups from a central management server. The job step uses sqlcmd and references the AG listener name. We have no issues with this setup.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -