dear all,
i am new to this disscusion group, i have long period participations in
cisco and oracle ...etc disscussion groups. my question is:

i have windows 2003 server and ms-sql server 2000. using entriprise manager
i have backups and export/import. how can restore only one table as an
example from the sql-server and for specific date.
any info are apperaciated, and if there is a specific steps that should be
followed in the backup or import utilities /add on software for such issue i
also welcomed.

v. thanks for any reply


eng. thaar
Sr Network eng. and ORACLE DBA

If all you have is a SQL Server and a backup file then you need to restore
the whole backup and can then use DTS is you wish to move the data from the
restored copy to your real database.

As for "for a specific date". Depending how accurate you wanted to be would
depend on the backups you required but backups are the way forward again.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"thaar" <thaar (AT) discussions (DOT) microsoft.com> wrote

http://www.ardice.com/Computers/Soft...d-on_Software/

In message <9370FDD0-4A5C-471D-B2A8-032EE71BBA97 (AT) microsoft (DOT) com>, thaar
<thaar (AT) discussions (DOT) microsoft.com> writes
To protect your data you should be using regular backups, of the
appropriate types. DTS can move data between servers/databases/tables,
but don't rely on it to handle constraints intelligently. If this is a
concern you will need to write some extra SQL to do this work.

If you want object level recovery, talk to Imceda, their SQL Litespeed
product has this now I believe, as well as fast backups to compressed
files saving storage costs.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org