It happened to be few times. I use the below script and it worked for me at all Times.

Execute SP_ReplicationDbOption Adventureworks2012,Publish,true,1

GO

DBCC ShrinkFile(Adventureworks2012_log,1, Truncate only)

GO

Execute SP_ReplicationDbOption Adventureworks2012,Publish,false,1

GO

Limitations and Restrictions

If other users are connected to the database at the time that you set the database to single-user mode, their connections to the database will be closed without...

Hi,

Yes its a Store proc which gets called remotely and the restore happens through network. Now if I have to add a another step or...

Oh forgot to answer your first question. I was curious only about remote desktop connections

Well Technically not more than 2 people can be active on our boxes. But I see 2 in active and atleast 5-6 disconnected.

1) What are the disadvantages if a...

you might want to be a little careful while playing around with sys databases. If msdb is not online and you recycle the SQL services, your tempDB will also be...

Hi All, thanks for the inputs..

SELECT StartDateTime=DATEADD(day, DATEDIFF(day, 0, WQ.WorkQueueEndWorkDate), 0),WQ.WorkQueueEndWorkDate as 'EndDateTime',

DATEDIFF(Hour, DATEADD(day, DATEDIFF(day, 0.0, WQ.WorkQueueEndWorkDate), 0.0), WQ.WorkQueueEndWorkDate) as 'RunTime(Hours)'

This works now. But not quite optimal quite...

from the below Query, I need a 3rd column which would calculate Runtime(Hours) from 12:00 AM to WorkQueueEndWorkDate.

DECLARE @XHours INT = 2160

SELECT StartDateTime=DATEADD(day, DATEDIFF(day, 0, WQ.WorkQueueEndWorkDate), 0),WQ.WorkQueueEndWorkDate as 'EndDateTime'

FROM CloudBIMetaData..WorkQueue...

That was real easy. Now all I need is to get the Run time form StartDateTime to EndDateTime in hours.

Ok. Sorry for confusion. Lets start fresh here.. Below is the query that I wrote to get the 90 day processing times of one our jobs.

DECLARE @XHours INT =...

Thanks fro the assistance. I need the WorkQueueStartWorkDate to be starting at 12:00 AM with respect to the WorkQueueEndWorkDate. I'm using the below where clause but am I do not...

SELECT CAST(CONVERT(VARCHAR(10), GETDATE(), 120) + ' 12:00:00' AS DATETIME)

seems to working good but from the below result set, I need the StartDateTime to be on the same date as EndDateTime....

How can I check the NIC Connections between the server?

If I copy the backup file on to the local machine , I can restore it successfully. But that now how...

Thanks Gila Monstor. I solved it finally.

Initial Situation: Log space used 236 GB, 99.9% space used and 18328 VLFs. We still had 50 GB left on the mount point.

Steps...

just use this to make our lives simpler.

select * from msdb.dbo.restorehistory