Newbie Question - Table only Backup

I may be missing something... but I simply want to backup a single table from my DB inorder to export it to another server (via FTP)... is there a way to do this specifically in MS SQL 7 ' I want to save the backup on my desktop, for instance... and not into another DB on the server... am I clear or missing something..
Thanks !!Put the table on a different filegroup, since you can back up filegroups
separately. You can't back up tables separately.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Joe Mizrahi" <mizrahij@.finance.nyc.gov> wrote in message
news:00470D0D-6DC6-4A59-AEF9-80FAE5EA26A2@.microsoft.com...
> I may be missing something... but I simply want to backup a single table
from my DB inorder to export it to another server (via FTP)... is there a
way to do this specifically in MS SQL 7 ' I want to save the backup on my
desktop, for instance... and not into another DB on the server... am I clear
or missing something...
> Thanks !!|||Note that such a backup is possibly unusable for Joe's scenario. When
restoring an FG backup you have to do that into the same database from where
you took the backup and also apply all log backups taken since, up to
current point in time.
Joe,
another option is to export he data in the table, using such tools as BCP,
DTS etc.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:eIhT5OpvDHA.2408@.tk2msftngp13.phx.gbl...
> Put the table on a different filegroup, since you can back up filegroups
> separately. You can't back up tables separately.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
> "Joe Mizrahi" <mizrahij@.finance.nyc.gov> wrote in message
> news:00470D0D-6DC6-4A59-AEF9-80FAE5EA26A2@.microsoft.com...
> > I may be missing something... but I simply want to backup a single table
> from my DB inorder to export it to another server (via FTP)... is there a
> way to do this specifically in MS SQL 7 ' I want to save the backup on my
> desktop, for instance... and not into another DB on the server... am I
clear
> or missing something...
> > Thanks !!
>|||Ah, that's a good point. Yes, you could DTS the table to another database,
and backup from there. Or keep the table in its own separate database
permanently, I suppose.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:eCdyUSpvDHA.1512@.TK2MSFTNGP10.phx.gbl...
> Note that such a backup is possibly unusable for Joe's scenario. When
> restoring an FG backup you have to do that into the same database from
where
> you took the backup and also apply all log backups taken since, up to
> current point in time.
> Joe,
> another option is to export he data in the table, using such tools as BCP,
> DTS etc.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
>
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> news:eIhT5OpvDHA.2408@.tk2msftngp13.phx.gbl...
> > Put the table on a different filegroup, since you can back up filegroups
> > separately. You can't back up tables separately.
> >
> > --
> > Aaron Bertrand
> > SQL Server MVP
> > http://www.aspfaq.com/
> >
> >
> >
> >
> > "Joe Mizrahi" <mizrahij@.finance.nyc.gov> wrote in message
> > news:00470D0D-6DC6-4A59-AEF9-80FAE5EA26A2@.microsoft.com...
> > > I may be missing something... but I simply want to backup a single
table
> > from my DB inorder to export it to another server (via FTP)... is there
a
> > way to do this specifically in MS SQL 7 ' I want to save the backup on
my
> > desktop, for instance... and not into another DB on the server... am I
> clear
> > or missing something...
> > > Thanks !!
> >
> >
>

Newbie Print Layout problem

When I export a file to any medium (PDF/Excel) I try, the layout is not the
same as what the layout is in the Layout tab.
There's a whole lot of space between the columns, so they don't all fit on
the page (Portrait style), therefore, the PDFs and Excel sheets are way off
Any hints here that I can use to make the print layout look like what I
design in the Layout Tab of the Reporting Services 2005 Design Area?On Jan 8, 11:03 am, "Elmo Watson" <s...@.here.com> wrote:
> When I export a file to any medium (PDF/Excel) I try, the layout is not the
> same as what the layout is in the Layout tab.
> There's a whole lot of space between the columns, so they don't all fit on
> the page (Portrait style), therefore, the PDFs and Excel sheets are way off
> Any hints here that I can use to make the print layout look like what I
> design in the Layout Tab of the Reporting Services 2005 Design Area?
You should be able to start here.
Layout tab >> Report drop-down >> Report Properties... >> Layout tab.
If this does not compact the report enough, you could try putting
multiple report controls (i.e., table control(s), matrix control(s),
textbox(es), etc) into a rectangle. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Newbie - Advice pls !

Hello

I am running a HR database on a 2K SQL 2000 box which administrators have no access to in the near future - I am needing to export certain data from the db to another 2K SQL 2000 box for use in the company phonelist etc.

I am looking at running the task say at midnight every night, the query will replace the data on the destination server.

I know this sounds very vague - is DTS the correct medium for the job ?

Can anyone point me in the right direction on this ?

Thanks in advance !:confused:yeah, i would say DTS is the way to go....just schedule the update every night...do you want to overwrite the data on the destination server or simply append to it? If you want to append an leave the existing data there dont forget, use insert rather than update.

Hope this help

NewB- Selected Data transfer from tables

New to the forums and SQL and need help to solve a tech support issue.
I need to export selected data from one table into a new table.

fields: NAME_LAST, NAME_FIRST, PURCHASE_ACCOUNT_BALANCE, EVENT_CREDIT_BALANCE
from table: C_CUSTOMER
where: EVENT_CREDIT_BALANCE, PURCHASE_ACCOUNT_BALANCE > 0

into new table: APPLE_CUSTOMERS

Any help would be great. My iterations haven't worked and I don't have my SQL book here and my searches aren't helping.
I am using interbase.
Thanksinsert into apple_customers(NAME_LAST, NAME_FIRST, PURCHASE_ACCOUNT_BALANCE, EVENT_CREDIT_BALANCE
) select NAME_LAST, NAME_FIRST, PURCHASE_ACCOUNT_BALANCE, EVENT_CREDIT_BALANCE
from C_CUstomers where
EVENT_CREDIT_BALANCE>0 AND PURCHASE_ACCOUNT_BALANCE > 0

or

insert into apple_customers(NAME_LAST, NAME_FIRST, PURCHASE_ACCOUNT_BALANCE, EVENT_CREDIT_BALANCE
) as select NAME_LAST, NAME_FIRST, PURCHASE_ACCOUNT_BALANCE, EVENT_CREDIT_BALANCE
from C_CUstomers where
EVENT_CREDIT_BALANCE>0 AND PURCHASE_ACCOUNT_BALANCE > 0|||Thanks, I was so close...|||Go to MS-Access.
Goto tables pane.
Right click->Import
Choose ms excel as Files of type. Specifiy the file and import the data
No rename the table name into all CAPITAL LETTERS

Right click on newly created table.
Export.
Choose ODBC Databases as Files of Type.
Choose the DSN . (If you havent created then goto control panel->administrative->ODBC. create as System DSN)

and then you are done
Cheers