Backup Restore Tables inside a database

Can back up and restore a complete database, but it appears that I do not
have the options to restore individual tables inside the database. Is there
a way to restore at the table level?
Thanks,
Keith
You can't restore an individual table with SQL Server 7 or
SQL Server 2000. You would need to restore the backup to
another server or database and then copy the table from the
restored database.
-Sue
On Tue, 1 Mar 2005 17:01:02 -0800, "Keith"
<Keith@.discussions.microsoft.com> wrote:

>Can back up and restore a complete database, but it appears that I do not
>have the options to restore individual tables inside the database. Is there
>a way to restore at the table level?
>
>Thanks,
>Keith
|||This is useful when you have a lot of data in your table. To do this your
database should be organized in primary and secondary filegroups. The large
tables should be on their own filegroup. In such cases you can backup and
restore a single file group (+ primary) and this way you may get just the
table you need.
Look for "Partial Database Restore Operations" in books online
Arun
"Keith" wrote:

> Can back up and restore a complete database, but it appears that I do not
> have the options to restore individual tables inside the database. Is there
> a way to restore at the table level?
>
> Thanks,
> Keith
>

Backup Restore Tables inside a database

Can back up and restore a complete database, but it appears that I do not
have the options to restore individual tables inside the database. Is there
a way to restore at the table level?
Thanks,
KeithYou can't restore an individual table with SQL Server 7 or
SQL Server 2000. You would need to restore the backup to
another server or database and then copy the table from the
restored database.
-Sue
On Tue, 1 Mar 2005 17:01:02 -0800, "Keith"
<Keith@.discussions.microsoft.com> wrote:

>Can back up and restore a complete database, but it appears that I do not
>have the options to restore individual tables inside the database. Is ther
e
>a way to restore at the table level?
>
>Thanks,
>Keith|||This is useful when you have a lot of data in your table. To do this your
database should be organized in primary and secondary filegroups. The large
tables should be on their own filegroup. In such cases you can backup and
restore a single file group (+ primary) and this way you may get just the
table you need.
Look for "Partial Database Restore Operations" in books online
Arun
"Keith" wrote:

> Can back up and restore a complete database, but it appears that I do not
> have the options to restore individual tables inside the database. Is the
re
> a way to restore at the table level?
>
> Thanks,
> Keith
>sql

Backup Restore Tables inside a database

Can back up and restore a complete database, but it appears that I do not
have the options to restore individual tables inside the database. Is there
a way to restore at the table level?
Thanks,
KeithYou can't restore an individual table with SQL Server 7 or
SQL Server 2000. You would need to restore the backup to
another server or database and then copy the table from the
restored database.
-Sue
On Tue, 1 Mar 2005 17:01:02 -0800, "Keith"
<Keith@.discussions.microsoft.com> wrote:
>Can back up and restore a complete database, but it appears that I do not
>have the options to restore individual tables inside the database. Is there
>a way to restore at the table level?
>
>Thanks,
>Keith|||This is useful when you have a lot of data in your table. To do this your
database should be organized in primary and secondary filegroups. The large
tables should be on their own filegroup. In such cases you can backup and
restore a single file group (+ primary) and this way you may get just the
table you need.
Look for "Partial Database Restore Operations" in books online
Arun
"Keith" wrote:
> Can back up and restore a complete database, but it appears that I do not
> have the options to restore individual tables inside the database. Is there
> a way to restore at the table level?
>
> Thanks,
> Keith
>

Backup Jobs

I have created 4 backup jobs inside of Enterprise Manager. For 3 of them I
created a backup device first and then the backup job. For 1 of them I just
created the backup job. I would like to delete the job that has no backup
device and would also like to edit the other 3 jobs. I do not see how to do
this. I can see my backup devices but not the jobs themself.
Can someone tell me how I can delete the one job and edit the remaining 3?
Thanks
JohnnyDid you check SQL Server Agent - Jobs ?
"Johnny Wright" wrote:

> I have created 4 backup jobs inside of Enterprise Manager. For 3 of them
I
> created a backup device first and then the backup job. For 1 of them I ju
st
> created the backup job. I would like to delete the job that has no backup
> device and would also like to edit the other 3 jobs. I do not see how to
do
> this. I can see my backup devices but not the jobs themself.
> Can someone tell me how I can delete the one job and edit the remaining 3?
> Thanks
> Johnny|||Umut
No I did not. Thanks for the quick response.
Ahhh such a simple thing when you know how..
Johnny
"Umut Nazlica" wrote:
[vbcol=seagreen]
> Did you check SQL Server Agent - Jobs ?
>
> "Johnny Wright" wrote:
>

Backup Jobs

I have created 4 backup jobs inside of Enterprise Manager. For 3 of them I
created a backup device first and then the backup job. For 1 of them I just
created the backup job. I would like to delete the job that has no backup
device and would also like to edit the other 3 jobs. I do not see how to do
this. I can see my backup devices but not the jobs themself.
Can someone tell me how I can delete the one job and edit the remaining 3?
Thanks
Johnny
Did you check SQL Server Agent - Jobs ?
"Johnny Wright" wrote:

> I have created 4 backup jobs inside of Enterprise Manager. For 3 of them I
> created a backup device first and then the backup job. For 1 of them I just
> created the backup job. I would like to delete the job that has no backup
> device and would also like to edit the other 3 jobs. I do not see how to do
> this. I can see my backup devices but not the jobs themself.
> Can someone tell me how I can delete the one job and edit the remaining 3?
> Thanks
> Johnny
|||Umut
No I did not. Thanks for the quick response.
Ahhh such a simple thing when you know how..
Johnny
"Umut Nazlica" wrote:
[vbcol=seagreen]
> Did you check SQL Server Agent - Jobs ?
>
> "Johnny Wright" wrote:

Backup Jobs

I have created 4 backup jobs inside of Enterprise Manager. For 3 of them I
created a backup device first and then the backup job. For 1 of them I just
created the backup job. I would like to delete the job that has no backup
device and would also like to edit the other 3 jobs. I do not see how to do
this. I can see my backup devices but not the jobs themself.
Can someone tell me how I can delete the one job and edit the remaining 3?
Thanks
JohnnyDid you check SQL Server Agent - Jobs ?
"Johnny Wright" wrote:
> I have created 4 backup jobs inside of Enterprise Manager. For 3 of them I
> created a backup device first and then the backup job. For 1 of them I just
> created the backup job. I would like to delete the job that has no backup
> device and would also like to edit the other 3 jobs. I do not see how to do
> this. I can see my backup devices but not the jobs themself.
> Can someone tell me how I can delete the one job and edit the remaining 3?
> Thanks
> Johnny|||Umut
No I did not. Thanks for the quick response.
Ahhh such a simple thing when you know how..
Johnny
"Umut Nazlica" wrote:
> Did you check SQL Server Agent - Jobs ?
>
> "Johnny Wright" wrote:
> > I have created 4 backup jobs inside of Enterprise Manager. For 3 of them I
> > created a backup device first and then the backup job. For 1 of them I just
> > created the backup job. I would like to delete the job that has no backup
> > device and would also like to edit the other 3 jobs. I do not see how to do
> > this. I can see my backup devices but not the jobs themself.
> >
> > Can someone tell me how I can delete the one job and edit the remaining 3?
> > Thanks
> > Johnny