Yes, it is for 2014 new installation on 2012 R2

Installation procedure:

After installing SQL 2014 DB engine was not online

Disabled the SSL and TSL

Updated CU13

DB engine was online

Followed the below article...

Hi,

Got the similar issue. Below is the Agent log details. Agent is starting and stopping automatically. Can some one provide me the resolution.

Agent Log details:

2016-06-23 02:19:07 - ? [100] Microsoft...

If i want to configure the backup job. Maintenance plan is recommended or SQL Agent job?

Which is better and reasons from choosing one of these 2?

Yes, I do faced the same issue.

Error from Eventvwr: SQLServerAgent could not be started (reason: Error creating a new session)

Resolution:

1) Add the service account as Administrators at server level....

I think SPID A got low deadlock priority in this case. We can avoid by setting the deadlock priority high.

If priority is high it never becomes the victim.

Suneel,

No i did not try to rebuild the indexes. As i explained before i just shrunk the .mdf and space gets released.

I have created a package in BIDS

Created a deployment utility

Build the package in BIDS

Deployed from Manifest files.

Fortunately it successes. But i want to know the basic troubleshooting steps.

Pietlinden,

Yes, we shrunk the .mdf and alert moves to Warning from centreon. But i think it is not right resolution.

Jeff,

I understand that space will simply unallocated rather than releasing. But...

I did not get any method to upload data directly from S3. Could any one provide me steps if it is possible?

Yes, AWS many features few are listed below.

S3: Simple storage service with tools like cloud berry or S3.

Easy to download and upload the data in cloud.

Easy to move data from...

Gila,

If we shrink the log file of Priniscipal database, does the mirror log gets shrink?

Shaw,

I was thinking about a script, to resolve this rather than editing in MSWORD.

Hi Denny,

Etl job pushes daily 1 file into the database. Acutally i have resolved by using below solution, but i am looking for valid solution.

1) Genereate the restore script

2) Copy...

Hi Shawn,

Thanks for providing detailed information. As per your information i understand and your template looks below. As per my knowledge Raid levels play a vital role in performance. ...

Harjeet,

Did you get the error or set up exit's automaticlaly without warning or error?

Is that success in installation page?