Backup single table

I would like to take the backup of only 15 tables out of 800 tables and 8
stored procedures out of 90. The database is very huge and might take few
hours to take full database backup
is there anyway I can take backup only selected tables and stored
procedures? I have SQL Server 2000 running.
thanks
FarrukhIf you will regularly be backing up certain tables, then consider placing
them into their own filegroup and then backing up that filegroup. As for
stored procs, you can use Enterprise Manager to script them. As a best
practice, you should have your scripts in version control outside of your
SQL Server.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"FARRUKH" <farrscorpio77@.hotmail.com> wrote in message
news:82CA5B73-6DBC-433B-A8F0-9249E9FD8590@.microsoft.com...
I would like to take the backup of only 15 tables out of 800 tables and 8
stored procedures out of 90. The database is very huge and might take few
hours to take full database backup
is there anyway I can take backup only selected tables and stored
procedures? I have SQL Server 2000 running.
thanks
Farrukh|||I dont get this request daily. Actually this is the first time i get this
request. I dont have any script. would you like to share ur script? thanks
"Tom Moreau" wrote:
> If you will regularly be backing up certain tables, then consider placing
> them into their own filegroup and then backing up that filegroup. As for
> stored procs, you can use Enterprise Manager to script them. As a best
> practice, you should have your scripts in version control outside of your
> SQL Server.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "FARRUKH" <farrscorpio77@.hotmail.com> wrote in message
> news:82CA5B73-6DBC-433B-A8F0-9249E9FD8590@.microsoft.com...
> I would like to take the backup of only 15 tables out of 800 tables and 8
> stored procedures out of 90. The database is very huge and might take few
> hours to take full database backup
> is there anyway I can take backup only selected tables and stored
> procedures? I have SQL Server 2000 running.
> thanks
> Farrukh
>
>|||There is no script here. Just right-click on the DB, click on All
Tasks->generate SQL script.
As for the filegoups, you are looking at a fair bit of work, since you now
need to migrate your existing tables to this filegroup, and that's a rebuild
of those tables.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"FARRUKH" <farrscorpio77@.hotmail.com> wrote in message
news:055BC3BC-89AE-4424-95B0-A3CE72FA7AB3@.microsoft.com...
I dont get this request daily. Actually this is the first time i get this
request. I dont have any script. would you like to share ur script? thanks
"Tom Moreau" wrote:
> If you will regularly be backing up certain tables, then consider placing
> them into their own filegroup and then backing up that filegroup. As for
> stored procs, you can use Enterprise Manager to script them. As a best
> practice, you should have your scripts in version control outside of your
> SQL Server.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "FARRUKH" <farrscorpio77@.hotmail.com> wrote in message
> news:82CA5B73-6DBC-433B-A8F0-9249E9FD8590@.microsoft.com...
> I would like to take the backup of only 15 tables out of 800 tables and 8
> stored procedures out of 90. The database is very huge and might take few
> hours to take full database backup
> is there anyway I can take backup only selected tables and stored
> procedures? I have SQL Server 2000 running.
> thanks
> Farrukh
>
>|||> As for the filegoups, you are looking at a fair bit of work, since you now
> need to migrate your existing tables to this filegroup, and that's a rebuild
> of those tables.
... also, it isn't obvious how to get a backup of a filegroup available, unless you also have backup
of the rest of the database (which makes the filegroup backup kind of ... moot). In short, filegroup
backup should only be done with a very good understanding about backup in SQL Server and what it
does and does not give you. :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:uQgDLDnmIHA.4536@.TK2MSFTNGP06.phx.gbl...
> There is no script here. Just right-click on the DB, click on All
> Tasks->generate SQL script.
> As for the filegoups, you are looking at a fair bit of work, since you now
> need to migrate your existing tables to this filegroup, and that's a rebuild
> of those tables.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "FARRUKH" <farrscorpio77@.hotmail.com> wrote in message
> news:055BC3BC-89AE-4424-95B0-A3CE72FA7AB3@.microsoft.com...
> I dont get this request daily. Actually this is the first time i get this
> request. I dont have any script. would you like to share ur script? thanks
> "Tom Moreau" wrote:
>> If you will regularly be backing up certain tables, then consider placing
>> them into their own filegroup and then backing up that filegroup. As for
>> stored procs, you can use Enterprise Manager to script them. As a best
>> practice, you should have your scripts in version control outside of your
>> SQL Server.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "FARRUKH" <farrscorpio77@.hotmail.com> wrote in message
>> news:82CA5B73-6DBC-433B-A8F0-9249E9FD8590@.microsoft.com...
>> I would like to take the backup of only 15 tables out of 800 tables and 8
>> stored procedures out of 90. The database is very huge and might take few
>> hours to take full database backup
>> is there anyway I can take backup only selected tables and stored
>> procedures? I have SQL Server 2000 running.
>> thanks
>> Farrukh
>>
>|||In a case like this, BCP MIGHT be a workable solution.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:D39370AC-E225-4DAB-97C7-753FA5D4B378@.microsoft.com...
>> As for the filegoups, you are looking at a fair bit of work, since you
>> now
>> need to migrate your existing tables to this filegroup, and that's a
>> rebuild
>> of those tables.
> ... also, it isn't obvious how to get a backup of a filegroup available,
> unless you also have backup of the rest of the database (which makes the
> filegroup backup kind of ... moot). In short, filegroup backup should only
> be done with a very good understanding about backup in SQL Server and what
> it does and does not give you. :-)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:uQgDLDnmIHA.4536@.TK2MSFTNGP06.phx.gbl...
>> There is no script here. Just right-click on the DB, click on All
>> Tasks->generate SQL script.
>> As for the filegoups, you are looking at a fair bit of work, since you
>> now
>> need to migrate your existing tables to this filegroup, and that's a
>> rebuild
>> of those tables.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "FARRUKH" <farrscorpio77@.hotmail.com> wrote in message
>> news:055BC3BC-89AE-4424-95B0-A3CE72FA7AB3@.microsoft.com...
>> I dont get this request daily. Actually this is the first time i get this
>> request. I dont have any script. would you like to share ur script?
>> thanks
>> "Tom Moreau" wrote:
>> If you will regularly be backing up certain tables, then consider
>> placing
>> them into their own filegroup and then backing up that filegroup. As
>> for
>> stored procs, you can use Enterprise Manager to script them. As a best
>> practice, you should have your scripts in version control outside of
>> your
>> SQL Server.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>> "FARRUKH" <farrscorpio77@.hotmail.com> wrote in message
>> news:82CA5B73-6DBC-433B-A8F0-9249E9FD8590@.microsoft.com...
>> I would like to take the backup of only 15 tables out of 800 tables and
>> 8
>> stored procedures out of 90. The database is very huge and might take
>> few
>> hours to take full database backup
>> is there anyway I can take backup only selected tables and stored
>> procedures? I have SQL Server 2000 running.
>> thanks
>> Farrukh
>>
>>
>
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

