MS SQL MSDE Quick Question About Databases

Hey,
Im using MSSQL MSDE with the ASP.NET WebMatrix Project to build databases, but i cant find where the database is stored on my hard drive. I am about to format and reinstall Windows and would like to backup these databases so that i can continue to work with them after i reinstall. Can anyone help me?

Thanks in advance, all help is appreciated :)

E.The quick and dirty answer is to look at C:\Inetpubs\wwwroot. That is where mine were stored. A safer, more complete approach is to simply use a Windows Explorer seach for "My Computer".|||I believe that the default installation location for msde data files is:

\\[yourserver]\c$\Program Files\Microsoft SQL Server\MSSQL$[yourserver]\Data

-Sam

ms sql cluster: should i and how to place tempdb on local drive

Hi all
we are about to set up database on sql server cluster. Up to this point we
had set up ms sql cluster using vm.
My intention was to set up tempdb on local c drive. It turned out, that we
could not mount c drive at all and only drives which we mounted were drives
defined for cluster.
1. Do we miss something? Does clustered software allows to mount local
drives along with cluster defined drives?
2. If yes, do you recommend to use local drive for tempdb.
Thank you for your respond.
You can only place SQL data files on clustered drives where SQL is dependent
on the particular disk resource. This includes data files for tempdb.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Gene." <Gene@.discussions.microsoft.com> wrote in message
news:0A7A9EAC-DF71-499C-A615-8B26F99CD15C@.microsoft.com...
> Hi all
> we are about to set up database on sql server cluster. Up to this point we
> had set up ms sql cluster using vm.
> My intention was to set up tempdb on local c drive. It turned out, that we
> could not mount c drive at all and only drives which we mounted were
> drives
> defined for cluster.
> 1. Do we miss something? Does clustered software allows to mount local
> drives along with cluster defined drives?
> 2. If yes, do you recommend to use local drive for tempdb.
> Thank you for your respond.
|||Hi all
I would like to remark myself regarding my post below.
C drive is visable to cluster pc but...
it's not visable to sql server.
When you create new db either using tsql or windows inerface, 1 one produce
error complaining about not visable drive.
Windows interface does not show c drive as one generaly available for
database creation.
"Gene." wrote:

> Hi all
> we are about to set up database on sql server cluster. Up to this point we
> had set up ms sql cluster using vm.
> My intention was to set up tempdb on local c drive. It turned out, that we
> could not mount c drive at all and only drives which we mounted were drives
> defined for cluster.
> 1. Do we miss something? Does clustered software allows to mount local
> drives along with cluster defined drives?
> 2. If yes, do you recommend to use local drive for tempdb.
> Thank you for your respond.
|||Geoff
Do you mind if i ask you:
We can not do it because cluster does not have c drive defined to it (and
likely can not have c drive defined to it)?
Gene.
"Geoff N. Hiten" wrote:

> You can only place SQL data files on clustered drives where SQL is dependent
> on the particular disk resource. This includes data files for tempdb.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Gene." <Gene@.discussions.microsoft.com> wrote in message
> news:0A7A9EAC-DF71-499C-A615-8B26F99CD15C@.microsoft.com...
>
|||C: is local to each node and cannot be defined as a cluster resource even
when it exists on all nodes. You cannot place tempdb for a cluster on local
disks.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Gene." <Gene@.discussions.microsoft.com> wrote in message
news:C7F5E403-A592-452C-B5C0-7DCC7D1B437B@.microsoft.com...[vbcol=seagreen]
> Geoff
> Do you mind if i ask you:
> We can not do it because cluster does not have c drive defined to it (and
> likely can not have c drive defined to it)?
> Gene.
> "Geoff N. Hiten" wrote:
|||Thank you Geoff. now I understand.
"Geoff N. Hiten" wrote:

> C: is local to each node and cannot be defined as a cluster resource even
> when it exists on all nodes. You cannot place tempdb for a cluster on local
> disks.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Gene." <Gene@.discussions.microsoft.com> wrote in message
> news:C7F5E403-A592-452C-B5C0-7DCC7D1B437B@.microsoft.com...
>

