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?


1 Answer 1


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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.