Cari Blog Ini

19 Juli 2012

Msg 3201, Level 16, State 2, Line 1 - Cannot open backup device When Run RESTORE VERIFYONLY Statement

When run this query:
/*-----code:start-----*/
RESTORE VERIFYONLY FROM DISK = 'D:\DB_Simulasi_20120717.bak'
/*-----code:end-----*/


Error Messages:

Msg 3201, Level 16, State 2, Line 1Cannot open backup device 

'D:\DB_Simulasi_20120717.bak'.

Operating system error 2 (The system cannot find the file specified.).



Msg 3013, Level 16, State 1, Line 1 

VERIFY DATABASE is terminating abnormally.




Causes:
This means there no file “DB_Simulasi_20120717.bak” in drive “D:\”.

Solution:
* Cross check again about the availability file backup “DB_Simulasi_20120717.bak” in drive “D:\”.