restore a db from different server

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 2005 Forums

SQL Server Administration (2005)

restore a db from different server

Author

Topic

jung1975
Aged Yak Warrior

503 Posts

Posted - 2009-01-29 : 15:02:24

I am trying to restore a db using a backup where is located in differetn network server \\server1\D$\SQLBackup\Db1_012609.bak

I am trying to use a below script but keep getting an error saying 'can not open this file,, wrong path'.. but the path is correct.. it 's in D:\SQLBackup in SERVER 1 .. what am i doing wrong here?

RESTORE DATABASE Db1

FROM DISK = N'\\server1\D$\SQLBackup\Db1_012609.bak' WITH FILE = 1,

MOVE N'Db1' TO N'E:\mssql\MSSQL.1\MSSQL\Data\Db1.mdf',

MOVE N'Db1_log' TO N'E:\mssql\MSSQL.1\MSSQL\Data\Db1_log.ldf', NOUNLOAD, REPLACE, STATS = 10

GO

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-29 : 15:05:03

Can you open UNC path from RUN?
\\server1\D$\SQLBackup