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 |
|
Sarat
Constraint Violating Yak Guru
265 Posts |
 Posted - 2003-07-15 : 14:44:34
|
| Hi, I was restoring a database on Dev box from a backup existing on Prod box. I have always done this and all of a sudden I get error.here is the script:--use masterRESTORE FILELISTONLY FROM DISK = '\\DTC_PSPRD\P$\Program Files\Microsoft SQL Server\MSSQL\BACKUP\NightlyBak\HR8PRD\HR8PRD_db_200301272100.BAK'--error:Server: Msg 3201, Level 16, State 2, Line 2Cannot open backup device '\\DTC_PSPRD\P$\Program Files\Microsoft SQL Server\MSSQL\BACKUP\NightlyBak\HR8PRD\HR8PRD_db_200307142100.BAK'. Device error or device off-line. See the SQL Server error log for more details.Server: Msg 3013, Level 16, State 1, Line 2RESTORE FILELIST is terminating abnormally.****so i did xp_cmdshell 'dir \\DTC_PSPRD\P$'=> I get access denied. I even tried by logging as an 'sa' into QA. My win id has 'sa' permissions though.My server admin says nothing changed. I can get to other test boxes though. I can also get to the same DTC_PSPRD directory via Cmd prompt using 'RUN' in explorer.I know it has to be permissions on the backup file. is there a way i check what my a/c permissions are on the backup file? Also is there any other reason this would happen?Thanks,Sarat.**To be intoxicated is to feel sophisticated, but not be able to say it.** |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-15 : 14:57:25
|
| From the server's perspective, is the path and file name valid? Not from your machine, but from the server's perspective. Also, is P$ a local drive on DTC_PSPRD? To check permissions on the backup file, navigate to it in Windows Explorer, then right click on it and go to properties, then go to the security tab. I don't think that it is a permission issue on the backup file though. I think it has to do with the path, hence the error message.Tara |
 |
|
|
Sarat
Constraint Violating Yak Guru
265 Posts |
Posted - 2003-07-15 : 15:04:49
|
| Hey we just found out that the Dev server was using an account to connect to Prod server which didn't have administrator privileges.Thanks.**To be intoxicated is to feel sophisticated, but not be able to say it.** |
|
|
|
|
|
|
|
|
Problem accessing backup file for restore