post disaster questions

sql2k sp3
First of all thanks alot to those of you who helped me out
yesterday. Now Im trying to better prepare for the future.
I had a corrupted Master db. The cause of this is still in
debate and at this point Im hoping it doesnt happen again.
The event viewer said one of our disks in a raid 5 array
was bad, but: a checkdisk, some Dell software, being able
to get on the disk and write, and our network admins
disagree. Fair enough. Since SQL needs to be on in order
to do a restore, restoring Master when SQL couldnt be
started wasnt an option. So I had to uninstall, reinstall
SQL. Then restore Master from the day befores backup. So
my questions are:
Is there a way to backup the Master mdf and ldf files
without shutting down SQL?
When I restored Master anfter the uninstall/ reinstall,
most of my user db's appeared unscathed. Why? I was
expecting to need to restore them from backup. Most of
them aren't backed up as they are mostly use for QA
purposes. The two that didnt survive were our actual
Development db and the Replication Distribution db. The
Development db I was able to restaore from backup and the
Distribution was just a loss. So, why did most of them
appear after restoring the Master but two of them didnt? I
wasnt expecting any of them to make it without restores.
TIA, ChrisRThey showed, up because the information about the databases is stored in the
tables within the master database. So basically since you restored from a
master database the information about your users database was also restored.
As far as backing up the master mdf and ldf files, I'm assuming you want to
do this at the file system level, with the DOS "copy" command. Since the
mdf and ldf files are in use when the database server is up, you can't use
the "copy" command. You will need to shutdown SQL Server and then do the
copy.
--
----
----
-
Need SQL Server Examples check out my website
http://www.geocities.com/sqlserverexamples
"ChrisR" <anonymous@.discussions.microsoft.com> wrote in message
news:cfda01c48ac9$69e6a7c0$a501280a@.phx.gbl...
> sql2k sp3
> First of all thanks alot to those of you who helped me out
> yesterday. Now Im trying to better prepare for the future.
> I had a corrupted Master db. The cause of this is still in
> debate and at this point Im hoping it doesnt happen again.
> The event viewer said one of our disks in a raid 5 array
> was bad, but: a checkdisk, some Dell software, being able
> to get on the disk and write, and our network admins
> disagree. Fair enough. Since SQL needs to be on in order
> to do a restore, restoring Master when SQL couldnt be
> started wasnt an option. So I had to uninstall, reinstall
> SQL. Then restore Master from the day befores backup. So
> my questions are:
> Is there a way to backup the Master mdf and ldf files
> without shutting down SQL?
> When I restored Master anfter the uninstall/ reinstall,
> most of my user db's appeared unscathed. Why? I was
> expecting to need to restore them from backup. Most of
> them aren't backed up as they are mostly use for QA
> purposes. The two that didnt survive were our actual
> Development db and the Replication Distribution db. The
> Development db I was able to restaore from backup and the
> Distribution was just a loss. So, why did most of them
> appear after restoring the Master but two of them didnt? I
> wasnt expecting any of them to make it without restores.
> TIA, ChrisR|||Do you know why two of the db's didnt survive once the
master was restored?
>--Original Message--
>They showed, up because the information about the
databases is stored in the
>tables within the master database. So basically since
you restored from a
>master database the information about your users database
was also restored.
>As far as backing up the master mdf and ldf files, I'm
assuming you want to
>do this at the file system level, with the DOS "copy"
command. Since the
>mdf and ldf files are in use when the database server is
up, you can't use
>the "copy" command. You will need to shutdown SQL Server
and then do the
>copy.
>--
>----
--
>----
--
>-
>Need SQL Server Examples check out my website
>http://www.geocities.com/sqlserverexamples
>
>"ChrisR" <anonymous@.discussions.microsoft.com> wrote in
message
>news:cfda01c48ac9$69e6a7c0$a501280a@.phx.gbl...
>> sql2k sp3
>> First of all thanks alot to those of you who helped me
out
>> yesterday. Now Im trying to better prepare for the
future.
>> I had a corrupted Master db. The cause of this is still
in
>> debate and at this point Im hoping it doesnt happen
again.
>> The event viewer said one of our disks in a raid 5 array
>> was bad, but: a checkdisk, some Dell software, being
able
>> to get on the disk and write, and our network admins
>> disagree. Fair enough. Since SQL needs to be on in order
>> to do a restore, restoring Master when SQL couldnt be
>> started wasnt an option. So I had to uninstall,
reinstall
>> SQL. Then restore Master from the day befores backup. So
>> my questions are:
>> Is there a way to backup the Master mdf and ldf files
>> without shutting down SQL?
>> When I restored Master anfter the uninstall/ reinstall,
>> most of my user db's appeared unscathed. Why? I was
>> expecting to need to restore them from backup. Most of
>> them aren't backed up as they are mostly use for QA
>> purposes. The two that didnt survive were our actual
>> Development db and the Replication Distribution db. The
>> Development db I was able to restaore from backup and
the
>> Distribution was just a loss. So, why did most of them
>> appear after restoring the Master but two of them
didnt? I
>> wasnt expecting any of them to make it without restores.
>> TIA, ChrisR
>
>.
>|||Perhaps you hadn't created those databases at the time you took the backup of the master database?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ChrisR" <anonymous@.discussions.microsoft.com> wrote in message news:014001c48ad4$519314f0$a301280a@.phx.gbl...
> Do you know why two of the db's didnt survive once the
> master was restored?
>
> >--Original Message--
> >They showed, up because the information about the
> databases is stored in the
> >tables within the master database. So basically since
> you restored from a
> >master database the information about your users database
> was also restored.
> >
> >As far as backing up the master mdf and ldf files, I'm
> assuming you want to
> >do this at the file system level, with the DOS "copy"
> command. Since the
> >mdf and ldf files are in use when the database server is
> up, you can't use
> >the "copy" command. You will need to shutdown SQL Server
> and then do the
> >copy.
> >
> >--
> >
> >----
> --
> >----
> --
> >-
> >
> >Need SQL Server Examples check out my website
> >http://www.geocities.com/sqlserverexamples
> >
> >
> >"ChrisR" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:cfda01c48ac9$69e6a7c0$a501280a@.phx.gbl...
> >> sql2k sp3
> >>
> >> First of all thanks alot to those of you who helped me
> out
> >> yesterday. Now Im trying to better prepare for the
> future.
> >>
> >> I had a corrupted Master db. The cause of this is still
> in
> >> debate and at this point Im hoping it doesnt happen
> again.
> >> The event viewer said one of our disks in a raid 5 array
> >> was bad, but: a checkdisk, some Dell software, being
> able
> >> to get on the disk and write, and our network admins
> >> disagree. Fair enough. Since SQL needs to be on in order
> >> to do a restore, restoring Master when SQL couldnt be
> >> started wasnt an option. So I had to uninstall,
> reinstall
> >> SQL. Then restore Master from the day befores backup. So
> >> my questions are:
> >>
> >> Is there a way to backup the Master mdf and ldf files
> >> without shutting down SQL?
> >>
> >> When I restored Master anfter the uninstall/ reinstall,
> >> most of my user db's appeared unscathed. Why? I was
> >> expecting to need to restore them from backup. Most of
> >> them aren't backed up as they are mostly use for QA
> >> purposes. The two that didnt survive were our actual
> >> Development db and the Replication Distribution db. The
> >> Development db I was able to restaore from backup and
> the
> >> Distribution was just a loss. So, why did most of them
> >> appear after restoring the Master but two of them
> didnt? I
> >> wasnt expecting any of them to make it without restores.
> >>
> >> TIA, ChrisR
> >
> >
> >.
> >|||There're two reasons that 2 dbs didn't appear:
(1) Somebody changed the location.
(2) 2 dbs were created after you backed up Master DB.
BTW, why do you need to backup master data files?
SQL backup is enough for you to recover the whole
system.
Steven
>--Original Message--
>Perhaps you hadn't created those databases at the time
you took the backup of the master database?
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"ChrisR" <anonymous@.discussions.microsoft.com> wrote in
message news:014001c48ad4$519314f0$a301280a@.phx.gbl...
>> Do you know why two of the db's didnt survive once the
>> master was restored?
>>
>> >--Original Message--
>> >They showed, up because the information about the
>> databases is stored in the
>> >tables within the master database. So basically since
>> you restored from a
>> >master database the information about your users
database
>> was also restored.
>> >
>> >As far as backing up the master mdf and ldf files, I'm
>> assuming you want to
>> >do this at the file system level, with the DOS "copy"
>> command. Since the
>> >mdf and ldf files are in use when the database server
is
>> up, you can't use
>> >the "copy" command. You will need to shutdown SQL
Server
>> and then do the
>> >copy.
>> >
>> >--
>> >
>> >----
--
>> --
>> >----
--
>> --
>> >-
>> >
>> >Need SQL Server Examples check out my website
>> >http://www.geocities.com/sqlserverexamples
>> >
>> >
>> >"ChrisR" <anonymous@.discussions.microsoft.com> wrote in
>> message
>> >news:cfda01c48ac9$69e6a7c0$a501280a@.phx.gbl...
>> >> sql2k sp3
>> >>
>> >> First of all thanks alot to those of you who helped
me
>> out
>> >> yesterday. Now Im trying to better prepare for the
>> future.
>> >>
>> >> I had a corrupted Master db. The cause of this is
still
>> in
>> >> debate and at this point Im hoping it doesnt happen
>> again.
>> >> The event viewer said one of our disks in a raid 5
array
>> >> was bad, but: a checkdisk, some Dell software, being
>> able
>> >> to get on the disk and write, and our network admins
>> >> disagree. Fair enough. Since SQL needs to be on in
order
>> >> to do a restore, restoring Master when SQL couldnt be
>> >> started wasnt an option. So I had to uninstall,
>> reinstall
>> >> SQL. Then restore Master from the day befores
backup. So
>> >> my questions are:
>> >>
>> >> Is there a way to backup the Master mdf and ldf files
>> >> without shutting down SQL?
>> >>
>> >> When I restored Master anfter the uninstall/
reinstall,
>> >> most of my user db's appeared unscathed. Why? I was
>> >> expecting to need to restore them from backup. Most
of
>> >> them aren't backed up as they are mostly use for QA
>> >> purposes. The two that didnt survive were our actual
>> >> Development db and the Replication Distribution db.
The
>> >> Development db I was able to restaore from backup and
>> the
>> >> Distribution was just a loss. So, why did most of
them
>> >> appear after restoring the Master but two of them
>> didnt? I
>> >> wasnt expecting any of them to make it without
restores.
>> >>
>> >> TIA, ChrisR
>> >
>> >
>> >.
>> >
>
>.
>|||>BTW, why do you need to backup master data files?
> SQL backup is enough for you to recover the whole
> system.
>
Not if SQL cant start to do a Master restore.
>--Original Message--
>There're two reasons that 2 dbs didn't appear:
>(1) Somebody changed the location.
>(2) 2 dbs were created after you backed up Master DB.
>BTW, why do you need to backup master data files?
> SQL backup is enough for you to recover the whole
> system.
>Steven
>
>>--Original Message--
>>Perhaps you hadn't created those databases at the time
>you took the backup of the master database?
>>--
>>Tibor Karaszi, SQL Server MVP
>>http://www.karaszi.com/sqlserver/default.asp
>>http://www.solidqualitylearning.com/
>>
>>"ChrisR" <anonymous@.discussions.microsoft.com> wrote in
>message news:014001c48ad4$519314f0$a301280a@.phx.gbl...
>> Do you know why two of the db's didnt survive once the
>> master was restored?
>>
>> >--Original Message--
>> >They showed, up because the information about the
>> databases is stored in the
>> >tables within the master database. So basically since
>> you restored from a
>> >master database the information about your users
>database
>> was also restored.
>> >
>> >As far as backing up the master mdf and ldf files, I'm
>> assuming you want to
>> >do this at the file system level, with the DOS "copy"
>> command. Since the
>> >mdf and ldf files are in use when the database server
>is
>> up, you can't use
>> >the "copy" command. You will need to shutdown SQL
>Server
>> and then do the
>> >copy.
>> >
>> >--
>> >
>> >---
-
>--
>> --
>> >---
-
>--
>> --
>> >-
>> >
>> >Need SQL Server Examples check out my website
>> >http://www.geocities.com/sqlserverexamples
>> >
>> >
>> >"ChrisR" <anonymous@.discussions.microsoft.com> wrote
in
>> message
>> >news:cfda01c48ac9$69e6a7c0$a501280a@.phx.gbl...
>> >> sql2k sp3
>> >>
>> >> First of all thanks alot to those of you who helped
>me
>> out
>> >> yesterday. Now Im trying to better prepare for the
>> future.
>> >>
>> >> I had a corrupted Master db. The cause of this is
>still
>> in
>> >> debate and at this point Im hoping it doesnt happen
>> again.
>> >> The event viewer said one of our disks in a raid 5
>array
>> >> was bad, but: a checkdisk, some Dell software, being
>> able
>> >> to get on the disk and write, and our network admins
>> >> disagree. Fair enough. Since SQL needs to be on in
>order
>> >> to do a restore, restoring Master when SQL couldnt
be
>> >> started wasnt an option. So I had to uninstall,
>> reinstall
>> >> SQL. Then restore Master from the day befores
>backup. So
>> >> my questions are:
>> >>
>> >> Is there a way to backup the Master mdf and ldf
files
>> >> without shutting down SQL?
>> >>
>> >> When I restored Master anfter the uninstall/
>reinstall,
>> >> most of my user db's appeared unscathed. Why? I was
>> >> expecting to need to restore them from backup. Most
>of
>> >> them aren't backed up as they are mostly use for QA
>> >> purposes. The two that didnt survive were our actual
>> >> Development db and the Replication Distribution db.
>The
>> >> Development db I was able to restaore from backup
and
>> the
>> >> Distribution was just a loss. So, why did most of
>them
>> >> appear after restoring the Master but two of them
>> didnt? I
>> >> wasnt expecting any of them to make it without
>restores.
>> >>
>> >> TIA, ChrisR
>> >
>> >
>> >.
>> >
>>
>>.
>.
>