April 8, 2009 at 11:19 am
This computer is not on a network, per se. It is connected directly to the IBOC processor, which takes the PAD (program associated data) and digital audio, from the importer (the computer in question) and converts the digital data for broadcast. The 2 units are networked together via cat5, and only talk with each other. There is no option or reason to connect either machine to the outside world durring normal operation.
I think it would be the wiser decision just to blow everything off the drive and start again. BE states that they will provide the necessary disk to reload all the Ibiquity software, which I presume also includes SQL Server. There just dosen't seem to be any easy solution.
April 8, 2009 at 11:26 am
If that is the only option, that may be what you need to do. As it is using SQL Server, you may want to verify with them that they ensure that the databases are setup using simple recovery model. This would prevent the log file from filling up the disk.
April 8, 2009 at 1:29 pm
Lynn Pettis (4/8/2009)
It may be possible to download and install the SQL Server Express management tools (Gail, am I right here) and use those from a remote PC to make "corrections" to SQL Server if we (you) can successfully connect to SQL Server on the server.
Yup. That's absolutely an option. Management studio can connect to 2000 servers. The other way were going to do this is by using osql, the SQL command line interface. It won't be fun, it won't be easy, it will work.
I have a feeling this isn't full-blown SQL Server, but rather is MSDE (Microsoft Database Engine). It would explain the complete lack of management tools as MSDE is just a limited database engine with no tools whatsoever.
Brian: It's your call whether you want to get the machine wiped and reloaded or to try and go through and fix. Walking you through fixing it will not be quick, especially since we're all posting in our free time.
If time is an issue in getting this working, you may want to go with your vendor's suggestion.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply