SCOM and biztalk are not the same thing. I have never seen a recommendation to to set maxdop to 1 for SCOM, so I would not do that.

SCOM is an...

if you use shrinkfile rather than shrinkdatabase you can specify whatever size you want. Limitation is amount of data in data file and whatever the size of your first 2...

without auditing set up then no, but that action would be in the default trace under eventclass object:altered, object type DB.

It does not tell you exactly what was done, but...

Express12 (1/16/2014)

---

Our issue is this. Our vendor lists SRDF as their recommended D/R solution. We opted to use SQL 2008 R2 Database Mirroring. The SQL DB mirror...

MysteryJimbo (1/16/2014)

---

Not necessarily. You can add...

shrinking of the log file does not affect index fragmentation, only data file shrinking does that.

Shrinking of the log file is usually bad as it then has to grow again...

Initial size in SSMS is somewhat of a misleading term. for a user database it changes in SSMS when the file size changes, for tempdb it does not.

The DB only...

learn how to make your own hawaiian shirts?

as this has had no replies I must assume that either

a) it is a solution looking for a problem

b) not enough people are on SQL2012 for long enough to...

I had this situation a few years back on a database (2005 standard) that has now reduced dramatically in size but at its peak was over a terabyte, mostly consisting...

surprised indexdefrag even works

how much log does the reorganise use? the DB should at least checkpoint when the log gets to 70% full. Does dbcc opentran show the reorganise as...

because the distributor does not contain the actual data. Distributor and publisher are often the same server as well.

ricardo_chicas (1/9/2014)

---

on a test environment I created a copy of that database, after 12 hours trying to drop the index it failed due to space on the log file, it...

I'd be loathe to drop a PK constraint on an active system and the OP specified this is a 24/7 system so downtime is an issue.

recommended way is

distributor

publisher

subscriber

disable replication jobs whilst applying to distributor

replication will automatically be suspended when doing the publisher and subscriber