Deleted SQL Resouce

i was deleting a disk resource from our cluster, the sql resource depended on that disk, when i was asked about deleting the dependent resources i clicked the delete option, so now i dont have any sql resourse. now i can′t see my SQL anymore even whe i
try to create a sql resource manually.
What can i do?
Thanks
I think you should
- copy the mdf and ldf file off to a safe location
- uninstall sql server from the cluster
- reinstall sql server to the cluster
- attach back the copied mdf and ldf files.
I don't think you can create the sql server resource without going through
the setup, but I could be wrong.
Vikram
"SQL Resource Deleted... Help!!!!" <SQL Resource Deleted...
Help!!!!@.discussions.microsoft.com> wrote in message
news:65D535D5-599A-4568-9E68-BFD2C496F73D@.microsoft.com...
> i was deleting a disk resource from our cluster, the sql resource depended
on that disk, when i was asked about deleting the dependent resources i
clicked the delete option, so now i dont have any sql resourse. now i cant
see my SQL anymore even whe i try to create a sql resource manually.
> What can i do?
> Thanks
>
|||Hi...
create SQL resource using below scripts.
It will create 3 sql resources and set proper private property values.
before you execute scripts, you should change what i comment
It will help you. and really works!!!
@.Echo OFF
Echo ************************************************** ****
Echo * *
Echo * Create "SQL Server" Resource *
Echo * *
Echo ************************************************** ****
@.Echo ON
cluster . Resource "SQL Server" /Create /Group:"SQLVS1 Group" /Type:"SQL
Server" <= Change group name
cluster . Resource "SQL Server" /AddDependency:"SQL Network Name(SQLVS1)" <=
Change network name
cluster . Resource "SQL Server" /AddDependency:"Physical Disk(Disk S" <=
Change Disk name
cluster . Resource "SQL Server"
/AddCheckpoints:"SOFTWARE\Microsoft\MSSQLSERVER\Rep lication"
cluster . Resource "SQL Server"
/AddCheckpoints:"SOFTWARE\Microsoft\MSSQLSERVER\SQL serverAgent"
cluster . Resource "SQL Server"
/AddCheckpoints:"SOFTWARE\Microsoft\MSSQLSERVER\Clu ster"
cluster . Resource "SQL Server"
/AddCheckpoints:"SOFTWARE\Microsoft\MSSQLSERVER\MSS QLSERVER"
cluster . Resource "SQL Server"
/AddCheckpoints:"SOFTWARE\Microsoft\MSSQLSERVER\PRO VIDERS"
cluster . Resource "SQL Server" /Priv VirtualServerName="SQLVS1" <= Change
SQL Server VS name
cluster . Resource "SQL Server" /Priv InstanceName="MSSQLSERVER"
cluster . Resource "SQL Server" /Priv RestartAction="2"
@.Echo OFF
Echo ************************************************** ****
Echo * *
Echo * Create "SQL Server Agent" Resource *
Echo * *
Echo ************************************************** ****
@.Echo ON
cluster . Resource "SQL Server Agent" /Create /Group:"SQLVS1 Group"
/Type:"SQL Server Agent" <= Change group name
cluster . Resource "SQL Server Agent" /AddDependency:"SQL Server"
cluster . Resource "SQL Server Agent" /Priv VirtualServerName="SQLVS1" <=
Change SQL Server VS name
cluster . Resource "SQL Server Agent" /Priv InstanceName="MSSQLSERVER"
cluster . Resource "SQL Server Agent" /Priv RestartAction="2"
@.Echo OFF
Echo ************************************************** ****
Echo * *
Echo * Create "SQL Server Fulltext" Resource *
Echo * *
Echo ************************************************** ****
@.Echo ON
cluster . Resource "SQL Server Fulltext" /Create /Group:"SQLVS1 Group"
/Type:"Microsoft Search Service Instance" <= Change group name
cluster . Resource "SQL Server Fulltext" /AddDependency:"SQL Server"
cluster . Resource "SQL Server Fulltext" /Priv ApplicationName="SQLServer"
cluster . Resource "SQL Server Fulltext" /Priv ApplicationPath="S:\Program
Files\Microsoft SQL Server\MSSQL\FTDATA" <= Change Drive and folder name
where SQL Database installs

Cheolwon Choi
Senior Consultant / Consulting Biz Unit / Feelanet Co., Ltd.
Microsoft MCSE/MCSA/MCT, HP MasterASE/ACI
"SQL Resource Deleted... Help!!!!" <SQL Resource Deleted...
Help!!!!@.discussions.microsoft.com> wrote in message
news:65D535D5-599A-4568-9E68-BFD2C496F73D@.microsoft.com...
> i was deleting a disk resource from our cluster, the sql resource depended
on that disk, when i was asked about deleting the dependent resources i
clicked the delete option, so now i dont have any sql resourse. now i
can′t see my SQL anymore even whe i try to create a sql resource manually.
> What can i do?
> Thanks
>