Unanswered: how to backup database on linked server?
Do you know how to back up a database using a linked server? If the name of my linked server is "SERVER1", how would I change the following backup statement to backup the database running on SERVER1, FROM SERVER2?
BACKUP DATABASE database1 TO DISK = '\\192.168.0.90\backup\database1.bak'
To clarify, I want to run this statement from SERVER2, to backup the database on SERVER1.