Gain

ramana3327 (10/3/2014)

---

Sorry for the repeated posts.

If that job is running the ssis package. How to start the process. Do we need to create that ssis package under the new...

Deal:cool:

You do need to fully test for performance. While some queries may perform worse, there are many cases where the query will perform much much better.

Look at my previous post.

And it is SQLRNNR. NOT LNNR;-)

No precautions that would be any different than moving the job any other way. The same considerations always have to be taken into account when you move a job....

You would have to change one of the plans to perform copy_only backups.

Before switching to a version to implement differentials, are you sure you will be able to get a...

My preference is to script it and execute the script on the new server - very easy and takes little time or effort.

sapsucker

Sheep

Useful information imho. It would be nice to have the msdn article on the topic clarified a bit.

Thanks for the update Steve.

sinew

Stefan Krzywicki (10/2/2014)

---

SQLRNNR (10/2/2014)

---

Stefan Krzywicki (10/2/2014)

---

SQLRNNR (10/1/2014)

---

Stefan Krzywicki (10/1/2014)

---

SQLRNNR (10/1/2014)

---

Thanks...

Stefan Krzywicki (10/2/2014)

---

SQLRNNR (10/1/2014)

---

Thanks Stefan....