Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Friday, June 25, 2010 9:24 AM
Ive been asked to check a bunch of sql server 2005 instances to see if 'the binary files are in the correct place' and if not to rebuild them.
Can anyone tell me what these files are?
Thanks
Zoe
Friday, June 25, 2010 12:05 PM ✅Answered | 1 vote
The simplest thing to do would be to uninstall and re-install sqlserver. I have to admit that im very unclear as to the status of your servers. Are they running or not ?
Beware , ensure that your have backups of the DATA.
Hunt high and low for a Disaster Recovery document.
Dave Ballantyne http://sqlblogcasts.com/blogs/sqlandthelike/
Friday, June 25, 2010 1:43 PM ✅Answered | 1 vote
Just to add my two cents here. In a typical environment, you want software applications installated on a different drive than the OS. What you will typically see is the OS installed on C: and the sql server binaries installed on D: or E:. With that said, there are still components that are installed to the C:\ drive even if you specifiy another drive, but this aside from the point.
The question you need to ask your managers is..... Is changing the binary paths for SQL Server worth the effort required? If it is a dev environment, it should not matter unless you are strapped for storage on one drive and not another. Just make sure to put the binaries in the right place when it is time to go to production.
Friday, June 25, 2010 10:35 AM
Do you mean the data files (.mdf / .ldf) ? Or the binary executables ?
What is the "Correct Place" ?
Dave Ballantyne http://sqlblogcasts.com/blogs/sqlandthelike/
Friday, June 25, 2010 10:46 AM
Im pretty sure its not the data files theyre talking about.
It may be the 'binary executeables' ? Can you explain what these are please?
by 'correct place' they are reffering to location on disk. If I can find out what these SQL Binary Files are, I can locate them on other instances.
Thanks!
Friday, June 25, 2010 11:19 AM
My sqlserver.exe is located
C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn
Weather that is "Correct" for your organisation , i cant answer.
Also note that MSSQL10_50.MSSQLSERVER relates to 2008r2.
I think that your task is very poorly defined. Are you having issues ? How are you being expected to "rebuild" the executables ? , doubly so if you dont even know what an executable is.
Dave Ballantyne http://sqlblogcasts.com/blogs/sqlandthelike/
Friday, June 25, 2010 11:26 AM
lol! - is cause Im new at the organisation and everyone else is on holidays. The task came from Japan - (Im in Ireland) , so theyve all left work - its an 'emergency change' (dont ask me why)
Its the instance that I would have to rebuild, (not the executables)
Friday, June 25, 2010 11:45 AM
Apparently the files located in the BIN folder are the 'SQL Binaries'.
I need to rebuild the instance, but put the BIN folder on a different drive.
Any idea how to do this?
Friday, June 25, 2010 1:25 PM
I could do that, but then id be putting the binaries in the default location, which is the reason they want it re-installed.
The servers are running - (theyre just Dev, not production) and fairly new.
Dont worry about it, thanks for your help, ill just have to wait for someone in the states to get out of bed and ask them!!
Friday, June 25, 2010 1:58 PM
Hi Adam,
Can I ask what you understand by the term 'SQL Binary files' - Could it be the BINN folder in the installation directory?
Because on all our other servers that folder appears to be on the E drive, rather than the standard. Do you know what the purpose of this folder is?
As for the effort involved, we have about 1000 instances around the globe and there is some sort of data collection software that requires all instances to be a standard build.
As ever, appreciate the help
Friday, June 25, 2010 2:26 PM
I consider all the executables, files, and dlls that make a single SQL Server instance work binaries. These binary files are in fact found in the installation directory. http://jahaines.blogspot.com/