July 6, 2010 at 1:28 am
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
July 13, 2010 at 7:52 am
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
July 13, 2010 at 9:29 am
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).
July 14, 2010 at 11:07 am
Common reason for that error is because the SQL Server service startup account does not have rights to the remote share.
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply