Skip to Content
0
Aug 01, 2016 at 06:45 AM

Query to fill in your logs

35 Views

Experts,

We are into a testing scenario.

We have a 1TB database, with 65 gigs assigned for log device.

To find , how quick or what time would it take to your transaction log to get full.

Could you give me some minimally logged, or non logged operations / query in a loop or something.

As said, the idea being to fill the syslogs and, we get an errors messages of ran out of space. So that we and kill the SPID. ( Not to harm the system )

Regards,

Aji