June 19, 2003 at 11:23 am
Consider the following statement:
--Running on server2 with a link to Server1
restore filelistonly from DISK = '\\Server1\DBBackup\MyBackup.BAK'
I get this error:
Cannot open backup device '\\Server1\DBBackup\MyBackup.BAK'. Device error or device off-line. See the SQL Server error log for more details.
The drive isn't down. I can run linked queries from Server1 to Server2. I can see the specific backup on Server2. This has worked in the past. We had to reboot Server2, could that cause it? Server2 is up now. Do I have to somehow refresh the linked server connection from Server1 to Server2?
Thanks
Darren
Darren
June 19, 2003 at 11:53 am
It is nothing to do with linked server. As long as your SQL Server service account in server2 is able to read files in share in server1, you should be able to run that statement.
June 19, 2003 at 11:56 am
We figured it out. Somehow the share had been removed on the folder where the backup was restored. Nobody knows how this happened. Has anybody seen something like this before?
Darren
Darren
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply