Click here to Skip to main content
14,332,463 members
Rate this:
Please Sign up or sign in to vote.
See more:
Hi,

I have one DB backup file.

file type : file
file extension : .file

I want to restore data from above mentioned file. How can I do it?

I only know restoring db from .bak file but how to do it from file where type = file.
Posted
Updated 24-Jun-19 0:05am
Rate this:
Please Sign up or sign in to vote.

Solution 1

To restore a backup from a device
After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.
Expand Databases, and, depending on the database, either select a user database or expand System Databases and select a system database.
Right-click the database, point to Tasks, and then click Restore.
Click the type of restore operation you want (Database, Files and Filegroups, or Transaction Log). This opens the corresponding restore dialog box.
On the General page, in the Restore source section, click From device.
Click the browse button for the From device text box, which opens the Specify Backup dialog box.
In the Backup media text box, select Backup Device, and click the Add button to open the Select Backup Device dialog box.[[here Chnage the Select File Type BakupFile("*.Bak*",".tm") to ALL(*) File ans Select The File]]
In the Backup device text box, select the device you want to use for the restore operation.
   
Comments
forccyy 9-Dec-14 4:59am
   
Thank u so much
/\jmot 9-Dec-14 5:02am
   
you are welcome. :)
Rate this:
Please Sign up or sign in to vote.

Solution 2

We can't tell - we have no idea what created the file in the first place.
Presumably, you created the backup - so you know what tool you used to create it. So use the matching tool!

The file type / extension isn't that relevant: the "file type" is a human readable description based on the file extension and the file extension can be changed at will. That doesn't change the content, and it doesn't make it readable by any particular piece of software. For example, I can change the extension of a jpeg file from "myPic.jpg" to "mypic.xlsx" but Excel will no be able to open it.
It's quite possible that it's a "normal" sql backup file, and it will restore in the usual way - but an extension of ".file" doesn't tell us anything. It's the content that matters.
   
Comments
forccyy 9-Dec-14 5:00am
   
Actually I have not created backup file. But thanks for info. It got resolved :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100