Viewing 15 posts - 871 through 885 (of 1,157 total)
After much digging, what I found was that the new active cluster ( first time it's ever failed over ) had a different level of SQL 2005 and did not...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 4, 2010 at 1:22 pm
You may also read the Default Trace during the time the user loses his permission.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 4, 2010 at 1:19 pm
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 4, 2010 at 10:31 am
Even I feel that the job does some shell commands. May be like the cmd window which is expecting a response.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 4, 2010 at 10:30 am
I assume you are trying to take the backup using SSMS and the destination is referring to the old location.
Why not use this query instead of using the GUI?
BACKUP DATABASE...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 4, 2010 at 7:30 am
Microsoft documentation reads as below.
50 instances on a stand-alone server for all SQL Server editions.
SQL Server supports 25 instances on a failover cluster.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 4, 2010 at 5:30 am
Increasing the timeout value from 10 to 30 will ensure that the mirror monitor will ry for 30 seconds before throwing the time out error.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 4, 2010 at 5:13 am
I assume with indexcol you mean the columns referred in an index. Refer this link for more details.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 4, 2010 at 4:14 am
Do you see any error messages in the Application\System Event logs?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 4, 2010 at 2:45 am
From the error message it is clear that there is memory contention on the box. Is the server hosting only SQL Server or any other application? Also try running the...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 4, 2010 at 2:43 am
Placing tempdb files on different drives is beneficial. Configuring the MAXPDOP/ using the MAXDOP hint depends on the requirement and the hardware capabilities.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 3, 2010 at 10:43 pm
This is what the MSDN documentation states.
you can use all backup and recovery models with FILESTREAM data, and the FILESTREAM data is backed up with the structured data in the...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 3, 2010 at 10:34 pm
Please check the following.
Is the password for pubuser correct?
Does the pubuser has requisite permissions on the database?
Is the default database for pubuser is set correctly?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 3, 2010 at 10:31 pm
Looks like some of the components of SQL 2005 are already installed. Un-installing them may help.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 3, 2010 at 10:25 pm
No problem. Nice to know that it was useful for you !
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 3, 2010 at 9:14 pm
Viewing 15 posts - 871 through 885 (of 1,157 total)