Rights

  • SQL Server 2005 Express

    Windows XP SP2

    I was restoring a backup from a file. When the file explorer is launched, somehow I could not browse to the ..\Desktop\Backup directory where I had saved the backup.

    I also tried copying the file to the root folder, however an error message was displayed indicating that either the file was not found or that insufficient security privileges were available.

    I had to set rights to 'Everyone' so that SQL Server Mgmt studio was able to read the backups, although the user I was logged in (Adminstrator) had rights on the folder.

  • move the backupfolder to your c-drive to avoid this kind of hassle !

    So it will be able to use c:\backup\...

    Also keep in mind it has to be able to write the database files to an available location (for the sqlserver service).

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply