file with .file extension type to restore data in sql server.

Question

0.00/5 (No votes)

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 8-Dec-14 22:16pm

forccyy

Updated 24-Jun-19 0:05am

Add a Solution

2 solutions

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.

Posted 8-Dec-14 22:32pm

OriginalGriff

Comments

forccyy 9-Dec-14 5:00am

Actually I have not created backup file. But thanks for info. It got resolved :)

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

/\jmot · Accepted Answer · 2014-12-08T22:28:00

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.