| http://www.w3.org/ns/prov#value | - i missed the part about restoring on the remote server.if you have a linked server, i know you can do EXECUTE AT;here is an example of creating a table on the remote server, you could change that to run the BACKUP command instead.EXEC sp_addlinkedserver 'SeattleSales', 'SQL Server'GOEXECUTE ( 'CREATE TABLE AdventureWorks2008R2.dbo.SalesTbl (SalesID int, SalesName varchar(10)) ; ' ) AT SeattleSales;
|