Backup single table

I would like to take the backup of only 15 tables out of 800 tables and 8
stored procedures out of 90. The database is very huge and might take few
hours to take full database backup
is there anyway I can take backup only selected tables and stored
procedures? I have SQL Server 2000 running.
thanks
Farrukh
If you will regularly be backing up certain tables, then consider placing
them into their own filegroup and then backing up that filegroup. As for
stored procs, you can use Enterprise Manager to script them. As a best
practice, you should have your scripts in version control outside of your
SQL Server.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"FARRUKH" <farrscorpio77@.hotmail.com> wrote in message
news:82CA5B73-6DBC-433B-A8F0-9249E9FD8590@.microsoft.com...
I would like to take the backup of only 15 tables out of 800 tables and 8
stored procedures out of 90. The database is very huge and might take few
hours to take full database backup
is there anyway I can take backup only selected tables and stored
procedures? I have SQL Server 2000 running.
thanks
Farrukh
|||I dont get this request daily. Actually this is the first time i get this
request. I dont have any script. would you like to share ur script? thanks
"Tom Moreau" wrote:

> If you will regularly be backing up certain tables, then consider placing
> them into their own filegroup and then backing up that filegroup. As for
> stored procs, you can use Enterprise Manager to script them. As a best
> practice, you should have your scripts in version control outside of your
> SQL Server.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "FARRUKH" <farrscorpio77@.hotmail.com> wrote in message
> news:82CA5B73-6DBC-433B-A8F0-9249E9FD8590@.microsoft.com...
> I would like to take the backup of only 15 tables out of 800 tables and 8
> stored procedures out of 90. The database is very huge and might take few
> hours to take full database backup
> is there anyway I can take backup only selected tables and stored
> procedures? I have SQL Server 2000 running.
> thanks
> Farrukh
>
>
|||There is no script here. Just right-click on the DB, click on All
Tasks->generate SQL script.
As for the filegoups, you are looking at a fair bit of work, since you now
need to migrate your existing tables to this filegroup, and that's a rebuild
of those tables.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"FARRUKH" <farrscorpio77@.hotmail.com> wrote in message
news:055BC3BC-89AE-4424-95B0-A3CE72FA7AB3@.microsoft.com...
I dont get this request daily. Actually this is the first time i get this
request. I dont have any script. would you like to share ur script? thanks
"Tom Moreau" wrote:

