thks Wayne --> Re: bkup log to tape + DTS/BULK INSERT
From: maxzsim (anonymous_at_discussions.microsoft.com)
Date: 08/26/04
- Next message: Stan Rozendal: "Re: SELECT COUNT(*) returning wrong value"
- Previous message: maxzsim: "thks Dejan --> url or template queries"
- In reply to: Wayne Snyder: "Re: bkup log to tape + DTS/BULK INSERT"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 25 Aug 2004 17:07:59 -0700
>-----Original Message-----
>Yes, a normal log backup as you have syntaxed will
truncate the log. (clear
>the used entries in the log so that space can be re-used.)
>
>You can use bulk insert or BCP ( in bulk logged recovery
mode) which
>reduces logging... Bulk insert is the way to go... (
Unless you need
>parallel loads - then use BCP.)
>
>
>--
>Wayne Snyder, MCDBA, SQL Server MVP
>Mariner, Charlotte, NC
>www.mariner-usa.com
>(Please respond only to the newsgroups.)
>
>I support the Professional Association of SQL Server
(PASS) and it's
>community of SQL Server professionals.
>www.sqlpass.org
>
>"maxzsim" <anonymous@discussions.microsoft.com> wrote in
message
>news:c75f01c48a3e$aea85790$a501280a@phx.gbl...
>> Hi ,
>>
>> I have this backup statement
>>
>> backup log db_abc to [abc_tape_drive] with NO FORMAT ,
>> noINIT
>>
>> is it by default that a truncate will be performed to
>> clear away the inactive entries for the log files ?
>>
>>
>> Can i actually use DTS/BULK INSERT to do transfer of
data
>> and yet do not want the txn log to log these records
(e.g
>> i am moving tbls by tbls across to another db and not
>> using the sp_attachdb sp)??
>>
>> thks & rdgs
>
>
>.
>
- Next message: Stan Rozendal: "Re: SELECT COUNT(*) returning wrong value"
- Previous message: maxzsim: "thks Dejan --> url or template queries"
- In reply to: Wayne Snyder: "Re: bkup log to tape + DTS/BULK INSERT"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
