Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
purisqlserver
Yak Posting Veteran
73 Posts |
 Posted - 2003-04-04 : 05:43:15
|
| Tried out the restore command within the intranet. Trying to restore a database on machine using the db bak on other machine(Tech-4). Its showing errors.Restore database mycab from disk = '\\tech-4\c\mycab_db_200302160200.BAK' with replace,Move 'cab_bkp_Data' to 'D:\Program Files\Microsoft SQL Server\MSSQL\Data\mycab_data.mdf',Move 'cab_bkp_log' to 'D:\Program Files\Microsoft SQL Server\MSSQL\Data\mycab_log.ldf'Server: Msg 3201, Level 16, State 2, Line 1Cannot open backup device '\\tech-4\c\mycab_db_200302160200.BAK'. Device error or device off-line. See the SQL Server error log for more details.Server: Msg 3013, Level 16, State 1, Line 1RESTORE DATABASE is terminating abnormally. |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2003-04-04 : 09:54:42
|
| Is the SQL Server Service running under the local system account or an NT User account? It needs to be running under an NT account that has access to the share you are trying to access on the remote server. You can test to see if the share is available by running the following command in QA.exec master.dbo.xp_cmdshell 'dir \\tech-4\c\'If you get a Logon failure or some other permissions error then that's your problem. If you get a directory listing, then you may be having some network issues where the backup command is timing out.Jeff BanschbachConsultant, MCDBA |
 |
|
|
purisqlserver
Yak Posting Veteran
73 Posts |
Posted - 2003-04-05 : 01:58:37
|
| Thanx for the response.Changed the sql server service account to NT user account, it worked. |
|
|
|
|
|
|
db restore from othe mac