I don't get the combination of your previous two replies :crazy:

As long as I have enough space, I don't care about it during any migration.

It may indeed consume your resources....

did you specify the proxy account for the job step ?

Did you play around with the Microsoft Migration Assistant for Oracle ( to sqlserver ) ?

Always nice to give it a try .... this is free MS software 🙂

Have a...

Here's an alternative using alerts ...

help to tighten use of cmdshell or sp_start_job[/url]

You could also set up a SSB solution for it.

You'll have to shink the current file(s) because, as you state, you didn't configure your luns big enough to host that size. ( Which is IMHO awkward )

Check you current...

Keep. In mind that only makes. Sense for tables having a clustering index and for non-clustering indexes.( reindex)

Did someone use two single quotes in stead of double quotes ?

It depends.

For tables that are designed to not being referred to by other tables, a PK may not make sence.

That is a design issue.

However, it is advised a table has...

Correct George.

This is the ref .. http://technet.microsoft.com/en-us/library/ms179301(SQL.90).aspx

It depends ....

http://blogs.technet.com/b/askperf/archive/2008/03/25/lock-pages-in-memory-do-you-really-need-it.aspx

Yes.

Order of processing is important with AWE.

First set your max server memory and only then enable AWE !

In your case (8GB total allocated VM ram) You would need /3GB /PAE...

Just a way to import your default trace and query it... see attachment

( this one reports auto grow events ,should be peace of cake to have it filter detach or...

Did you notice your first query has a "distinct" keyword ?

Guess what that does.

Win 2008R2 ... Do you have the needed windows authority to rename files ?

(one of the security changes with win2008R2 en SQL008(r2))