I have a backup copy of a SQL200 database on a network drive. I am unable to restore it on a newly created SQL2005 database as I don't see any option to go to a network drive in the "LOCATE BACK UP FILE" screen, using the EM Studio Restore option in SQL2005.
After reading some posts here I tried the following using the Query Analyzer:
RESTORE DATABASE [MY DATABASE NAME(SQL 2005)]
FROM DISK = '\\SERVERNAME\SHARED FOLDER\MSS\DATA\db_200706040056.BAK'
WITH MOVE 'LOGICAL NAME OF NEW DB' TO 'LOCAL DRIVE:\MSSQL\Data\filename.mdf',
MOVE 'LOGICAL NAME OF NEW DB LOG' TO 'LOCAL DRIVE:\MSSQL\Data\filename_log.ldf',
I get the following error:
Msg 3201, Level 16, State 2, Line 3
Cannot open backup device '\\\\SERVERNAME\SHARED FOLDER\MSS\DATA\db_200706040056.BAK'.
Operating system error 5(Access is denied.).
Msg 3013, Level 16, State 1, Line 3
RESTORE DATABASE is terminating abnormally.
I do have access to the shared folder as I can read and write to it and am logged in to the local machine as the administrator with full privileges. I also copied a small txt file to the network location to make sure I can read and write to that location.
ANY HELP USING THE RESTORE COMMAND FOR SQL 2005 PLEASE!!