job failure simulation

Question

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

ps. One Orange Chip Points: 29423 More actions · Answer 1

shanila_minnu (6/18/2009)
how can i create a job failure for testing in one server

create a dummy job with incorrect syntax and run it. It'll fail.

Also how can create a database and restrict the log size to a small value and make the logsize to get full by running an infinite transaction

switch off the auto growth option of the log file and keep the log file size to minimum and then start ur transaction. it'll be full soon.

EDIT: edited formatting of reply.

Pradeep Singh

Eswin SSCrazy Eights Points: 8320 More actions · Answer 2

Need more clarifications didn't exactly understand your need.

to restrict the growth of your log file

USE [master]

GO

ALTER DATABASE [DB_TEST] MODIFY FILE ( NAME = N'DB_TEST_log', MAXSIZE = 2147473408KB )

GO

Tanx 😀

shanila_minnu Hall of Fame Points: 3465 More actions · Answer 3

Hall of Fame

Points: 3465

June 18, 2009 at 12:53 am

thank u very much to all:-P