Yes Gail

Using Extended Events only we get the complete list of the last week dead lock

My team lead was asking the list of deadlocks still dead lock are available...

Existing maintains job only.

Hi

thanks for your reply..

but i m getting

database name mdfsize ldf size but i need current size of the database also could you please help...

Hi Anthony,

Thansk for the reply...

the table are not appearing how can i select the table..we dont know the table names

restore of the database is not prob

But my boss is...

I have checked errorlog,event log, windows event logs but i did not find the root cause why tables are missing how can i find out the reason for the above...

How can i check what went wrong in the database because user tables are missing.

i m looking for the report

No i m using Policy base mangement here .

Thanks for your conformation.

Hi

at that time we will do in this way any thing wrong please correct me

select lp.primary_server, sd.name, case when lp.primary_database IS NOT NULL then 'Yes' else 'NO'...

Hi Team,

I got this answer Thanks your for your suggestion.,

select lp.primary_server, sd.name, case when lp.primary_database IS null then 'Yes' else 'No' end LSConfigured

From

Master.dbo.sysDatabases SD

left join msdb.dbo.log_shipping_monitor_primary LP on...

Hi Team,

as per your suggestion i have created below script but it is giving error

select

LP.Primary_Database as LogshippingDB

,sd.Name AS NotLogshippingDB

From msdb.log_shipping_monitor_primary LP

Inner Join Master.dbo.sysDatabases SD on dbid.SD = dbid.sd

inner...

Hi Anthony

Thanks for your reply

How can we find databases which are not configured in logshipping on a server

Tx

Hi Team,

How can we find out the database is logshipping or not ?

Tx

U can't migrate please follow below link

http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/4dddd9e9-a34f-43d0-89bc-86672bebf52f

Tx