ms sql cluster: should i and how to place tempdb on local drive

Hi all
we are about to set up database on sql server cluster. Up to this point we
had set up ms sql cluster using vm.
My intention was to set up tempdb on local c drive. It turned out, that we
could not mount c drive at all and only drives which we mounted were drives
defined for cluster.
1. Do we miss something? Does clustered software allows to mount local
drives along with cluster defined drives?
2. If yes, do you recommend to use local drive for tempdb.
Thank you for your respond.You can only place SQL data files on clustered drives where SQL is dependent
on the particular disk resource. This includes data files for tempdb.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Gene." <Gene@.discussions.microsoft.com> wrote in message
news:0A7A9EAC-DF71-499C-A615-8B26F99CD15C@.microsoft.com...
> Hi all
> we are about to set up database on sql server cluster. Up to this point we
> had set up ms sql cluster using vm.
> My intention was to set up tempdb on local c drive. It turned out, that we
> could not mount c drive at all and only drives which we mounted were
> drives
> defined for cluster.
> 1. Do we miss something? Does clustered software allows to mount local
> drives along with cluster defined drives?
> 2. If yes, do you recommend to use local drive for tempdb.
> Thank you for your respond.|||Hi all
I would like to remark myself regarding my post below.
C drive is visable to cluster pc but...
it's not visable to sql server.
When you create new db either using tsql or windows inerface, 1 one produce
error complaining about not visable drive.
Windows interface does not show c drive as one generaly available for
database creation.
"Gene." wrote:
> Hi all
> we are about to set up database on sql server cluster. Up to this point we
> had set up ms sql cluster using vm.
> My intention was to set up tempdb on local c drive. It turned out, that we
> could not mount c drive at all and only drives which we mounted were drives
> defined for cluster.
> 1. Do we miss something? Does clustered software allows to mount local
> drives along with cluster defined drives?
> 2. If yes, do you recommend to use local drive for tempdb.
> Thank you for your respond.|||Geoff
Do you mind if i ask you:
We can not do it because cluster does not have c drive defined to it (and
likely can not have c drive defined to it)?
Gene.
"Geoff N. Hiten" wrote:
> You can only place SQL data files on clustered drives where SQL is dependent
> on the particular disk resource. This includes data files for tempdb.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Gene." <Gene@.discussions.microsoft.com> wrote in message
> news:0A7A9EAC-DF71-499C-A615-8B26F99CD15C@.microsoft.com...
> > Hi all
> > we are about to set up database on sql server cluster. Up to this point we
> > had set up ms sql cluster using vm.
> > My intention was to set up tempdb on local c drive. It turned out, that we
> > could not mount c drive at all and only drives which we mounted were
> > drives
> > defined for cluster.
> > 1. Do we miss something? Does clustered software allows to mount local
> > drives along with cluster defined drives?
> > 2. If yes, do you recommend to use local drive for tempdb.
> >
> > Thank you for your respond.
>|||C: is local to each node and cannot be defined as a cluster resource even
when it exists on all nodes. You cannot place tempdb for a cluster on local
disks.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Gene." <Gene@.discussions.microsoft.com> wrote in message
news:C7F5E403-A592-452C-B5C0-7DCC7D1B437B@.microsoft.com...
> Geoff
> Do you mind if i ask you:
> We can not do it because cluster does not have c drive defined to it (and
> likely can not have c drive defined to it)?
> Gene.
> "Geoff N. Hiten" wrote:
>> You can only place SQL data files on clustered drives where SQL is
>> dependent
>> on the particular disk resource. This includes data files for tempdb.
>> --
>> Geoff N. Hiten
>> Senior SQL Infrastructure Consultant
>> Microsoft SQL Server MVP
>>
>>
>> "Gene." <Gene@.discussions.microsoft.com> wrote in message
>> news:0A7A9EAC-DF71-499C-A615-8B26F99CD15C@.microsoft.com...
>> > Hi all
>> > we are about to set up database on sql server cluster. Up to this point
>> > we
>> > had set up ms sql cluster using vm.
>> > My intention was to set up tempdb on local c drive. It turned out, that
>> > we
>> > could not mount c drive at all and only drives which we mounted were
>> > drives
>> > defined for cluster.
>> > 1. Do we miss something? Does clustered software allows to mount local
>> > drives along with cluster defined drives?
>> > 2. If yes, do you recommend to use local drive for tempdb.
>> >
>> > Thank you for your respond.
>>|||Thank you Geoff. now I understand.
"Geoff N. Hiten" wrote:
> C: is local to each node and cannot be defined as a cluster resource even
> when it exists on all nodes. You cannot place tempdb for a cluster on local
> disks.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Gene." <Gene@.discussions.microsoft.com> wrote in message
> news:C7F5E403-A592-452C-B5C0-7DCC7D1B437B@.microsoft.com...
> > Geoff
> >
> > Do you mind if i ask you:
> > We can not do it because cluster does not have c drive defined to it (and
> > likely can not have c drive defined to it)?
> >
> > Gene.
> >
> > "Geoff N. Hiten" wrote:
> >
> >> You can only place SQL data files on clustered drives where SQL is
> >> dependent
> >> on the particular disk resource. This includes data files for tempdb.
> >>
> >> --
> >> Geoff N. Hiten
> >> Senior SQL Infrastructure Consultant
> >> Microsoft SQL Server MVP
> >>
> >>
> >>
> >>
> >> "Gene." <Gene@.discussions.microsoft.com> wrote in message
> >> news:0A7A9EAC-DF71-499C-A615-8B26F99CD15C@.microsoft.com...
> >> > Hi all
> >> > we are about to set up database on sql server cluster. Up to this point
> >> > we
> >> > had set up ms sql cluster using vm.
> >> > My intention was to set up tempdb on local c drive. It turned out, that
> >> > we
> >> > could not mount c drive at all and only drives which we mounted were
> >> > drives
> >> > defined for cluster.
> >> > 1. Do we miss something? Does clustered software allows to mount local
> >> > drives along with cluster defined drives?
> >> > 2. If yes, do you recommend to use local drive for tempdb.
> >> >
> >> > Thank you for your respond.
> >>
> >>
>

