December 11, 2009 at 11:04 am
I have a SQL2005 server I needed a restore done on. I needed to check out the backup file I was going to use. I connected to it from another server, which has SQL2008 Std and SQL2005 Express installed on it. When I ran the following command from SSMS 2008:
Restore FileListonly from disk = 'G:\SQLBak\VITA_Vikings-FULL-20091209-184349.BAK'
I got:
Msg 3201, Level 16, State 2, Line 1
Cannot open backup device 'G:\SQLBak\VITA_Vikings-FULL-20091209-184349.BAK'. Device error or device off-line. See the SQL Server error log for more details.
Msg 3013, Level 16, State 1, Line 1
RESTORE FILELIST is terminating abnormally.
I did the usual checking of syntax and path permissions. I then ran the same command from the local console of the SQL2005 box, with success. Ii then ran the same command from the SQL2008 box, with the 2005 SSMS, and it works fine. It will not run from the 2008 SSMS app.
In spite of the error message, nothing is going into the SQL Error Log.
The same integrated security login is being used with all instances of SSMS described here.
Looking around the Internet has not found me anything on point yet.
Has anyone else run into this behavior?
Thanks,
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
December 11, 2009 at 11:50 am
May seem like overkill, but could you post the EXACT SQL code you are running?
December 11, 2009 at 12:00 pm
I did in the first post, Here it is again:
Restore FileListonly from disk = 'G:\SQLBak\VITA_Vikings-FULL-20091209-184349.BAK'
Really simple, standard command.
Version of destination SQL 2005 box:
Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
Version of SQL2008 tools install:
Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (X64) Jul 9 2008 14:17:44 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 <X64> (Build 3790: Service Pack 2)
Version of SQL2005 on same box as 2008:
Microsoft SQL Server 2005 - 9.00.3310.00 (Intel X86) Dec 19 2008 00:58:18 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Thanks,
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply