Solved

transaction log

Posted on 1998-09-28
3
257 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
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.

920 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

13 Experts available now in Live!

Get 1:1 Help Now