Microsoft sql server error 3201

Posted on 2009-04-15
Last Modified: 2012-05-06
I am now having serious problems restoring a database using SQL Server Management Studio 2008.  

Cannot open backup device 'C:\SQL downloads\UKCTOCS_PsyTOCS_db_200809100115.BAK'. Operating system error 5(error not found).
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201)

Can anyone help please?

Question by:emeraldpiggy
    LVL 12

    Accepted Solution

    it looks like your login does not have permissions for the folder of the backup
    try the follwoing steps
    1. open up SQL Server Configuration Manager (I am using SQL Server 2005)
    2.right click on SQL Sever Express (I assume it is the same for the full version of SQL Server)
    3.Choose Properties
    4. in the Logon tab - click the built in account radio button and choose 'Local system' from the drop down.
    change the folder permissions to allow the SQL login user to access.
    move the file to different location


    Author Closing Comment

    thanks it works

    Expert Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now