SQL 2008 Express as Linked Server in order to perform scheduled backups

[Luvsql]

We have a local SQL Express 2008 instance on a server and SQL 2012 on another. I'd like to be able to simply add a backup of those databases on the remote Express Server to my existing database backup jobs (or even create another scripted backup job). I added the remote server using the sa account as the security account, but keep getting "Object reference not set to an intance of an object."

Does it have to be setup as a linked server in order to use teh SQL Agent of my 2012 server to backup the databases on the remote server?

 

[PghMikeH]

You're probably making this much harder than you need to.

Find a good backup script at sqlservercentral.com and schedule it using sqlcmd and a Windows scheduled task. That will be much simpler.

Mike Hillwig
mike@hypermike.com

http://www.hypermike.com

I've done more R5 deployments than I care to think about.