Thanks Gila...I tested it in bulk logged recovery model..

The PIT recovery is possible...

small doubt is sql server consider the below statement is bulk insert?

insert into pittest values (1,'stlg')

GO

Thanks...

i do not understand "workloss exposure" comments on the link..

--these

If the log is damaged or bulk-logged operations occurred since the most recent log backup, changes since that last backup must...

It is for Transactional Replication( wihtout updatable subscription)

William,

Please advice..

MY SCRIPT will not give any result after my change ..my job status still running how much time it will take to complete..

attached my script

the extension should be .ps1...

I have created a job once TLog happened then immediately my sub plan job execute with Shrink log job.

So my TLog backup is in limited size other wise the...

i am not able to configured it in my server..please give simple steps one by one to execute

I have followed like...

I have executed script in my server (cre_sp_Mail_DB_Sizediffs.sql) under MonitorDB...

hi ,

can I set file growth to 10GB...I have every one hour log backup is there.

my TLog comming arround 10gb

we have a dataware house db and number of transactions going on and we have every one hour TLog but the log file of that dB growing huge size

Thanks for your reply

is there any way to rebuild single db

What statement causes execution plan gets created and stored in cached in memory. ...Is it all queries or limited?

begin tran

insert into test (id,name,a) values (1,'aa','hjh')

waitfor delay '00:00:10'

commit tran

i tested like above

after i ran below ...

SELECT t.[text]

FROM sys.dm_exec_cached_plans AS p

CROSS APPLY sys.dm_exec_sql_text(p.plan_handle) AS t

WHERE t.[text] LIKE '%insert into...

without scheduling the job..hoe can i get alert

I CAN NOT GET ANY ALERT...THE ARTICLE IS NOT MUCH CLEAR TO UNDERSTAND LIKE NEW DBAS...

AND PLEASE GIVE ME ONE EXAMPLE...BY USING UR SCRIPT TO GET ALERT..

or I can not...