InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 13:43:17 GMT20http://www.sqlservercentral.com/Forums/Topic771702-24-1.aspx[quote][b]Steve Jones - Editor (8/17/2009)[/b][hr]Restore doesn't run under a user ID. It runs under the service account. That account might not have rights to that path.[/quote]I have to agree with Steve, this is a permissions issue.Check to be sure the service account has access to source share for the backup file.Mon, 17 Aug 2009 15:46:34 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic771702-24-1.aspxRestore doesn't run under a user ID. It runs under the service account. That account might not have rights to that path.Mon, 17 Aug 2009 15:12:52 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic771702-24-1.aspxThe problem is with the backup set, either it is not available or your ID is not authorized to use that.In place you can copy the backup to a local drive and then try to restore it.Mon, 17 Aug 2009 03:40:00 GMTSarab_SQLGeekhttp://www.sqlservercentral.com/Forums/Topic771702-24-1.aspxHi,I stopped the user who is accessing the database and now i am getting the following messageServer: Msg 3201, Level 16, State 2, Line 1Cannot open backup device '\\xyz\Databackups\ddd.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.Sun, 16 Aug 2009 23:28:15 GMTDURGESH-769360http://www.sqlservercentral.com/Forums/Topic771702-24-1.aspxBased on the error message, I'd say you have a user accessing the database. You may want to run an SP_WHO2 and see who is using the database.Sun, 16 Aug 2009 23:17:48 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic771702-24-1.aspxHi all,I am getting following message when trying to restore a newly created database with existed backup file file. I am getting the follow in messagesRESTORE DATABASE TestDB FROM DISK = '\\xyz\Databackups\ddd.BAK' WITH MOVE 'ddd_Data' TO 'E:\Microsoft SQL Server\MSSQL\data\TestDB_Data.MDF', MOVE 'ddd_Log' TO 'E:\Microsoft SQL Server\MSSQL\data\TestDB_Log.LDF'GOServer: Msg 3101, Level 16, State 2, Line 1Exclusive access could not be obtained because the database is in use.Server: Msg 3013, Level 16, State 1, Line 1RESTORE DATABASE is terminating abnormally.Thanks in AdvanceRegardsDurgeshSun, 16 Aug 2009 23:03:45 GMTDURGESH-769360