Re: Backup...
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 05/26/04
- Next message: tvent: "SQL Server 7.0 Memory Grants Pending causing hang..."
- Previous message: Aaron Bertrand [MVP]: "Re: Actual number of bytes used"
- In reply to: Tina: "Re: Backup..."
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 25 May 2004 19:00:19 -0600
You need to remove the curly braces. Try using:
dbcc log(DB1, 3)
-Sue
On Tue, 25 May 2004 16:10:19 -0700, "Tina"
<anonymous@discussions.microsoft.com> wrote:
>Hi Gregory,
>
>Thanks for the reply. I tried the following commands
>I get the error "[Microsoft][ODBC SQL Server Driver]
>Syntax error or access violation"
>
>DBCC log ({DB1},{3})
>
>DBCC log ({dbname=DB1},{type=3})
>
>DBCC log ( {DB1}, type={3)) where DB1 is the name of my
>database.
>
>What am I doing wrong?
>
>I am running it using Query Analyzer.
>
>Thank you,
>-Tina
>
>
>
>>-----Original Message-----
>>SQL Server keeps track of updates to the data via the
>TRANSACTION LOG.
>>There are a number of third party tools available to
>read through the
>>TRANSACTION LOG. One such product is LOG EXPLORER by
>Lumigent
>>(http://www.lumigent.com/).
>>
>>You might also try using the undocumented DBCC LOG
>command
>>
>>Here is schetchy documentatrion.
>>
>>The following undocumented command will do the trick.
>>
>>
>>
>>DBCC log ( {dbid|dbname}, [, type={0|1|2|3|4}] )
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>PARAMETERS:
>>
>>
>>
>> Dbid or dbname - Enter either the dbid or the name of
>the database
>>
>> in question.
>>
>>
>>
>> type - is the type of output:
>>
>>
>>
>> 0 - minimum information (operation, context,
>transaction id)
>>
>>
>>
>> 1 - more information (plus flags, tags, row length)
>>
>>
>>
>> 2 - very detailed information (plus object name,
>index name,
>>
>> page id, slot id)
>>
>>
>>
>> 3 - full information about each operation
>>
>>
>>
>> 4 - full information about each operation plus
>hexadecimal dump
>>
>> of the current transaction log''s row.
>>
>>
>>
>>by default type = 0
>>
>>
>>
>>
>>Best way to easily identify updated records is of course
>to design a
>>LAST_UPDATE_DATE column into your table design, but of
>course I don't see to
>>many folks doing this these days.
>>
>>--
>>
>>---------------------------------------------------------
>-------------------
>>---------------------------------------------------------
>-------------------
>>----
>>
>>Need SQL Server Examples check out my website at
>>http://www.geocities.com/sqlserverexamples
>>"Tina" <anonymous@discussions.microsoft.com> wrote in
>message
>>news:123cf01c44275$db2cf520$a501280a@phx.gbl...
>>> Is there a way to find out when the data in a table was
>>> last updated?
>>>
>>> How does Sql Server keep track of it?
>>>
>>> Thank you in advance,
>>> -Tina
>>>
>>
>>
>>.
>>
- Next message: tvent: "SQL Server 7.0 Memory Grants Pending causing hang..."
- Previous message: Aaron Bertrand [MVP]: "Re: Actual number of bytes used"
- In reply to: Tina: "Re: Backup..."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
