Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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 6, 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: Thursday, November 19, 2015 8:49 PM
Points: 47, Visits: 354
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: Tuesday, July 21, 2015 9:18 AM
Points: 73, Visits: 220
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: Monday, July 11, 2016 9:55 AM
Points: 345, Visits: 1,539
Common reason for that error is because the SQL Server service startup account does not have rights to the remote share.


Ray Mond
Get a SQL Size 2.0 single-instance license for FREE
Claim one here!
Post #952535
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse