Viewing 15 posts - 871 through 885 (of 1,161 total)
You may find this white paper useful
August 4, 2010 at 1:29 pm
You may want to cross check the column mappings. Please refer this article
August 4, 2010 at 1:27 pm
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...
August 4, 2010 at 1:22 pm
You may also read the Default Trace during the time the user loses his permission.
August 4, 2010 at 1:19 pm
Even I feel that the job does some shell commands. May be like the cmd window which is expecting a response.
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...
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.
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.
August 4, 2010 at 5:13 am
As discussed earlier, please schedule a transaction log backup job. This is the permanent fix
August 4, 2010 at 5:10 am
I assume with indexcol you mean the columns referred in an index. Refer this link for more details.
August 4, 2010 at 4:14 am
Do you see any error messages in the Application\System Event logs?
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...
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.
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...
August 3, 2010 at 10:34 pm
Viewing 15 posts - 871 through 885 (of 1,161 total)