Link to home
Start Free TrialLog in
Avatar of TigerBlood
TigerBlood

asked on

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

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?

Thanks!
Avatar of radcaesar
radcaesar
Flag of India image

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.
Avatar of Ephraim Wangoya

If its an actual backup file, just restore it.

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

ASKER

@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?
just rename the .FULL   file with .bak and it can be sucessfully restored
This is not a valid format (It should be .bak)
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
@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.
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:
http://msdn.microsoft.com/en-us/library/ms173778.aspx
RESTORE FILELISTONLY FROM FILE='C:\yourfile.FULL' 

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.
@ Angellll - I went through the restore pocedure in the GUI and was able to quiry the DB.