do you know of a particular software program that you could recommend or have experience with if so please share =]

Thanks

The issue was that the named instance needs to be on a separate port and then you are able to connect. example below

bash-3.2$ sqlcmd -S tcp:wcosdbm2,1400 -d scom_support -E...

What OS are you using and is it Enterprise or Standard edition you are asking about. If you the OS is enterprise and the SQL as Standard edition then...

UPDATE :

The database has been removed FINALLY!!!!... that is the good... the bad is i think it was just time that fixed it =[ The reason...

Hello,

Do you have any chance of getting backed up information that is going to be the best bet but it sounds like that is a long shot. Have you...

The state has not changed after all these tries and 24+ hrs later...(In Recovery/Read-Only).

Thanks for asking and your time

-D-

Winlet...your idea is excellent... i have already tried to do the Tlogs recover and all and no luck as the database is in use and the logs are not found...

And i also appreciate the help you have offered as well...This is just one of those "freek" situations that even when i tried to recreate it all things worked and...

Rebooted the environment so that both machines would have MSSQL released at the same time ..and of course its still there.. =[ I am truely at a loss and...

Yes i have and when i do i reboot both of the server and can do it now if you like..its in a cluster... yea let me add that in...

SAN Storage.... but like i said..remember i redid the EXACT same thing and all of it worked well and the second database is up and functional with NO changes made....

Here is part of the logs.. hope i give you a part that you are able to understand and tie in with the conversation..If not my apologies

Starting up...

Recreated it with the script that would have ran. Hope this helps

RESTORE DATABASE [WCC_1] FROM DISK = N'F:\Frontier_1_data\WSS_C_F_1' WITH FILE = 1,

MOVE N'WSS_C_F_1' TO N'F:\Frontier_1_data\WCC.mdf',...

Well hmmmmmm not sure i know how to show you what i was doing because i used SSMS to do the database restore and with this all being done...

So any thoughts on this solution..its a bad one i know already but it may be all i have...

1. Shut down mssql server

2. Delete all corresponding mdf /ldf files

3. Start...