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
Thanks
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
>
|||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[vbcol=seagreen]
> 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...
user[vbcol=seagreen]
DISK
>
|||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...
> system
> user
> DISK
>
>
|||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:
[vbcol=seagreen]
>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: