October 3, 2003 at 5:55 am
I'm trying to recreate a database from a backup file on the main server to my local copy of sql server (evaluation edition). Now, I've done this before, but on a different machine, but when I tried to restore on my new machine (added dump device with network path, then executed 'restore database <db> from <device> with recovery') it failed, the error log showing OS error 5 (access denied). Now, I've checked the NTFS permissions on both the path and the .bak file, and they give full control to everyone. Also, I've connected to the network path in explorer prior to attempting the restore.
Can anyone please tell me what's going wrong, it's doing my head in.
October 3, 2003 at 7:12 am
Have you tried all of this using the account that SQL Server starts up as?
Also, if SQL Server starts up as the LocalSystem account, it will have no network access.
October 3, 2003 at 7:29 am
quote:
Now, I've done this before, but on a different machine
Did the 'different machine' have the evaluation copy also? Or was it a licensed copy?
-SQLBill
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply