Solved

transaction log

Posted on 1998-09-28
3
237 Views
Last Modified: 2010-03-19
how do i DUMP a log?
0
Comment
Question by:bufordk
3 Comments
 
LVL 2

Accepted Solution

by:
Jim_SQL earned 10 total points
ID: 1090312
Hi,
to clear it out:
     dump transaction DBName with no_log

to dump to a device:
     dump transaction DBName to DumpDevice

For more info do a search on "Dump Statement" in books online.

Hope this helps.
Jim

0
 

Author Comment

by:bufordk
ID: 1090313
the dump statement in the books shows it in c++ and V.B.
i was running

dump transaction (dvname_dev#)
how do i dump to a device and what device would it be? do i create it?
0
 
LVL 2

Expert Comment

by:connex
ID: 1090314
DUMP TRANSACTION DBTest to DISK = 'C:\TRANS.DMP'
e.g.

Or to a device you create.
It's all eplained in the DUMP-Help page in Transact SQL-Help

0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now