Re: urgent import/export or backup question

From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 12/07/04 

Date: Tue, 7 Dec 2004 12:58:34 +0000

In message <9370FDD0-4A5C-471D-B2A8-032EE71BBA97@microsoft.com>, thaar
<thaar@discussions.microsoft.com> writes
>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.
>

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

Relevant Pages

  • Re: Advice Requested : Disaster Recovery with 2 Drives (No Raid) with SQL Server 2008
    ... so we need frequent copies of the database for testing, ... Which drive for logfile backups? ... Why are you using Enterprise edition of SQL Server if you only have Std ... drives with no Raid. ...
    (microsoft.public.sqlserver.programming)
  • Critical SBS ActiveDirectory Problem
    ... using sharepoint (w/ SQL Server), ... deal when you have backups, but this is critical because I do not have ... Perhaps because I was running it in Directory Services Restore ...
    (microsoft.public.windows.server.sbs)
  • Re: Critical SBS ActiveDirectory Problem
    ... using sharepoint (w/ SQL Server), ... deal when you have backups, but this is critical because I do not have ... What will happen to my user mail files? ... Your user mail files are likely to be fine, although you may need to use ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL 2000 - Databases getting backed up multiple times
    ... SQL Server MVP ... kgboles a earthlink dt net ... There are external applications doing the backups. ...
    (microsoft.public.sqlserver.server)
Loading