We will perform backup restore before cutover and will perform last log backup. How to save time from steps 3-6.

All,

As I was concerned about maintenance of 2 TB of database after upgrade to 2014. Came up with below plan to avoid.

1. Install SQL Server 2014 SP1

2. Restore 2008...

Thanks Gail,

update statistics I want to perform after upgrade to 2014. I was looking for other options to not to spend more time on this.

Yes we are working on capturing...

Thanks Alan,

Considering the cutoff time, it is very difficult to get big window for the maintenance. As update stats degrades the performance I am looking for other options.

Can this option...

The reason is Data Center A owned by Company X and Data Center B owned by Company Y, they are on different domains. At the most we can have Ports...

I am not clear.

Can I configure mirroring on 2 node cluster having 2 instances with primary database on one instance (InstanceA) and mirror database on one instance (InstanceB).

Thanks in...

I have question related to this topic.

I want to have 2 node cluster. Node 1 will have instanceA, Database ABC, Node 2 will have instanceB, Database ABC. Can I configure...

Hello Gail,

Thanks for the response.

Regards,

Hello Jeff,

Here are the details:

Each partationed table have 4 indexes, each index has 16 partations. Each index partation is on one file group (4 partations are sitting on one file...

Thank you Ed for the info.

Regards,

Pawana Paul

Hello Ed,

Looks like this session is to attend inperson. Is it available online by any chance?

Regards,

I am in Bay Area, CA. Please let me know details on attending his lecture.

Regards,

Hello Ed,

Please let me know what it would take to attend Jeff's lecture.

Thanks in advance.

Hello Ed,

Please let me know what it would take to attend Jeff's lecture.

Thanks in advance.

Thank you so very much Jeff. This info. helps.

Is it possible to share 2 hours lecture you written on this topic? Please send me on pawana.paul@gmail.com, if possible.

Thanks...