Yes. Hardcoded app with 1433 will ask sql browser to connect to this port. So if your named instance is listening on 1433, you should be able to connect.

I suggest to run the index rebuild in ssms and see what the error you will get.

There are factors like Database load, resource availability at that time of Index rebuilding.

Can you post the index size, what options you are using to rebuild like online/offline, sort_in_tempd etc?

Yes,

http://www.mssqltips.com/sqlservertip/1705/implementing-database-mirroring-in-sql-server-2005-across-domains/

http://www.sqlservercentral.com/Forums/Topic1308115-1549-1.aspx#bm1310154

I suggest to change 'sa' account to the account what you are running in ssms in sql job. Let us see it solves the issue.

Hi,

could it be a access issue? Sql service and agent are running under different accounts?

Hi,

could it be a access issue? Sql service and agent are running under different accounts?

Robin35 (6/19/2013)

---

Principal server error log :

2013-06-19 01:26:27.180spid27sSQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to some database maintenance or...

Select multi_pages_kb, type from sys.dm_os_memory_clerks

Most of the types are not descriptive in names.

I am testing it without restarting service.It seems working. weired.

Let us find the root case of delayed checkdb. Since its 37GB, I would suggest to run checkdb in another test machine with your restored 37gb.

Denesh Naidoo (6/18/2013)

---

The resolution is to restart the app server...then SQL is fine. Once I can get in, checking the error logs...there are no errors of note. The only error...

Hi Nair,

Are you using clusters , so is it mount points? In this case, i suspect xp_fixeddrives will help you????when googling consider mount points as well. It needs to be...

There are some stories about 300sec.. I am told 300sec for every 4gb physical memory. Is it true?

sp_altermessage 1105 , 'with_log' , 'false'