How to Recover from: OS on drive C, SQL Server installation & mdf's on X, ldf's on Y

Our main sql server has failed, and our failover procedure has failed
as well (the backup server couldn't handle the temporary strain).
Our OS was installed on one drive (drive C)
Our SQL Server installation is on drive X, along with the MDF files for
the databases.
The LDF files are on drive Y.
Drive C is fried, drive X & Y are fine. We are recreating drive C's OS
installation, but how do we handle the actual server installation being
on drive X? Do we need to run the SQL Server installation over again?
If so, are there special considerations in this case?<ebeiler@.fandr.com> wrote in message
news:1141394015.039948.245470@.j33g2000cwa.googlegroups.com...
> Our main sql server has failed, and our failover procedure has failed
> as well (the backup server couldn't handle the temporary strain).
> Our OS was installed on one drive (drive C)
> Our SQL Server installation is on drive X, along with the MDF files for
> the databases.
> The LDF files are on drive Y.
>
> Drive C is fried, drive X & Y are fine. We are recreating drive C's OS
> installation, but how do we handle the actual server installation being
> on drive X? Do we need to run the SQL Server installation over again?
> If so, are there special considerations in this case?
>
You can install SQL Server normally. The program files will go on the new
drive C.
Then simply attach (or restore) your databases on drive X.
sp_attach_db
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ae-az_52oy.asp
How to move databases between computers that are running SQL Server
http://www.support.microsoft.com/?id=314546
David|||Thanks for your help.

How to Recover from: OS on drive C, SQL Server installation & mdf's on X, ldf's on Y

Our main sql server has failed, and our failover procedure has failed
as well (the backup server couldn't handle the temporary strain).
Our OS was installed on one drive (drive C)
Our SQL Server installation is on drive X, along with the MDF files for
the databases.
The LDF files are on drive Y.
Drive C is fried, drive X & Y are fine. We are recreating drive C's OS
installation, but how do we handle the actual server installation being
on drive X? Do we need to run the SQL Server installation over again?
If so, are there special considerations in this case?
<ebeiler@.fandr.com> wrote in message
news:1141394015.039948.245470@.j33g2000cwa.googlegr oups.com...
> Our main sql server has failed, and our failover procedure has failed
> as well (the backup server couldn't handle the temporary strain).
> Our OS was installed on one drive (drive C)
> Our SQL Server installation is on drive X, along with the MDF files for
> the databases.
> The LDF files are on drive Y.
>
> Drive C is fried, drive X & Y are fine. We are recreating drive C's OS
> installation, but how do we handle the actual server installation being
> on drive X? Do we need to run the SQL Server installation over again?
> If so, are there special considerations in this case?
>
You can install SQL Server normally. The program files will go on the new
drive C.
Then simply attach (or restore) your databases on drive X.
sp_attach_db
http://msdn.microsoft.com/library/de...ae-az_52oy.asp
How to move databases between computers that are running SQL Server
http://www.support.microsoft.com/?id=314546
David
|||Thanks for your help.

How to query children of a given node?

I'm new to SQLXML extenions and I'm curious if SQL Server
can handle what I need.
I need to store a tree data structure and I need to query
the children within a particular or multiple branches of
this tree. For example:
<Root>
<Branch Id=0,State=GA,Level=SpecialLevel/>
<Child Id=1,State=FL,Level=Grant/>
<Child Id=2,State=CA,Level=Denied/>
<Branch Id=3,State=WY,Level=NONE/>
<Child Id=4,State=TN,Level=Basic/>
<Root/>
My goal would like something like this I guess:
{
SELECT Id, State, Level
FROM RootTable
WHERE Root.Branch.Id = 0
}
I of course need to support the basics too:
- Create new tree
- Create new branch within existing tree
- Add/Update/Delete children and branches independent of
the other nodes
I can implement all of these features in C++ using a
standard DOM library. But, I'd love to get the powerful
querying capabilities of SQL along with the easy and
reliable admin functions.
I'm essentially hanging my decision to use a hand-coded
C++ XML server vs using SQL with XML extensions on the
querying capabilities that I need. From what I've read so
far, it seems pretty doable that SQLXML can handle the
insert, modify and delete operations. But, I'm not sure
about the querying capability.
Any help would be Greatly Appreciated :)!!
ChrisDepending on the shaping/filtering requirement you can either use XPath
against annotated schema or you can use FOR XML on the relational form (and
OpenXML or annotated schemas to store and update).
HTH
Michael
"ChrisD" <christopher_douglass@.deletethis.yahooDOTcom> wrote in message
news:1bce01c5056f$700cc140$a401280a@.phx.gbl...
> I'm new to SQLXML extenions and I'm curious if SQL Server
> can handle what I need.
> I need to store a tree data structure and I need to query
> the children within a particular or multiple branches of
> this tree. For example:
> <Root>
> <Branch Id=0,State=GA,Level=SpecialLevel/>
> <Child Id=1,State=FL,Level=Grant/>
> <Child Id=2,State=CA,Level=Denied/>
> <Branch Id=3,State=WY,Level=NONE/>
> <Child Id=4,State=TN,Level=Basic/>
> <Root/>
> My goal would like something like this I guess:
> {
> SELECT Id, State, Level
> FROM RootTable
> WHERE Root.Branch.Id = 0
> }
> I of course need to support the basics too:
> - Create new tree
> - Create new branch within existing tree
> - Add/Update/Delete children and branches independent of
> the other nodes
> I can implement all of these features in C++ using a
> standard DOM library. But, I'd love to get the powerful
> querying capabilities of SQL along with the easy and
> reliable admin functions.
> I'm essentially hanging my decision to use a hand-coded
> C++ XML server vs using SQL with XML extensions on the
> querying capabilities that I need. From what I've read so
> far, it seems pretty doable that SQLXML can handle the
> insert, modify and delete operations. But, I'm not sure
> about the querying capability.
> Any help would be Greatly Appreciated :)!!
> Chris|||Where do I find query examples using either or both
methods? Thanks!

>--Original Message--
>Depending on the shaping/filtering requirement you can
either use XPath
>against annotated schema or you can use FOR XML on the
relational form (and
>OpenXML or annotated schemas to store and update).
>HTH
>Michael
>"ChrisD" <christopher_douglass@.deletethis.yahooDOTcom>
wrote in message
>news:1bce01c5056f$700cc140$a401280a@.phx.gbl...
Server
query
so
>
>.
>|||Books Online (the SQL Server documentation) or www.sqlxml.org are two good
places to start.
Best regards
Michael
"Chris Douglass" <anonymous@.discussions.microsoft.com> wrote in message
news:1f4b01c5061f$19d99590$a401280a@.phx.gbl...
> Where do I find query examples using either or both
> methods? Thanks!
>
> either use XPath
> relational form (and
> wrote in message
> Server
> query
> so

How to query children of a given node?

I'm new to SQLXML extenions and I'm curious if SQL Server
can handle what I need.
I need to store a tree data structure and I need to query
the children within a particular or multiple branches of
this tree. For example:
<Root>
<Branch Id=0,State=GA,Level=SpecialLevel/>
<Child Id=1,State=FL,Level=Grant/>
<Child Id=2,State=CA,Level=Denied/>
<Branch Id=3,State=WY,Level=NONE/>
<Child Id=4,State=TN,Level=Basic/>
<Root/>
My goal would like something like this I guess:
{
SELECT Id, State, Level
FROM RootTable
WHERE Root.Branch.Id = 0
}
I of course need to support the basics too:
- Create new tree
- Create new branch within existing tree
- Add/Update/Delete children and branches independent of
the other nodes
I can implement all of these features in C++ using a
standard DOM library. But, I'd love to get the powerful
querying capabilities of SQL along with the easy and
reliable admin functions.
I'm essentially hanging my decision to use a hand-coded
C++ XML server vs using SQL with XML extensions on the
querying capabilities that I need. From what I've read so
far, it seems pretty doable that SQLXML can handle the
insert, modify and delete operations. But, I'm not sure
about the querying capability.
Any help would be Greatly Appreciated !!
Chris
Depending on the shaping/filtering requirement you can either use XPath
against annotated schema or you can use FOR XML on the relational form (and
OpenXML or annotated schemas to store and update).
HTH
Michael
"ChrisD" <christopher_douglass@.deletethis.yahooDOTcom> wrote in message
news:1bce01c5056f$700cc140$a401280a@.phx.gbl...
> I'm new to SQLXML extenions and I'm curious if SQL Server
> can handle what I need.
> I need to store a tree data structure and I need to query
> the children within a particular or multiple branches of
> this tree. For example:
> <Root>
> <Branch Id=0,State=GA,Level=SpecialLevel/>
> <Child Id=1,State=FL,Level=Grant/>
> <Child Id=2,State=CA,Level=Denied/>
> <Branch Id=3,State=WY,Level=NONE/>
> <Child Id=4,State=TN,Level=Basic/>
> <Root/>
> My goal would like something like this I guess:
> {
> SELECT Id, State, Level
> FROM RootTable
> WHERE Root.Branch.Id = 0
> }
> I of course need to support the basics too:
> - Create new tree
> - Create new branch within existing tree
> - Add/Update/Delete children and branches independent of
> the other nodes
> I can implement all of these features in C++ using a
> standard DOM library. But, I'd love to get the powerful
> querying capabilities of SQL along with the easy and
> reliable admin functions.
> I'm essentially hanging my decision to use a hand-coded
> C++ XML server vs using SQL with XML extensions on the
> querying capabilities that I need. From what I've read so
> far, it seems pretty doable that SQLXML can handle the
> insert, modify and delete operations. But, I'm not sure
> about the querying capability.
> Any help would be Greatly Appreciated !!
> Chris
|||Where do I find query examples using either or both
methods? Thanks!

>--Original Message--
>Depending on the shaping/filtering requirement you can
either use XPath
>against annotated schema or you can use FOR XML on the
relational form (and
>OpenXML or annotated schemas to store and update).
>HTH
>Michael
>"ChrisD" <christopher_douglass@.deletethis.yahooDOTcom>
wrote in message[vbcol=seagreen]
>news:1bce01c5056f$700cc140$a401280a@.phx.gbl...
Server[vbcol=seagreen]
query[vbcol=seagreen]
so
>
>.
>
|||Books Online (the SQL Server documentation) or www.sqlxml.org are two good
places to start.
Best regards
Michael
"Chris Douglass" <anonymous@.discussions.microsoft.com> wrote in message
news:1f4b01c5061f$19d99590$a401280a@.phx.gbl...[vbcol=seagreen]
> Where do I find query examples using either or both
> methods? Thanks!
> either use XPath
> relational form (and
> wrote in message
> Server
> query
> so