Restoring database - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Restoring database

Author

Topic

kiran
Starting Member

30 Posts

Posted - 2003-05-14 : 18:01:31

Hi,

I am trying to restore a database from a remote machine mapped to a drive, when i issue the following command , i am getting an error saying device does not exist or offline

RESTORE DATABASE db1 FROM DISK 'm:\db1.bak' WITH RECOVERY

thanks in advance

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-05-14 : 18:09:38

The path to the file must be correct from the server's perspective not the client's. So go to the server and check if m:\db1.bak is correct. If it isn't, then fix that. If the file is local to the server, then just change m: to whatever drive it should be.

Tara

Edited by - tduggan on 05/14/2003 18:10:16

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-05-14 : 18:12:51

As an example of what I am saying above, I can run this on my machine through Query Analyzer (connected to SERVER1, pretend this server exists):

RESTORE DATABASE db1 FROM DISK= 'C:\MSSQL\Backup\db1.bak' WITH RECOVERY

I run it from my machine, but I don't have C:\MSSQL\Backup\db1.bak on my machine. The server has it.

Now let's say that db1.bak exists on my machine and not the server. Then if I go to the server and map a drive to my machine (say M: where I have the bak file), then I can run your command.

Tara

kiran
Starting Member

30 Posts

Posted - 2003-05-14 : 18:38:48

Thanks for your response.

The drive is mapped correctly. I was able to go to that drive through command prompt and verify the file exists. Some how sql server does not recognise it. Is there any other way i can do this ?

Thanks again

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-05-14 : 18:48:56

Where did you "go to that drive through command prompt" though? From your machine or from the server? It definitely makes a difference. You have to verify it from the server. Verifying it from your machine doesn't help unless your machine is also the server.

Tara

Edited by - tduggan on 05/14/2003 18:49:37

pmr
Starting Member

37 Posts

Posted - 2003-05-14 : 18:50:38

The file doesn't happen to reside on a Novell server does it?

I've run into something like this before where processes run within a scheduled job can see files on Microsoft Servers but not Novell Servers. The best work-around I found is to copy the file(s) to the server you want to perform the restore on first.

If you need to automate the process, you can run a batch file from the Windows Scheduler.

pmr
Starting Member

37 Posts

Posted - 2003-05-14 : 18:54:53

Just in case:
Tara is right. The restore will always be performed from the perspective of the server, so the best way to troubleshoot is to use the server itself to do the searching.

Peter

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-05-14 : 18:54:54

quote:

If you need to automate the process, you can run a batch file from the Windows Scheduler.

Or you could schedule it using the SQLServerAgent (will need to select the CmdExec type in your step) since you are already using SQL Server for this. You could also run the copy commands in xp_cmdshell if you want to do it in T-SQL.

But let's figure out the problem before we go too far.

Tara

pmr
Starting Member

37 Posts

Posted - 2003-05-14 : 19:02:26

Tara,

You are right again. It is better to use a SqlServerAgent job. It will always run more reliably except in the situation that I ran into and kiran hopefully isn't haveing to deal with because no operations run within the job were able to see the Novel server.

Peter

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-05-14 : 19:06:40

quote:

Tara,

You are right again.

Well that certainly can't be said often enough.

Tara

robvolk
Most Valuable Yak

15732 Posts

Posted - 2003-05-14 : 19:22:50

Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.
Tara, you are right again.

You SURE about that Tara?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-05-14 : 19:25:34

Tara

pmr
Starting Member

37 Posts

Posted - 2003-05-14 : 19:32:38

I'd say some of you are in the wrong profession, but I don't think the night club attendees would understand this kind of humor.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources