Dan11 (10/31/2014)

---

Thanks for your reply. in Simple English, if I update to SP3, everything comes along right i.e. SP1, SP2 AND cumulative ? Next, Is it OK to update SP3...

SQL Server 2008 R2 service packs are cumulative and can be used to upgrade all releases of SQL Server 2008 R2 to Service Pack 3. SQL Server 2008 R2 Service...

It's always depends:

PageCountLevel:Set a size, in pages.

Indexes with fewer pages are skipped for index maintenance. The default is 1000 pages. This is based on Microsoft’s recommendation...

You are free to change...

I think that Ola's index maintenance have a default of PageCountLevel=1000.

In your scripts it's = 8 and that 's why you get so many records.

Good Morning, thank you very much for all your great suggestions.

Best Regards.

Thank you Michael, in fact the risk is very low due to the fact that I'll take a full db backup before index maintenance.

I have done my tests and I can say that the log do increase rapidly even in BULK-LOGGED recovery model.:exclamation:

Due to the fact that our users stop to work at...

Thank you very much for all your valuable advice, I really appreciated.

The index maintenance procedure is a mix of rebuild and reorganization, its really depends of the results of the...

Leo, thank you very much for your contribution.

The only problem may be is that somewhere in the master db there is an information that this was a cluster sql server.

I...

Absolutely yes.

I'll try it and maybe it will be intreresting for some people to know how it goes, so I'll post my results in the next weeks.

Thank you again for...

I found this reply from MVP Andrew J.Kelly, in another forum:

The database knows nothing of if it is or ever was in a clustered server or

not.

Andrew J. Kelly SQL...

Steve, thank you very much for your reply.

In fact this was also my concern, the cluster.

There is a very good article here:

http://vyaskn.tripod.com/moving_sql_server.htm

But it's not talking about cluster.

Could you please explain to me why?

Has anybody done the same thing?

My concern is because the old instance in the old data center is clustered and the new instance in the new datacenter will be non...

It's a MSCS Cluster, so no PTV available.

We would like to install a new single machine, same name, same parameters, same memory, same disks, same path, same everything... in the...