ms sql cluster: should i and how to place tempdb on local drive

Hi all
we are about to set up database on sql server cluster. Up to this point we
had set up ms sql cluster using vm.
My intention was to set up tempdb on local c drive. It turned out, that we
could not mount c drive at all and only drives which we mounted were drives
defined for cluster.
1. Do we miss something? Does clustered software allows to mount local
drives along with cluster defined drives?
2. If yes, do you recommend to use local drive for tempdb.
Thank you for your respond.You can only place SQL data files on clustered drives where SQL is dependent
on the particular disk resource. This includes data files for tempdb.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Gene." <Gene@.discussions.microsoft.com> wrote in message
news:0A7A9EAC-DF71-499C-A615-8B26F99CD15C@.microsoft.com...
> Hi all
> we are about to set up database on sql server cluster. Up to this point we
> had set up ms sql cluster using vm.
> My intention was to set up tempdb on local c drive. It turned out, that we
> could not mount c drive at all and only drives which we mounted were
> drives
> defined for cluster.
> 1. Do we miss something? Does clustered software allows to mount local
> drives along with cluster defined drives?
> 2. If yes, do you recommend to use local drive for tempdb.
> Thank you for your respond.|||Hi all
I would like to remark myself regarding my post below.
C drive is visable to cluster pc but...
it's not visable to sql server.
When you create new db either using tsql or windows inerface, 1 one produce
error complaining about not visable drive.
Windows interface does not show c drive as one generaly available for
database creation.
"Gene." wrote:

