Solutions Cory Lafferty
corylafferty@hotmail.com
www.recteamstats.com
corylafferty.blogspot.com   
Solutions to common and not so common computer problems...

Problem: In SQL Server you get the following error message. "Could not find the index entry for RID '...' in index page (1:000000000), index ID X, database 'dbname' .."

Solution: This happens when an index has become corrupt to fix it use the following

USE {db_name};
GO
DBCC DBREINDEX ("{table name}", " ", 70);
GO

By using " " that will rebuild all the indexes in the specified table. The fill factor does not have to be 70, this sample is for a large table that has a lot of updates and inserts.

 

Problem: After a service crash or similar event, it may be possible for the site collection to become locked. This has been noted in cases where the backup process is killed manually. As a result of a locked site collection, the ability to create or edit pages is blocked, and certain options are no longer displayed. You will see Access Denied when you log into SharePoint.

Solution: At the farm's Central Administration page, manually unlock the site collection.

This can be found under Application Management-->Site Collection Quotas and Locks-->Site Lock Information. Please change the Read-Only setting to 'Not Locked'.

 

Problem: For seemingly no reason the cluster will fail, but not failover to the other node, it will instead come back up on the same node after about five minutes. If this is the case you should also have an error similar to this in the SQL Error Logs A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): 486344, committed (KB): 18014056, memory utilization: 2%.

Solution: Install the Windows Dynamic Cache Service, Dynamic Cache Service, the download is on the bottom of the page. Make sure to install this on both nodes and something missing from the instructions is that you need to set the MaxSystemCacheMBytes to 512 and install the SQL portion using the name of the MSSQL instance as the dependson value.

 

Problem: You need to change the server collation in SQL Server 2008

Solution: Run this statement from the command line as Administrator in the sql setup directory

Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=[MSSQLSERVER] /SQLSYSADMINACCOUNTS=["domain\account1" "domain\account2"] /SAPWD=[SA password] /SQLCOLLATION=[new collation]

A list of collations can be found HERE.
You don't need more than one system account.
SAPWD is only needed if you are running in mixed mode.

 

Problem: You need to cancel a checkout and you are a server admin, but don't have the option available.

Solution: Go to the page that you need to cancel the checkout on and append "?PageView=Personal&ToolPaneView=2" to the URL. Now you will have the option to cancel the checkout.

 

Problem: You have a SQL Agent job that is running a SSIS package with an FTP Connection in it and get an error similar to; Error: 0xC001602A at SQL, Connection manager "FTP Connection Manager": An error occurred in the requested FTP operation. Detailed error description: The operation timed out.

Solution: Open the SSIS Package and inside the FTP Connection check the box to use passive mode.

 

Problem: You are trying to shrink a SQL Database and you get the following message "The log was not truncated because records at the beginning of the log are pending replication. Ensure the Log Reader Agent is running or use sp_repldone to mark transactions as distributed."

Solution: Run the following commands;

1. sp_replicationdboption 'DBName','publish','true'

2. EXEC sp_repldone @xactid = NULL, @xact_segno = NULL, @numtrans = 0, @time = 0, @reset = 1

3. sp_replicationdboption 'DBName','publish','false'

 

Home
Computer Solutions
Database Administration
Friend/Family Web Sites
Hobbies
Resume
Web Development