all groups > sql server dts > december 2004 >
You're in the

sql server dts

group:

urgent import/export or backup question



urgent import/export or backup question thaar
12/4/2004 4:39:05 AM
sql server dts: 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
Re: urgent import/export or backup question Allan Mitchell
12/4/2004 1:50:43 PM
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


[quoted text, click to view]

Re: urgent import/export or backup question rrnqfkor NO[at]SPAM search26.com
12/6/2004 2:44:11 AM
Re: urgent import/export or backup question Darren Green
12/7/2004 12:58:34 PM
In message <9370FDD0-4A5C-471D-B2A8-032EE71BBA97@microsoft.com>, thaar
<thaar@discussions.microsoft.com> writes
[quoted text, click to view]

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
AddThis Social Bookmark Button