right click the database, select reports - standard reports - disk usage. The space used in the data files will be a very good approximation of your backup size.

this query...

that would be expected, you are only allowed one mirroring endpoint.

see http://msdn.microsoft.com/en-gb/library/ms175883(v=sql.110).aspx

there is only one mirroring endpoint per instance, was that the question?

there should be a detail.txt file in c:\program file\microsoft sql server\100\setup bootstrap\log\somedateandtime stamp

see what errors are in the files in there

Also i believe it is not wise to post your...

TheSQLGuru (6/5/2014)

---

george sibbald (6/5/2014)

---

I have an app where the vendor recommends (nay insists) setting maxdop to 1 and cost threshold to 15, go figure.........

Is Dynamics AX a microsoft product, they...

I would only ever immediately consider dropping indexes with 0 reads, and even then never if the index enforces uniqueness.

I would have to have a very good reason to spend...

+1. thats the type of message they tend to produce in the errorlog.

Beware, if they are not copy_only backups...

I have an app where the vendor recommends (nay insists) setting maxdop to 1 and cost threshold to 15, go figure.........

Is Dynamics AX a microsoft product, they have a habit...

yes, or on a very wide column.

no feedback from op yet

whats the fill factor on the index?

remember the non-clustered index will also contain either an 8byte RID or the clustered index per row at the leaf level.

As Ed said, yes it would.

Jack Corbett (5/22/2014)

---

george sibbald (5/22/2014)

---

a large log file in itself will not lead to a larger backup as only enough of the log is backed up to allow...

no, sql is fully compatible with that OS and enterprise edition gives you access to all the features

some of the limitations will be OS dependant

http://msdn.microsoft.com/en-us/library/cc645993(v=sql.105).ASPX#Scalability

a large log file in itself will not lead to a larger backup as only enough of the log is backed up to allow for recovery during a restore. Therefore...