I have a SQL Server 2012 installation that has some issues with SQL Server Agent because of which I cannot schedule a job or a maintenance plan to take backup.
What I am trying to do is to create a SQL Server job on SQL Server 2008 R2 and take backup of the SQL Server 2012 databases. Can someone suggest how to achieve this?
Best Answer
You should fix the SQL agent first.
as a temporary workaround, you can use SQLCMD and schedule it using windows scheduler for doing backups.
no need to spawn a job from different server and do the backup on another server.