restor database error again

[sql]

HI all;
I got err on restore databas again
Server: Msg 3201, Level 16, State 2, Line 1
Cannot open backup device 'H:\backup\sequencesJun17.bak'. Device error or device off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE HEADERONLY is terminating abnormally.
what is wrong??
________
Subaru tecnica international

[Rawhide]

It can't access the H:\ drive.

[skhanal]

Or you have misspelt the backup file name.

[rmiao]

You should get detailed reason in sql server log.

[sql]

Hi
one of my log error is , what useful message we can found?
2005-07-30 19:49:16.79 server Copyright (C) 1988-2000 Microsoft Corporation.
2005-07-30 19:49:16.79 server All rights reserved.
2005-07-30 19:49:16.79 server Server Process ID is 880.
2005-07-30 19:49:16.79 server Logging SQL Server messages in file 'C:\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2005-07-30 19:49:16.89 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2005-07-30 19:49:17.17 server SQL Server configured for thread mode processing.
2005-07-30 19:49:17.18 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2005-07-30 19:49:17.20 server Attempting to initialize Distributed Transaction Coordinator.
2005-07-30 19:49:17.37 server Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b
2005-07-30 19:49:17.37 spid3 Starting up database 'master'.
2005-07-30 19:49:17.93 server Using 'SSNETLIB.DLL' version '8.0.194'.
2005-07-30 19:49:17.95 spid5 Starting up database 'model'.
2005-07-30 19:49:17.98 spid3 Server name is 'HONGLIN'.
2005-07-30 19:49:18.00 spid8 Starting up database 'msdb'.
2005-07-30 19:49:18.00 spid9 Starting up database 'pubs'.
2005-07-30 19:49:18.00 spid10 Starting up database 'Northwind'.
2005-07-30 19:49:18.00 spid11 Starting up database 'sequences'.
2005-07-30 19:49:18.01 server SQL server listening on Shared Memory, Named Pipes.
2005-07-30 19:49:18.04 server SQL Server is ready for client connections
2005-07-30 19:49:19.67 spid5 Clearing tempdb database.
2005-07-30 19:49:21.90 spid5 Starting up database 'tempdb'.
2005-07-30 19:49:21.93 spid3 Recovery complete.
2005-07-30 22:33:02.82 server SQL Server terminating because of system shutdown.
2005-07-30 22:33:02.88 server LogEvent: Failed to report the current event. Operating system error = 31(error not found).
2005-07-30 22:33:03.30 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.
________
BEST PORTABLE VAPORIZER

[skhanal]

There is nothing related to backup in the error log, try Windows application log.

To verify if SQL Server can access drive H:, run this in query analyzer

exec master..xp_cmdshell 'dir H:\'

Is drive H: a valid local drive in the server?. If it is a mapped drive SQL Servr can't see it you have to use UNC name, i.e. \\servername\backup\backup.bak

[rmiao]

Check other sql server log files for backup related messages.