get db from another server to run retore db RSS

• • Reply
  

  -_-

  Member

  375 Points

  1033 Posts

  get db from another server to run retore db

  Mar 02, 2012 01:43 AM|LINK

  i would like to restore database but how could i get the database drum from other server

  restore filelistonly

  from disk='\\anotherservername\D$\databasedrump'

  restore database dbname

  from disk.....

   

  error : cannot open backup device , device error or device off-line???

• • Reply
  

  skywalkerwil...

  Member

  14 Points

  10 Posts

  Re: get db from another server to run retore db

  Mar 02, 2012 02:45 AM|LINK

  I believe you would have to copy the backup file to your local machine first and then restore from there.

  -Walker

• • Reply
  

  Chen Yu - MS...

  All-Star

  21584 Points

  2493 Posts

  Microsoft

  Re: get db from another server to run retore db

  Mar 07, 2012 06:18 AM|LINK

  -_-

  error : cannot open backup device , device error or device off-line???

  Hi,

  From your error message, I found this thread which is similar to yours. It may help you.

  Please check: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=43982 

  Did your account have sufficient permissions to access the network drive? If not, you will get this error.

  Please check below KB: http://support.microsoft.com/kb/207187

  Thanks.

  Please mark the replies as answers if they help or unmark if not.
  Feedback to us
  
  Develop and promote your apps in Windows Store
  
  
  • Marked as answer by Chen Yu - MSFT on Mar 12, 2012 10:20 AM