Sorry - correction - yes- it shows what is configure in CATCH.

Any help is much appreciated.

With Regards,

Based on what I have searched, for HA fail over cluster and for DR just schedule the backup and restore of SSAS databases. one thing that would come in to...

I am still stuck at this, can any one help?

Thank you very much. However, I still get the same error. just to recap this is what I did.

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'Password123'

..........................................................................................

CREATE CERTIFICATE MyCertificateName

WITH SUBJECT =...

I did read the article, and since I am new at SQL Server , so I need a bit more direction. The relevant convert function I see is below from...

I understand that I need to use convert function, but how and where, need a bit more explanation. Hope people wont mind.

If you have installed as a default instance, please type the name of the instance, also make sure the SQl Services are up.

alternatively, you can also enter "." period instead...

Great, That's what I was looking for.... Thanks a Bunch guys.

Regards,

So it be some thing like this.

EXECUTE dbo.IndexOptimize

@databases = 'USER_DATABASES, -name_of_the_database_tobe_excluded',

@FragmentationLow = NULL,

@FragmentationMedium = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',

@FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',

@FragmentationLevel1 = 5,

@FragmentationLevel2 = 30,

@SortinTempdb = 'Y'

I understand, but with this way who would I exclude one database , my understanding is , using 'user_databases' runs it against all the user databases.

I would like to run...

Hi Jeff,

Thanks for the reply. so will this be correct version.

EXECUTE dbo.IndexOptimize

@databases = USER_DATABASES, -databasename,

@FragmentationLow = NULL,

@FragmentationMedium = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',

@FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',

@FragmentationLevel1 = 5,

@FragmentationLevel2 = 30,

@SortinTempdb = 'Y'

Regards,

Thanks DBA from the Cold.

I am new to Power shell but can give this a try. But copying the latest file is still being done by my Xcopy command, the...

Ok , so what I did to resolved the issue, not really sure it will work .. but will monitor it. at 2:11 when this deadlock occur, there was...

When I will do retry, will it start the whole process again , or just starts form the failed index?

With Regards,

Ahmed

Hi All,

so after few days, the job failed again and since I was logging this time I was able to find the error.

Date and time: 2015-03-31 02:08:21 Command: ALTER...