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

Posted on 2011-04-25
Medium Priority
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

Expert Comment

ID: 35462845
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

by:Ephraim Wangoya
ID: 35463474

If its an actual backup file, just restore it.

Right click on databases
Select Restore Database
select that file

Author Comment

ID: 35463612
@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?
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

LVL 10

Expert Comment

by:Ramesh Babu Vavilla
ID: 35464843
just rename the .FULL   file with .bak and it can be sucessfully restored
LVL 21

Expert Comment

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

Accepted Solution

Guy Hengel [angelIII / a3] earned 200 total points
ID: 35465970
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

ID: 35472806
@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 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 35473080
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

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

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

850 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