How do you open a .FULL file in MS SQL Server?

Posted on 2011-04-25
Last Modified: 2012-08-13
I have a backup copy of my MS SQL Server databases and the file is a .full format.  How do I open this file in MS SQL Server?  Do I need to convert this?  How can I restore this file to my MS SQL Server?

Question by:TigerBlood
    LVL 9

    Expert Comment

    Backup up should have extenstion .bak.

    I dont believe its FULL (I heard of some times back, some log file had this .FULL extension). Else your file was renamed by someone.
    LVL 32

    Expert Comment


    If its an actual backup file, just restore it.

    From SSMS
    Right click on databases
    Select Restore Database
    select that file

    Author Comment

    @radceasar: local backup files on the SQL server are .bak.

    I should have been more clear in my description  We are running eVault offsite backups on this sql server and have the eVault SQL agent installed. When I run the restore it produces a .full file. I can definitely confirm that nobody renamed this file.  

    Is SQL server compatible with this type of file and can it be restored in this state?
    LVL 10

    Expert Comment

    just rename the .FULL   file with .bak and it can be sucessfully restored
    LVL 21

    Expert Comment

    by:Alpesh Patel
    This is not a valid format (It should be .bak)
    LVL 142

    Accepted Solution

    note: the file extension does not matter for the backup file to be valid or not (just to make sure there is no misunderstanding).
    there is strictly no need to rename the file to be able to restore it !

    did you try to restore the file using the GUI and/or T-SQL ?
    if yes, what errors did you run into?

    Author Comment

    @sqlsrvr - I renamed this file to .bak and tried to open it but was not successful and it was not readable.  I was able to open thwe file in notepad but the file content was not legible.  I did not get any error as such when opening the file.  this was all through the MS SQL Server GUI.
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    as noted above: you cannot "open" the file, as it seems to be a backup file.

    run this SQL to see if it's really a valid backup file:

    Open in new window

    if that shows some backup/restore information: it IS a valid backup file.
    if that command returns an error, well, then it's not a valid backup file.

    Author Comment

    @ Angellll - I went through the restore pocedure in the GUI and was able to quiry the DB.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
    After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    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

    21 Experts available now in Live!

    Get 1:1 Help Now