I've been trying to use an external USB harddrive to restore db's from but was having problems getting Enterprise Manager to see teh drive.
Turns out the problem is with permissions / security on the drive and the SQL Server Service logon account.
Backup and Restore is handled by the MSSQLServer service and therefore all permissions relate to the logon for this service. You need to ensure that the drive/mapping has permissions / security settings that enable this user to access it.
In my case it was just giving the users role full access (probably overkill) to the drive, then it appeared in the Restore list of drives.
No comments:
Post a Comment