December 13, 2010 at 2:40 am
Hi,
I'm running SQL Server 2005 EE on Windows 2003 EE and I am trying to restore the [master] database using the following syntax at the command prompt:
net stop MSSQL$A
net start MSSQL$A /m
SQLCMD -E -d Master -S SERVERNAME\A -Q"restore database [master] from tape = 'L:\master.bak' with replace"
And this is the output I get ......
The SQL Server (A) service is stopping.
The SQL Server (A) service was stopped successfully.
The SQL Server (A) service is starting.
The SQL Server (A) service was started successfully.
Msg 3230, Level 16, State 1, Server SERVERNAME\A, Line 1
Operation on device 'L:\master.bak' exceeded retry count.
Msg 3013, Level 16, State 1, Server SERVERNAME\A, Line 1
RESTORE DATABASE is terminating abnormally.
Any help would be greatly appreciated.
Thanks.
www.sqlAssociates.co.uk
December 13, 2010 at 2:58 am
Check the path
December 13, 2010 at 3:00 am
The path is correct.
www.sqlAssociates.co.uk
December 13, 2010 at 3:36 am
Try replacing "tape" with "disk":
"restore database [master] from DISK = 'L:\master.bak' with replace"
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply