Restore Without msdb.backup Record

How is it possible to restore a DB from .BAK and .TRN
files that aren't listed in the DB restore drop-down lists
in Enterprise Manager?
I've read about the msdb.backupfile and
msdb.backupmediafamily tables and how they are used to
populate the drop-down lists for a DB restore. Is there a
way to tweak those tables to give me access to the files I
need to use in order to do the backup? Is there another
way to restore the database using those files?
Any help or direction is GREATLY appreciated! We are dead
in the water right now...
Thanks in advance!
MicahYou can simply use the RESTORE command in query analyzer. You can view the
contents of the files with the RESTORE FILELISTONLY and RESTORE HEADERONLY
commands. All of these can be found in BooksOnLine.
Andrew J. Kelly
SQL Server MVP
"Micah" <anonymous@.discussions.microsoft.com> wrote in message
news:0f9401c3dfb1$41db91a0$a301280a@.phx.gbl...

quote:

---

> How is it possible to restore a DB from .BAK and .TRN
> files that aren't listed in the DB restore drop-down lists
> in Enterprise Manager?
> I've read about the msdb.backupfile and
> msdb.backupmediafamily tables and how they are used to
> populate the drop-down lists for a DB restore. Is there a
> way to tweak those tables to give me access to the files I
> need to use in order to do the backup? Is there another
> way to restore the database using those files?
> Any help or direction is GREATLY appreciated! We are dead
> in the water right now...
> Thanks in advance!
> Micah

---

|||Thank you very much!
It took a little while to get the command just right, but
I was able to do it.
Thanks again,
Micah

quote:

---

>--Original Message--
>You can simply use the RESTORE command in query

---

analyzer. You can view the

quote:

---

>contents of the files with the RESTORE FILELISTONLY and

---

RESTORE HEADERONLY

quote:

---

>commands. All of these can be found in BooksOnLine.
>--
>Andrew J. Kelly
>SQL Server MVP
>
>"Micah" <anonymous@.discussions.microsoft.com> wrote in

---

message

quote:

---

>news:0f9401c3dfb1$41db91a0$a301280a@.phx.gbl...
lists[QUOTE]
there a[QUOTE]
files I[QUOTE]
dead[QUOTE]
>
>.
>

---

|||from EM you can also use the restore from device option and pick the
files from disk.
Micah wrote:

quote:

---

> How is it possible to restore a DB from .BAK and .TRN
> files that aren't listed in the DB restore drop-down lists
> in Enterprise Manager?
> I've read about the msdb.backupfile and
> msdb.backupmediafamily tables and how they are used to
> populate the drop-down lists for a DB restore. Is there a
> way to tweak those tables to give me access to the files I
> need to use in order to do the backup? Is there another
> way to restore the database using those files?
> Any help or direction is GREATLY appreciated! We are dead
> in the water right now...
> Thanks in advance!
> Micah

---

sql