tony28 (3/27/2014)

---

Thank you, good job, very helpful and thanks for experience. I know that this option is in SQL server, but i wouldn't remember in that time

So Service state is...

Matthew Darwin (3/27/2014)

---

I tried this, but no definitely nothing to do with the log shipping configuration. It seems far more to be to do with alerts in general; I...

Did you run it like this ...

Change the job owner to SQL Agent Service account or your ID and run...

This is what happened ..

SQL Server stopped with following error message :

Log Name: System

Source: Microsoft-Windows-FailoverClustering

Date: ...

Ford Fairlane (3/26/2014)

---

DR is different for different application. Some are only using the WFC for HA and not worried about DR others are using the AlwaysOn groups for DR. Now...

tony28 (3/26/2014)

And Now I am seeing that I forgot System log, but time is after the problem, but maybe was problem with failoverclustering and it caused restart service,,, is it...

elhelalaoui (3/26/2014)

---

Thanks free_mascot, thanks sqlbuddy123. All my jobs are going with the same error.

I've just tried the solution of the proxy, and getting this error now : Could not get...

Check the Windows Application and System logs in the Event Veiwer ( Control Panel --> Administrative Tools ).

Also check if SQL Server dump file has been created during the SQL...

Ola Hallengren scripts are the best ones out there. http://ola.hallengren.com/

Someone may recommend scripts from Michelle Ufford http://sqlfool.com/2011/06/index-defrag-script-v4-1/

--

SQLBuddy

Indianrock (3/26/2014)

---

Our company has made the decision to gradually leave sql server in favor of DB2. We have a wide variety of applications ( many acquisitions ) running on...

You are welcome, Oracle_91 🙂

--

SQLBuddy

Create a credential with your ID and a SSIS agent proxy with that credential. Then run the job using that credential.

http://www.mssqltips.com/sqlservertip/2163/running-a-ssis-package-from-sql-server-agent-using-a-proxy-account/

--

SQLBuddy

Are...

CptCrusty1 (3/26/2014)

---

I can't configure it in a query hint since it's not in a query. I'm using a Data Flow Task in BIDS to import from a Flat File...

It will affect the only the query if you specify it as a Query Hint. If you configure that at server level, it affects the whole instance.

--

SQLBuddy