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...
> 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
>--Original Message--
>You 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...
>> 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
>
>.
>|||from EM you can also use the restore from device option and pick the
files from disk.
Micah wrote:
> 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