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!
Thanks!
If its an actual backup file, just restore it.
From SSMS
Right click on databases
Select Restore Database
select that file
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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@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
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.
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'
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.
ASKER
@ Angellll - I went through the restore pocedure in the GUI and was able to quiry the DB.
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.