> Hi all
> we are about to set up database on sql server cluster. Up to this point we
> had set up ms sql cluster using vm.
> My intention was to set up tempdb on local c drive. It turned out, that we
> could not mount c drive at all and only drives which we mounted were drive
s
> defined for cluster.
> 1. Do we miss something? Does clustered software allows to mount local
> drives along with cluster defined drives?
> 2. If yes, do you recommend to use local drive for tempdb.
> Thank you for your respond.

MS SQL 2000 DB recovery

well here i am trying to recover an MS SQL 2000 server and
i don't have a clue in what is involved.
The server had a single IDE drive and it crashed on me! So
now i have to figure out how to restore this guy without
knowing what to do. here is what i did:
Reinstalled win 2k server on it
dumped system_state from tapes
restored all c: and d: from full backup (mssql what
installed on c:, d: was just for daily backups of the DBs)
I'm just wandering if there is a proper method of restore
(transaction logs and stuff) that i need to follow'
Can enybody explane me what is the right procedure to
restore a MS SQL server from backup?
Please help!!It depends on what you have. If you have the .mdf and .ldf
files, these are the database files. You can use
sp_attach_db and be back in business very quickly.
If you have .bak files, this is a backup file and you need
to restore it. As you are not experienced with SQL Server
use enterprise manager. BOL has a step by step guide to
take you through the process. (Search on restoring)
Regards
John|||Hi John,
I forgot to mention that i have both files... bak
and .mdf and .ldf files...
>--Original Message--
>Hi John,
>Thanks for your reply... i do have the lattest bak file
>can i just restore it from this file. Do i need to create
>the server from scratch create the exact tables and then
>restore from all the bak files?
>Jeff
>>--Original Message--
>>It depends on what you have. If you have the .mdf
>and .ldf
>>files, these are the database files. You can use
>>sp_attach_db and be back in business very quickly.
>>If you have .bak files, this is a backup file and you
>need
>>to restore it. As you are not experienced with SQL
Server
>>use enterprise manager. BOL has a step by step guide to
>>take you through the process. (Search on restoring)
>>Regards
>>John
>>.
>.
>|||If you have the .mdf and .ldf, that would be quicker. Copy
them to a server that has SQL Server installed. Use
sp_attach_db to attach them. Depending on size of the
database and server configuration, it will take from a few
seconds to a minute or two., and then you will have a
working accessable database.
If you use the .bak you will need to do a full restore,
which will take longer.
You do not need to create anything prior to the attach or
restore. All you need is an installation of SQL Server.
Attach just lets the master database know it has a new
database attached to it. Restore will build the database
from scratch including tables indexes etc as well as
restoring the data.
Check Books on line for full details.|||Thx John,
I appriciate your time and your help.. i'll let you know
how it goes ;)
>--Original Message--
>If you have the .mdf and .ldf, that would be quicker.
Copy
>them to a server that has SQL Server installed. Use
>sp_attach_db to attach them. Depending on size of the
>database and server configuration, it will take from a
few
>seconds to a minute or two., and then you will have a
>working accessable database.
>If you use the .bak you will need to do a full restore,
>which will take longer.
>You do not need to create anything prior to the attach or
>restore. All you need is an installation of SQL Server.
>Attach just lets the master database know it has a new
>database attached to it. Restore will build the database
>from scratch including tables indexes etc as well as
>restoring the data.
>Check Books on line for full details.
>.
>|||Thanks for all your help john... that worked fine!!!
Jeff
>--Original Message--
>If you have the .mdf and .ldf, that would be quicker.
Copy
>them to a server that has SQL Server installed. Use
>sp_attach_db to attach them. Depending on size of the
>database and server configuration, it will take from a
few
>seconds to a minute or two., and then you will have a
>working accessable database.
>If you use the .bak you will need to do a full restore,
>which will take longer.
>You do not need to create anything prior to the attach or
>restore. All you need is an installation of SQL Server.
>Attach just lets the master database know it has a new
>database attached to it. Restore will build the database
>from scratch including tables indexes etc as well as
>restoring the data.
>Check Books on line for full details.
>.
>