.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

DB Clean

Posted By:      Posted Date: September 03, 2010    Points: 0   Category :SharePoint
I had very big doclib, that i deleted at last. Now i want to shrink DB to release actual disk space. But in db`s properties - available space is very little. It should be about 70 Gb, but it shows that only 2 Gb i can release. What else should be done to detect and release unused space ?

View Complete Post

More Related Resource Links

Clean Web.Config Files (VS 2010 and .NET 4.0 Series)

.NET 4 includes a new version of the CLR, and a new .NET 4 specific machine.config file (which is installed side-by-side with the one used by .NET 2, .NET 3 and .NET 3.5).

The new .NET 4 machine.config file now automatically registers all of the ASP.NET tag sections, handlers and modules that we've added over the years, including the functionality for:

.ASP.NET Dynamic Data
.ASP.NET Routing (which can now be used for both ASP.NET WebForms and ASP.NET MVC)
.ASP.NET Chart Control (which now ships built-into ASP.NET V4)
What this means is that when you create a new "Empty ASP.NET application" project in VS 2010, you'll find that the new default application-level web.config file is now clean and simple:

The "60 days clean-up syndrome", how to recover?

Hi, Like many others, I woke up just to find that SP job has deleted my WF tasks (and history) from a critical system... The tasks are being displayed in all the reports and are important to understand the flow of a process. Now we must recover the data somehow, we are mostly interested in recovering the WF instance and tasks. We have DB backups. I know we should deal with the Workflow table, from which table does the tasks items come? Any tips? Free tools to recover list items from DB backup?   10x in advanced....

Stack Dump generated on the db and SQL tipped over DBCC CHECKDB came out clean

We have Profile db for sharepoint 2010 and the SQL tipped over just before which it generated the below dump. The DBCC CHECKDB on the database came out clean. The SQL Server is SQL 2008 SP1 CU5 and the memory on the server is 32GB with max. for SQL Server being 26 GB.  What could have caused this? There is nothing in the error log prior to this dump. name                                minimum     maximum     config_value run_value ----------------------------------- ----------- ----------- ------------ ----------- access check cache bucket count     0           65536       0            0 access check cache quota            0           2147483647  0            0 Ad Hoc Distributed Queries          0           1           0

Web Part Error on a clean SP2010 install in Document Center

On a clean SP2010 install I created a Document Center site.On the main site page under the "Upload Document" web part there's another web part, which displays this error: Web Part Error: A Web Part or Web Form Control on this Page cannot be displayed or imported. The type is not registered as safe. [UnsafeControlException: A Web Part or Web Form Control on this Page cannot be displayed or imported. The type is not registered as safe.] at Microsoft.SharePoint.WebPartPages.WebPartImporter.CreateWebPart(Boolean clearConnections) at Microsoft.SharePoint.WebPartPages.WebPartImporter.Import(SPWebPartManager manager, XmlReader reader, Boolean clearConnections, Uri webPartPageUri, SPWeb spWeb) at Microsoft.SharePoint.WebPartPages.SPWebPartManager.CompressWebPartNoSave(Boolean isClosed) Is this normal? Or is my installation somehow corrupted?And what is this web part and how can I register it as safe?

SQL Server 2005 (X64) Maintenance Clean Up Task Using Hours Option for File Age

I'm running into an issue with SQL Server 2005 64-bit and the maintenance clean up tasks.  I have it set up to delete any transaction logs or backups older than 12 hours.  It seems that there could be some sort of bug because, according to the log files, SQL is running the clean up for 12 days instead.  I've created a work around for this by using execute transact-sql tasks instead, but was wondering if there's a problem with my version of SQL Server, like an SP or patch that I've overlooked. Here's my version information: Microsoft SQL Server 2005 - 9.00.1399.06 (X64)   Oct 14 2005 00:35:21   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

clean up system tables like sysmergepublications , sysmergesubscriptions...

Hi ALL,            How to clean up system tables like sysmergepublications , sysmergesubscriptions... Bcoz  in my subscriber database i still see the previosous publihser details in these system tables Same thing in publisher database....how to remove all these data .....when i reinitialize database at subscriber ..and if i see the local subscriptions in ssms there are subscriptions from publishers to which it is subscribed before..and i cant delete this....

Item has already been added. Key in dictionary.. How do I clean up service account? Very nasty


I made a few changes in service accounts and now CA Configure Service Accounts and other application pages fail with wtth:

Item has already been added. Key in dictionary: 'dev\svcebrd'  Key being added: 'dev\svcebrd'

Here is what log says when FarmCredentialManagement.aspx opens:

SID |0 cannot be resolved. Using old name: |1. |2

System.ArgumentException: Item has already been added. Key in dictionary: 'dev\svcebrd'  Key being added: 'dev\svcebrd'    at System.Collections.SortedList.Add(Object key, Object value)     at Microsoft.SharePoint.WebControls.ManagedAccountPicker.OnInit(EventArgs e)     at System.Web.UI.Control.InitRecursive(Control namingContainer)     at System.Web.UI.Control.AddedControl(Control control, Int32 index)     at ASP._admin_farmcredentialmanagement_aspx.__BuildControl__control22(Control __ctrl)     at Microsoft.SharePoint.WebControls.InputFormControl.OnInit(EventArgs e)     at System.Web.UI.Control.InitRecursive(Control namingContainer)     at System.Web.UI.Control.AddedControl(Control control, Int32 index)     at ASP._admin_farmcredentialmanagement_aspx.__BuildControl__control16(Control __ctrl)     at Micros

clean solution causes many errors



I accidentally  cleaned a solution that has 10 projects and now I faced many errors, some of the errors are like these:

Error 186 Type 'websearch.svcProfile.Profile' is not defined. D:\DOM VS2010\890624\DOM\33UI\Controls\ctlCatalogue.ascx.vb 502 44 UI

witch svcProfile is a webservice reference. all of my webreferences are not working anymore. other errors are like these:

Error 185 Type 'websearch.Class.CommonText' is not defined. D:\DOM VS2010\890624\DOM\33UI\Controls\ctlBasicSearch.ascx.vb 45 29 UI

Error 1 The type or namespace name 'UI' could not be found (are you missing a using directive or an assembly reference?) D:\DOM VS2010\890624\DOM\33websearch\BasicSearchControl.ascx.cs 12 11 websearch


Error 174 'Could not load file or assembly 'ComponentArt.Web.UI, Version=2009.1.1819.3, Culture=neutral, PublicKeyToken=9bc9f846553156bb' or one of its dependencies. Invalid pointer (Exception from HRESULT: 0x80004003 (E_POINTER))' D:\DOM VS2010\890624\DOM\33UI\LC UI


What do I do? I don't want to go through the process of restoring the backup solution because I did many changes to project.

Cannot uninstall or reinstall TFS 2010: how to clean by hand ?


I have installed SQL Server 2008 express, reinstall it with advanced services, uninstall TFS 2010 and tries to reinstall it but fails. It doesn't want to completely uninstall.

So I'd like to clean everything by hand (deleting registries, folders) but can't find any info. I have deleted install directory but installer still memorized that TFS is installed.

HTMLeditor, always paste with word clean up on?


I haven't been able to find a post about this, but the HTMLEditor is finally a rich text editor that properly removes word formatting without messaging up other stuff (thank god!). However, because I know my users, I would like for this 'paste as word' mode to be always on whenever they paste, how can I accomplish this?

Clean and simple way to generate XPS document using WPF


Is there a simple way to generate XPS document using WPF ? Most of the code samples I see on the MSDN and internet websites are at least 2-3 years old and have some ugly code to generate the XPS document. Have things improved with .NET 3.5 SP1 or .NET 4.0 ?

I hope the Microsoft WPF experts can help the community by providing a good code sample that shows how to accomplish this task.


Form application with Panel and PictureBox controls: Panel.Clear() does NOT clean. (in C#)


I have been developing a Windows Form application with a Panel and many PictureBox controls. PictureBox controls are created dynamically in the Panel control. The initial display works fine, say with 100 PictureBoxes in the Panel control. Then, the Panel control is cleared by "this.panel.CLear()", for the next display, say new 50 images in the PictureBoxes.

The current situation is that the second display (with new 50 images) seem to be completed AFTER the first 100 images, although the first 100 images are cleaned. This means that the first area where the first 100 images displayed is blank, and the new 50 images are displayed after the blank/white area.

My question is how to display the new images at the beginning of the Panel control.


IPCChannel explicit clean-up?



I create an IPCChannel on the server and register a singleton with it.  My client creates an instance of this remote object for communication purposes.  If the server process is restarted, my client can detect this and will try to re-activate the remote object.  It seems that if this disconnect/connect to the server happens to quickly, the client will receive a RemotingException indicating "Access Denied".  This leads me to believe that cleanup of the named pipe needs to be done when the service shuts down, to ensure it is available immediately upon restart.  However, to accomplish this I've tried IPCChannel.StopListening(null), ChannelServices.UnregisterChannel(serverChannel), and also setting the remote object to null on the client -- all to no avail.


I found a newsgroup article where folks report identical behavior with no resolution: http://groups.google.com/group/microsoft.public.dotnet.framework.re

What is the proper way to create a new ssp and clean up old ssp


·         Sharepoint 2007 Standard medium farm with SQL 2005

I have created a new SSP on a new web application. Then I made the new SSP to be the default one. Then, I deleted the other ssp2 from Central Administration > Application Management > Manage this Farm's Shared Services.  

However, I have an another site under this new SSP site. its name is siteadmin and has two site collection similar to the default ssp: /sites/Home and /ssp/admin which neither of them are accessable. Is this another ssp? I can't delete it f

Unable to Install SQL Server 2008 R2 64 Bit on clean install of Server 2008 R2 64 Bit Error CLR20r3



I'm trying to install SQL Server 2008 R2 64  on a clean install of Server 2008 R2 64 Bit. Shortly after double clicking on the setup I get a Windows error message saying the installer has stopped working with the details below.

Suggestions welcomed.



Stopped working

Problem signature:

Problem Event Name: CLR20r3

Problem Signature 01: setup100.exe

Problem Signature 02: 10.50.1600.1

Problem Signature 03: 4bb6742c

Problem Signature 04: Microsoft.SqlServer.Chainer.Setup

Problem Signature 05:

Problem Signature 06: 4bb6742c

Problem Signature 07: 4

Problem Signature 08: 5

Problem Signature 09: System.BadImageFormatException

OS Version: 6.1.7600.

Locale ID: 3081

Read our privacy statement online:


How to clean up phantom custom fields or content type IDs


This is in SP 2010 but I suppose it's the same behavior in 2007 (WSS 3.0, MOSS 2007).  I was trying to deploy a site collection feature which contains a bunch of custom fields and content types (you know, solution package and then feature activation).  The first time the feature activation failed because there's a custom field type dll that I forgot to include.  So i fixed that, retracted and deleted the solution, and deployed the new wsp.  Then it said the content types already exist.  So I added Overwrite="TRUE" and tried again.  This time the feature activation failed yet again, with the "local device is already in use" message on the page.  Behind the log file had can't find the XML definition for the content types even though they are there. 

Thinking something's wrong with my xml file, I removed the dozen or so content types from my elements.xml and left with only one simple content type def, retracted, removed the solution, built the new wsp, added and deployed it.  Upon activating the feature, it gave me the same local device error, and the log file had the can't find the XML definition for ALL the content type IDs.  ???  All but one were not in the XML file, SharePoint somehow held the IDs for the content types that I removed from elements.xml.  I even wrote a console ap

Clean exit from mobile website?


I've just completed my first iPhone-compatible & Droid-compatible mobile app.  At one time, I was confounded by differences in back button behaviour between the two platforms, but I came up with a suitable workaround.

One thing remains that I'd like to correct if it's at all possible.  The application is very session-variable dependent, so naturally, its very dependent on sessions.  Users invariably use leave pages open when they turn off their smartphones, and this means that they return to a non-repsonsive timed-out page when they turn it back on.  Can anything be done to preclude this?  As in active web app or no web app?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend