Click here to Skip to main content
15,889,909 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
I have database backup file but extension is not being coming up while i have unchecked file extension from folder options but still unable to see what extension that file have?

In File System(Drive D:) , Type: File is coming up for that file.

Unable to attach and restore that file :(

Thanks in Advance
Posted

Probably, when you saved it yoU overrode thE extension and didn't give it any - so it is saved as
Filename
rather than
Filename.ext
Filename.bak
Filename.sql
Or similar.
Look at the file in Windows Explorer and open the "Organise" drop down.
Select "Folder and Search Options" and then the "View" tab.
Untick the "Hide extensions for known file types" check box and click "OK".
All the files will how show the full filename including any extension.
I think you will find you didn't give it any. Rename the file, and reverse the above when teh extension is set.
 
Share this answer
 
There were not assigned to permissions to sql current user.

I have solved :)
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900