Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Restoring backup to remote server. Expand / Collapse
Author
Message
Posted Tuesday, July 06, 2010 1:28 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, July 15, 2010 5:21 AM
Points: 15, Visits: 96
Hi,
I have problem with restoring DB backup to remote server. I can login to remote server using SQL Server Management Studio but cannot find the local file system to locate backup. I tried query using UNC path

RESTORE DATABASE [SCB] FROM
DISK = N'\\Mac\D:\Database BackUp\SCB_Full_29062010.bak' WITH FILE = 1, NOUNLOAD, STATS = 10

but it also failed with an error,

Cannot open backup device '\\Mac\D:\Database BackUp\SCB_Full_29062010.bak'. Operating system error 1265(The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you.).
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

Please assist me.
-Vicky
Post #947740
Posted Tuesday, July 13, 2010 7:52 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 1:43 PM
Points: 45, Visits: 291
Are the files on the remote server?
If so, have you tried to access the share folder/file via Windows Explore?
If the file is not on the remote server, then you need to set up a share on the main server so that you can access the file from the remote server.


Some-catchy-phrase-here...

Mark
Post #951452
Posted Tuesday, July 13, 2010 9:29 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 14, 2011 12:59 PM
Points: 73, Visits: 209
Check whether the shared folder is accessible from the server where u r doing restore operation. Also u can check the permissions on the shared folder for the windows user (for which the sql services are running).
Post #951585
Posted Wednesday, July 14, 2010 11:07 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, January 14, 2014 11:32 PM
Points: 343, Visits: 1,515
Common reason for that error is because the SQL Server service startup account does not have rights to the remote share.


Ray Mond

TLogInfo - the only FREE tool to analyse your transaction logs. Download here.
SQL BAK Reader - the only FREE tool to inspect your SQL Server backup files without using SQL Server. Download here.
Post #952535
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse