Re: backup

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka@reproms.si)
Date: 12/16/02 

From: "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@reproms.si>
Date: Mon, 16 Dec 2002 10:36:39 +0100

Gerhard,

SQL Server 7.0 & 2000 backup does not support single-table backups. The
lowest level is physical file of the database. You can use Data
Transformation Services to export specific tables. In scheduled jobs, you
can always include execution od a stored procedure in one step and backup or
execution of DTS package in next step, so yes, you can execute a SP before
backup / DTS. 

-- 
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Gerhard Kashofer" <gerhard.kashofer@esa-at.at> wrote in message
news:037c01c2a4c8$7feb3290$d2f82ecf@TK2MSFTNGXA09...
> Hi,
> somebody told me that sql server backup can be configured,
> that it exports data (cut out) of various tables.
> Is that true, and how does it work?
> Is there a way to let sql server execute a stored
> procedure before (after) backup?

Relevant Pages

  • Re: How to capture SQL statement messages in DTS log file
    ... I have several SQL Server 2000s and a couple of SQL Server 2005 servers ... Then instead of PRINT in your DTS package, ... The execution of the following DTS Package succeeded: ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.dts)
  • Executing a DTS package from a Web application.
    ... Can a SQL Server 2000 DTS Package be run from a Web application? ... The SQL Server database is not local. ... Package Execution Lineage: ...
    (microsoft.public.sqlserver.dts)
  • RE: Isolating a DTS package
    ... you can create a DTS package status table that gets logged to ... at the beginning and the end of your DTS package execution. ... In SQL Server 2005, we will have a DTS Service that will allow us to monitor ...
    (microsoft.public.sqlserver.dts)
  • Re: Need to open vaious mdb files in sequence
    ... Enter as many MDB full pathnames as you like. ... Typically that Backup tree begins at ThisDrive:\ThisFolder\BAckups\... ... on each file is appended to the log just before execution. ... opens. ...
    (microsoft.public.access.modulesdaovba)
  • Re: [opensuse] Re: A BIG "show stopper" for openSUSE at the corporate level anyway!!
    ... Which is great until that backup fails. ... change the execution permission. ... Only the last case may kind of "require" on-access scan, ... discussion should not happen here, but on a kernel developer's list, ...
    (SuSE)