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

Top 5 Contributors of the Month
Post New Web Links


Posted By:      Posted Date: September 13, 2010    Points: 0   Category :Sql Server
Hello,  If any one knows answer to this Question, plz reply me What would be the steps required for recovering from a production restore?

View Complete Post

More Related Resource Links

Recovering list items

Hi, The scenario: SharePoint 2007, critical system which employs some workflow solution, suddenly all workflow tasks (which are 60 days old) have been deleted (as part of the clean-up job), now I'm tasked to recover all the lost data. All I have for the mission is the content DB backup file (.bak). As derived from the descriptions above, I probably should recover the data to some external DB and try to copy the deleted items to the real DB. My questions are: 1. Have you ever recovered single list items? Which DB table is relevant here? Any tips? 2. Have you ever recovered workflow data for list items? Any tips?   Regards, Yoni Goldberg      ...

Recovering Storage.


Here is the story so far.  I have a Sharepoint 2007 installation using SQL 2008.   I turned on versioning on a heavily use library which caused the versions table to explode in size (the DB was 100gb before afterwards 580gb).  I pruned out the extaneous versions but the table is not shrinking.  I have done several queries to find the size of the data being stored in the elements and it comes to around 22gb (which sounds right) but when I do a properties on the table it still says the table is over 400gb.  Now here is the strange thing I took a backup (I didn't want to monkey around with production data) and restored it to a test environment.  In the test environment the space is gradually being reclaimed and over the course of a week the table has returned to a normal size.


My question is this, is it possible for the application (in this case Sharepoint) to be locking the database in a way that it cannot reclaim that space.  Is there a command (online preferred but offline if needs be) I can run to reclaim whitespace?

Recovering prior versions of .Net Framework


Like others, I've recently had repeated updates of .Net Framework 4 (KB2446708) which where successfully installed .  Before finding this site, I Googled the issue and it was suggested that I download & run the MS dotnet_cleaup_tool which I did.  It was also suggested to download & install the full version of .Net 4 (filename: dotNetFx49_Full_x86_x64 which I also did.  They both seemsed to work.

Unfortunately, when I ran the cleanup tool I mistakenly deleted ALL versions of .Net Framework.  I did do the instal of the "full" V4 application. 

Questions: How do I reinstall the prior versions?  Do I need them all back to V1?  Is there a specific order they should be installed? Should I perform update requests after each version has been installed?

TIA for your help.

Joe T

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