I recently had long email conversation with one of the blog reader who was struggling with installing SQL Server 2012 RC0 installation. I just thought I will publish what we have done and how we solved problem so if you are facing the same issue, you can avoid the same. In this blog post we will see how to fix setup error.
Though our conversation was very long – I have kept only relevant conversation here.
User: While installing the SQL Server 2012 RC0 the error which is displayed is: File format is not valid.
Pinal: Download the iso format idea again.
User: Downloaded the iso media and extracted it again into C Drive and attempted the installation – still the same error.
Pinal: What is the tool you are using to extract the file?
User: (Some tool)
Pinal: Use alternate iso extractor tool or winrar to extract file.
User: It worked!
The original media was all fine. However, when user was using a software which extract the files from ISO to folder, it was corrupting few files. Well, if you face this issue remember to attempt new software to extract your file. If that does not work, try one more time to download the file.
You can also read my another blog post on the same subject over here.
Reference: Pinal Dave (https://blog.sqlauthority.com)
6 Comments. Leave new
I normally use the freeware – SlySoft Virtual Clone Drive – to “mount” the ISO image and use it as a virtual CD/DVD drive.
Quite frankly, while Microsoft ships quite a large amount of it’s products via ISOs, it does not natively provide the ability to mount the ISO file. I found a Connect post that is marked as “Won’t Fix” –
For XP users, the solution in the form of a Virtual CD Control Panel –
However, please note that Vista and Windows 7 users will need the compatibility mode ON to use the Virtual CD control panel – where 3rd party products win without a doubt.
“ Msg 7630 syntax error near ‘photos’ in the full text search condition ’Celebrity Photos’
• But in case of the following codes I was not get the exact results. If I comment the second (2nd) line I get the exact results. But in case of function if I not using the second(2nd) line this will shows an error “ Msg 7630 syntax error near ‘photos’ in the full text search condition ’Celebrity Photos’
Declare @txtKeyword varchar (500) =’Celebrity Photos’
Set @txtKeyword = replace (@txtKeyword, ‘ ‘,’ near ‘)
Select (len (ColumnName) – len (replace (ColumnName, @txtKeyword,’’)))/len (@txtKeyword)
As Body_Count from TableName
So please help me what can I do to get rid of that situation. It really needs your help.
Hi Pinal…need some assistance regarding moving file groups…the requirement is as follows
————————————-
– Move all non-clustered indexes to INDEX01 file group
– Move all user (U) type tables and clustered indexes to DATA01 file group
————————-
I need to perform teh above in 3 databases,and in each database we have 4 schemas,and in each database we have more than 100+ tables,can you please provied me some scripts if you have to move the tables all at a time or do we have any alternative to do this…
Thanks in advance
–Jana
I don’t think the problem is with the extractor tool, I download the .ISO, burn it to DVD using native tool in windows 7.
After the burn finish, I can install the SQL server 2012 in windows 7 without problem, but when I tried to install it in windows 2008 R2 server, it gave me the ”File Format is not valid” message.
I think if the tool corrupt some files, the error message will also appear in windows 7, but it is not.
It worked for me also! I was presenting the ISO directly by Hyper-V as E: \ in my VM and had the error. I used the PowerISO and extractted the ISO files. After this, I installed and ran without any problems.
It works…simply.
Thanks.