There must be any reason.. some immediate action done like

1 data migration (heavy DML on related tables) which...

shindle 17293 (11/7/2013)

---

I am cutrently using the SELECT INTO... FROM... method but this doesn't create the indexes etc. on the backup table so it would require some extra manual steps...

Maddave (11/7/2013)

---

A number of our developers may execute changes within applications and then need to restore a database back to a starting point multiple times on a test system, and...

Thanks but can you explain how the contention can be avoided by NUMA ?

you also need to increase value of threshold to avoid early parallelism occurence

is it ? :pinch:

Did you find the issue ?

Did you miss colon (:) before your drive letter I it should be

'I:\MSSQL\log\MyDW.ldf'

chandan_jha18 (11/7/2013)

---

its also perfect way to manage the...

IF you handle the records in bunches .. it will...

i have experinced it in recent times. that same...

Rebuild all the indexes (preferably clustred ones) just before you are making the database read-only

i suspect with large amount of data ..your query might get blocked ..

you need 5 different results from 5 different filter(mentioned above) so your queries will work as expected.

you need to compare exec plan in both the scenarios.