Backup location

From backupset table in msdb we found that there is a baclup done by user 'NT
AUTHORITY/SYSTEM' does it mean that a local admin is doing backups
Also how do i fnd physical location of above backup if it was done on DISK
ThanksYes it was done as the local sys admin account. Take a look at the system
table "backupfile" for that information.
--
Andrew J. Kelly SQL MVP
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:32A9F457-BC22-497C-BE68-5DB7FE753ACE@.microsoft.com...
> From backupset table in msdb we found that there is a baclup done by user
> 'NT
> AUTHORITY/SYSTEM' does it mean that a local admin is doing backups
> Also how do i fnd physical location of above backup if it was done on DISK
> Thanks
>|||FYI, all backup and restore information is stored in the MSDB database.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uaTlFca$EHA.1260@.TK2MSFTNGP12.phx.gbl...
> Yes it was done as the local sys admin account. Take a look at the
system
> table "backupfile" for that information.
> --
> Andrew J. Kelly SQL MVP
>
> "Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
> news:32A9F457-BC22-497C-BE68-5DB7FE753ACE@.microsoft.com...
> > From backupset table in msdb we found that there is a baclup done by
user
> > 'NT
> > AUTHORITY/SYSTEM' does it mean that a local admin is doing backups
> >
> > Also how do i fnd physical location of above backup if it was done on
DISK
> >
> > Thanks
> >
>|||I would like to know where i can find the file *.bak which i could use to
restore the database ?
I looked at following tables and couldnt find it
backupset
backupfile
backupmediaset
Thanks..
"Geoff N. Hiten" wrote:
> FYI, all backup and restore information is stored in the MSDB database.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:uaTlFca$EHA.1260@.TK2MSFTNGP12.phx.gbl...
> > Yes it was done as the local sys admin account. Take a look at the
> system
> > table "backupfile" for that information.
> >
> > --
> > Andrew J. Kelly SQL MVP
> >
> >
> > "Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
> > news:32A9F457-BC22-497C-BE68-5DB7FE753ACE@.microsoft.com...
> > > From backupset table in msdb we found that there is a baclup done by
> user
> > > 'NT
> > > AUTHORITY/SYSTEM' does it mean that a local admin is doing backups
> > >
> > > Also how do i fnd physical location of above backup if it was done on
> DISK
> > >
> > > Thanks
> > >
> >
> >
>
>|||You can get the device from the physical_device_name column
in the table backupmediafamily
-Sue
On Tue, 18 Jan 2005 14:55:06 -0800, Sanjay
<Sanjay@.discussions.microsoft.com> wrote:
>I would like to know where i can find the file *.bak which i could use to
>restore the database ?
>I looked at following tables and couldnt find it
>backupset
>backupfile
>backupmediaset
>Thanks..
>
>"Geoff N. Hiten" wrote:
>> FYI, all backup and restore information is stored in the MSDB database.
>> --
>> Geoff N. Hiten
>> Microsoft SQL Server MVP
>> Senior Database Administrator
>> Careerbuilder.com
>> I support the Professional Association for SQL Server
>> www.sqlpass.org
>> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
>> news:uaTlFca$EHA.1260@.TK2MSFTNGP12.phx.gbl...
>> > Yes it was done as the local sys admin account. Take a look at the
>> system
>> > table "backupfile" for that information.
>> >
>> > --
>> > Andrew J. Kelly SQL MVP
>> >
>> >
>> > "Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
>> > news:32A9F457-BC22-497C-BE68-5DB7FE753ACE@.microsoft.com...
>> > > From backupset table in msdb we found that there is a baclup done by
>> user
>> > > 'NT
>> > > AUTHORITY/SYSTEM' does it mean that a local admin is doing backups
>> > >
>> > > Also how do i fnd physical location of above backup if it was done on
>> DISK
>> > >
>> > > Thanks
>> > >
>> >
>> >
>>