You just use UNC path as follows:

BACKUP DATABASE Northwind TO DISK = '\\remote_server\remote_dir\Northwind.BAK'

HTH

-Rajeev Lahoty

Well, truncate table is a non-logged operation in the sense that it doesn't log each and every row that is deleted but it does log data pages deallocation. When I...

You can query sysprocesses table to see whats going on the server. This script might help you to find out which process is taking the most CPU? Once you know...