> If you will regularly be backing up certain tables, then consider placing
> them into their own filegroup and then backing up that filegroup. As for
> stored procs, you can use Enterprise Manager to script them. As a best
> practice, you should have your scripts in version control outside of your
> SQL Server.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "FARRUKH" <farrscorpio77@.hotmail.com> wrote in message
> news:82CA5B73-6DBC-433B-A8F0-9249E9FD8590@.microsoft.com...
> I would like to take the backup of only 15 tables out of 800 tables and 8
> stored procedures out of 90. The database is very huge and might take few
> hours to take full database backup
> is there anyway I can take backup only selected tables and stored
> procedures? I have SQL Server 2000 running.
> thanks
> Farrukh
>
>
|||> As for the filegoups, you are looking at a fair bit of work, since you now
> need to migrate your existing tables to this filegroup, and that's a rebuild
> of those tables.
... also, it isn't obvious how to get a backup of a filegroup available, unless you also have backup
of the rest of the database (which makes the filegroup backup kind of ... moot). In short, filegroup
backup should only be done with a very good understanding about backup in SQL Server and what it
does and does not give you. :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:uQgDLDnmIHA.4536@.TK2MSFTNGP06.phx.gbl...
> There is no script here. Just right-click on the DB, click on All
> Tasks->generate SQL script.
> As for the filegoups, you are looking at a fair bit of work, since you now
> need to migrate your existing tables to this filegroup, and that's a rebuild
> of those tables.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "FARRUKH" <farrscorpio77@.hotmail.com> wrote in message
> news:055BC3BC-89AE-4424-95B0-A3CE72FA7AB3@.microsoft.com...
> I dont get this request daily. Actually this is the first time i get this
> request. I dont have any script. would you like to share ur script? thanks
> "Tom Moreau" wrote:
>
>
|||In a case like this, BCP MIGHT be a workable solution.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:D39370AC-E225-4DAB-97C7-753FA5D4B378@.microsoft.com...
> ... also, it isn't obvious how to get a backup of a filegroup available,
> unless you also have backup of the rest of the database (which makes the
> filegroup backup kind of ... moot). In short, filegroup backup should only
> be done with a very good understanding about backup in SQL Server and what
> it does and does not give you. :-)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:uQgDLDnmIHA.4536@.TK2MSFTNGP06.phx.gbl...
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

Backup question

Hello All,
I have a database that I am currently performing backup and incremental
backups.
If I were to add an extra table to the database or modify an existing table
with a few columns, would that imply that I would need to perform a full
back.
ThanksOnly if you don't want to wait for the next backup - modifying a table
is like making any other change in the database. If you've made a large
number of changes which would take some time to redo manually, and if
your database isn't very big, it might be worth making a backup so that
in the worst case you don't have to reapply the changes by hand. But
apart from that there are no special considerations.

Simon

Backup only one table

Hi
Does anyone know how to backup just one table (or selected tables) in
SQL2000?
Any help will be appreciated.
Thanks
CraigYou can't do that using BACKUP/RESTORE (well, you can put them on their own filegroups, but your
restore options are severely limited). How about using BCP/DTS etc ?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Craig Bryden" <craig@.ch.co.za> wrote in message news:Ozo3oFuaDHA.3444@.tk2msftngp13.phx.gbl...
> Hi
> Does anyone know how to backup just one table (or selected tables) in
> SQL2000?
> Any help will be appreciated.
> Thanks
> Craig
>

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:

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
>> > >
>> >
>> >
>>

Backup location

From backupset table in msdb we found that there is a baclup done by user 'N
T
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
ThanksFYI, 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...
user[vbcol=seagreen]
DISK[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:

> 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:
>|||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
>

backup history: 3d party vendor

Hello,
It seems that the system table [backupset] does *not* contain backups ma
de by our 3d party backup
tool (Veritas), but only backups made by the SQL Server tools (Q.A., Agent c
ontrolled Tasks...).
Is this true?
How can I query the backup history of the 3d party tool?
(SQL S. 2000)
Thank You
JoachimJoachim
Please refer to
backupfile, backupmediafamily, backupmediaset, backupset, restorefile,
restorefilegroup, and restorehistory.
"Joachim Hofmann" <speicher@.freenet.de> wrote in message
news:4056CD31.45AC9D4B@.freenet.de...
> Hello,
> It seems that the system table [backupset] does *not* contain backups made[/co
lor]
by our 3d party backup
> tool (Veritas), but only backups made by the SQL Server tools (Q.A., Agent
controlled Tasks...).
> Is this true?
> How can I query the backup history of the 3d party tool?
> (SQL S. 2000)
> Thank You
> Joachim|||Uri Dimant wrote:
> Joachim
> Please refer to
> backupfile, backupmediafamily, backupmediaset, backupset, restorefile,
> restorefilegroup, and restorehistory.
Thanks, I think I found the jobs. What really confuses me: The columns with
"software" in their name
always contain 'Microsoft SQL Server', in spite of the backup was made by th
e 'Veritas' Tool.
i.e:
select distinct software_name
from backupmediaset
Joachim