April 10, 2002 at 5:55 am
We are encoutering a problem, regarding backup of the database from a machine running SQL Server to a machine also running SQL Server instance.The system displays a std error msg as 'device is offline'
The command we used is(Backup database xx to disk = '\\mac1\temp\fin.bak')
Is this a limitation or something else is going wrong.
In both the cases the machine name and the instance name are the same.
TIA
April 10, 2002 at 7:21 am
No, that is valid syntax and it should work fine. Sounds to me like the machine you are trying to write to either doesn't like the permissions that SQL is executing the job with or is truly offline.
My suggestion, regardless of whether this works, would be to backup to the local machine and then copy the file to the other server using some standard batch processing either executed through SQL or external from SQL. You really don't want the backup to fail due to the other machines downtime. Make sense?
Hope this helps.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply