Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Mar 07, 2012 06:18 AM by Chen Yu - MSFT
Member
375 Points
1033 Posts
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???
14 Points
10 Posts
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
All-Star
21584 Points
2493 Posts
Microsoft
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.
-_-
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???
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
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
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.
Feedback to us
Develop and promote your apps in Windows Store