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

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

Documenting Server Config via Powershell + DB/Farm Back: Sufficient?

Posted By:      Posted Date: September 29, 2010    Points: 0   Category :SharePoint


After reading through some of the posts about Sharepoint 2010's weaknesses with internal (Admin Console) backups, and discovering that a full Configuration Backup is necessary (see: http://www.benjaminathawes.com/blog/Lists/Posts/Post.aspx?ID=10 and http://sharepointinterface.com/2010/09/10/configuration-only-backup-and-restore-in-sharepoint-2010/ ), I'm a bit concerned.

Is it the case that running the powershell utility (http://technet.microsoft.com/en-us/library/ff645391.aspx) is sufficient for restoration purposes (does it capture all the essential data?) OR do we need to go through and take screenshots of all of our config screens?

What does your backup strategy?



View Complete Post

More Related Resource Links

Server Farm and machine.config machineKey value mismatch

Hi,I'm writing an application that is deployed on web server farm. I've tried to get the machineKey from all the servers but admins have denied my request stating security concern. I have no way of knowing if they match or not. This is the error I get sometimes-------------------------------------------------------------------------------------------------------------------------------------------------------------------------- System.Web.HttpException: Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that <machineKey> configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster. ---> System.Web.UI.ViewStateException: Invalid viewstate.    Client IP:   Port: 49194   User-Agent: Mozilla/5.0 (iPhone Simulator; U; CPU iPhone OS 3_0 like Mac OS X; en-us) AppleWebKit/528.18 (KHTML, like Gecko) Mobile/7A341   ViewState: /wEPDwUJOTczMzM0ODk3ZGSqcWCbsDoMeHnkNaxb9+0vLuiJVw==   Referer: http://mobile.cch.com/MobileZipSalesLookup/Result.aspx   Path: /MobileZipSalesLookup/Email.aspx ---> System.Web.HttpException: Unable to validate data.     at System.Web.Configuration.MachineKeySection.GetDecodedData(Byte[] buf, Byte[] modifier, Int32 start, Int32 length, Int32& data

Server Farm Config not Complete


I am setting up SP 2007 on a Win 2003 R2 in a Win2003 domain. SP is using a small farm with one server for the DB and another for everything else.

When I open the Central Admin page I get in large red letters "Server Farm Configuration Not Complete." But as far as I can see it is. Both the application/web server and DB server are listed correctly under "Farm Topology."

I can't find anything that tells me what to do!

Talk Back: Voice Response Workflows with Speech Server 2007


Speech Server 2007 lets you create sophisticated voice-response applications with Microsoft .NET Framework and Visual Studio tool integration. Here's how.

Michael Dunn

MSDN Magazine April 2008

All my server-controls became unrecognized!!! like there's compilation error or web.config missing!



please help - the problem is in post subject.

I have lots of warnings with following text:

"Warning 10 Element 'HyperLink' is not a known element. This can occur if there is a compilation error in the Web site, or the web.config file is missing. C:\Users\Pavel\Documents\Visual Studio 2010\WebSites\BioWebSite\ToScientist.aspx 26 18 C:\...\BioWebSite\" 

But web.confg is there! And there's no compilation error!

Site builds just fine. And If I upload it to my hoster - it works!


But with all these errors I cant add controls to pages - VS2010 adds hyperlink without ID, and intelisens stoped to work.

Strange, but in my other project (web-application) I have no such difficuty.

Sharepoint farm lost a server... How to proceed?


Had a Sharepoint farm I inherited that was running on ____ hardware in a ____ setup- raid controller failed, and the rack was setup so that I have to down 15 servers that might not come back up, just to get at the server... Complete, unrecoverable failure. This server was a member of our Sharepoint 2007 farm, and had Reporting Services on it. There are a lot of little pieces that are still referenced in the Central Configuration. I removed the server forcibly, and need to know next steps, specifically:

1. I tried to move Reporting Services to another server, but I get an error in the Grant Database privileges that I cannot connect to the Report Server's WMI Provider. I created a SPN on a DC, forced a replication a few hours ago, and still no luck. Any Advice?

2. How do I fix all the little things that reference that server? Anytime Sharepoint initiates a web page to Central Administration, it tries to use that server address.

I think the failed server was running SQL 2008 or SQL 2008 R2, and the server I am moving this to is SQL 2005 SP2. I have installed the correct Reporting Services for Sharepoint. Have I missed something?

Time is of the essence because management relies on Reporting Services and I am under a great deal of pressure to fix this. I appreciate any help I can get.



Saving JQuery date back to SQL Server


Hi..my web app uses lots of asp:textboxes and I can save this data back to SQL Server easily using a stored procedure..

however my JQuery datepicker uses an input textbox, how do I save the date entered into this control.

<input id="datepicker"type="text" /> back to server and can I use the same stored procedure that I use for the other data?



SQL Server Powershell script error!

Hi, I get the following error while trying to execute a powershell script. New-Object : Cannot find type [Microsoft.SQlServer.Management.Sdk.Sfc.SqlStoreConnection]: make sure the assembly containing this type is loaded. I'm trying to implement policies across different sql server instances from a primary instance. The script can be found @ http://blogs.msdn.com/sqlpbm/archive/2008/06/14/running-against-sql-server-2005-and-sql-server-2000.aspx Thanks for your help.

powershell with sql server - wheres the reference info?

Hello, Not sure if this is the right group for this. I need to automate some sql server managements tasks with powershell. Where can I get documentation on how to use objects and methods exposed by the sql server powershell provider? like .script() for example? The type and format of info I'm looking for is like what you would find when hitting the F1 key in visual studio.. easily finding a class of interest, getting a list of all it's members, clicking a particular member and seeing all it's overloads (if the member is a method), and then clicking a particular method overload for a description of what it does, input param descriptions, return value etc... plus sample usage. I need this for powershell in general, and specifically for the methods in the sql server powershell provider at the moment. does this exist? 

Powershell script that uses Microsoft.SqlServer.Management.Smo.Server need to use Sql Server Autheni

I have written a powershell script that uses Microsoft.SqlServer.Management.Smo.Server.  I have a couple of instances that are on different domains that I must use Sql Server authenication.  I am going to create a report user "sssmorpt".  What is the least a can grant this user to allow me to use Microsoft.SqlServer.Management.Smo.Server to get "$dbsize = $db.size - ($db.logfiles|measure-object -property size -sum).sum / 1024" for all databases in an instances?

Updating Config Files in Sharepoint Farm

I am trying to update config files web.comnfig in the Virtual Directory of my server so that users are allowed to upload more that 50 MB of files in my IIS 7 server. Everytime i do the update it works fine but after few days when there are few changes then it removes the added elements itself and restore in the Original Stage. I used to edit my config files manually. I found a way of creating a config files and saving it to the Config Directory under 12 Hive in Server. Like the Content will be similar as follows <actions>    <add path="configuration/SharePoint/SafeControls">       <SafeControl          Assembly="System.Web, Version=1.0.5000.0, Culture=neutral,             PublicKeyToken=b03f5f7f11d50a3a"          Namespace="System.Web.UI.WebControls"          TypeName="*"          Safe="True"/>    </add>   </actions> I have to add following line <system.webServer>     <security>       <requestFiltering>         <requestLimits maxAllowedCon

The URL 'ao/AO Document/Admin Guideline/xxxxx.jpg' error on 2nd SharePoint server in farm

We just added a 2nd SP2007 server to mirror our site.  The original site is in China, the new site in the US.  They are connected via a permanent  site to site VPN.  We are hitting the errors when attempting to upload files to the US mirror.    Environment: US server site: OS: Windows Server 2008 R2 Enterprise (64 bit) APP: Windows Sharepoint Server 2007 Enterprise SP2 (64 bit) DB: Windows SQL Server 2008 Enterprise R2 (64 bit) China site: OS: Windows Server 2003 Enterprise SP2 (32 bit) APP: Windows Sharepoint Server 2007 Enterprise SP2 (32 bit) DB: Windows SQL Server 2008 Enterprise R2 (32 bit) Background: We setup two test Sharepoint farm to be syncronized with only its content database. The upload works good on SZ site. But we got the following 2 error messages randomly when uploading file to document library of SF side. Error message: 1. The URL 'ao/AO Document/Admin Guideline/xxxxx.jpg' is invalid.  It may refer to a nonexistent file or folder, or refer to a valid file or folder that is not in the current Web. 2. Cannot open file "ao/AO Document/Admin Guideline/xxxxx.jpg". -- We've tried the official hotfix, altering the schema, changing the IIS memory limit settings, and restarting the application pool. Could the issue be related to the different OSes 2008 vs 2003, or 32 vs 64bit?  

Cube Writeback SQL Server 2008 R2 (SSAS, write back)

CUBE WRITE BACK in SQL SERVER 2008 R2 Did anybody get the SSAS write back functionality to work against a decent sized datawarehouse? I'm not asking about a little demo but a significant sized footprint e.g. 14M Rows measures, 6-8 wired Dimensions with 8-10 attributes each. I setup a test server using a Dell XEON ( 2x4core) with 48 GB RAM hardware and the latest Sql Server 2008 R2 release. I used the What-If scenario in Excel 2010 and modified a higher level, hoping SSAS would push the values down. After about 15 minutes and after having used 48 GB memory (on average 5% CPU) Excel throw an error - short on memory - and stopped the action. I found the same behavior in Sql server 2005 and 2008 and was hoping this would work now but apparently not so. Here are my questions: Is anybody using this at all? how can one calculated (roughtly) how much memory is requiered? is there any paper that describes best practise? Thanks for any help in advance, Dirk  

Can't save SQL Server Management Studio sql file back into Sharepoint Document Library

I created an sql query file in SQL Server Management Studio and saved it onto my hard drive.  I then moved that file into a Sharepoint Document Library so others on my team could use that query.I opened the file from within sharepoint, it launched SSMS.I made a change to the file and pressed save.here is the error message that comes up."The operation could not be completed.  The process cannot access the file because it is being used by another process"Am I doing something wrong?

Failed to change Farm Account in Sharepoint 2010 server, now Central Administration is not accessibl

Hello, I have a problem, that I no longer can access Central Administration Website, only the Sharepoint itself. I was running installation of Sharepoint 2010 Server with administrative account ImTheAdmin, who is a Domain Admin in the domain on one of the Windows 2008 R2 member servers. Besides that, I made ImTheAdmin the primary administrator of the Sharepoint. ImTheAdmin became the only user of this Sharepoint 2010 server after installation.  I installed everything on one box with default installation settings. I used builtin SQL server, not Standard or Enterprise. What then happened is: Using ImTheAdmin account, I opened Central Administration Website, and it said, that I need to change the Farm Account, for the account for Farm was the default one (I think it was network service). So I created a regular domain user MYDOMAIN\SharepointFarmAccount. The account name was too long to be as a Windows 2000 name, so it showed there without last 't', e.g. MYDOMAIN\SharepointFarmAccoun. I thought, Windows 2000 is long gone, so I didn't pay much attention, I think everywhere the account SID is important. I don't know if that is the real problem with my failure later, but it might be one of the reasons. I put MYDOMAIN\SharepointFarmAccount down in to the form of Central Administration Website, added the check mark, that it would react to password changes, and pre

SharePoint 2010 AD FS 2.0 Integration - login works then fails, looping back to the adfs server

Hello, I setup SharePoint 2010 Claims auth with AD FS 2.0 following this post: http://blogs.technet.com/b/speschka/archive/2010/07/30/configuring-sharepoint-2010-and-adfs-v2-end-to-end.aspx.  I have no access to the ADFS server, but I think they followed the steps as outlined.  If I do an iisreset (or just recycle the app pool of the SharePoint site) I can login successfully using the remote credentials.  Also I can under security in SharePoint search for and find users and roles from the remote ADFS server. If I close my browser, open a new browser and go to the site I am prompted to login again (this is fine).  I do, using the same credentials, and the login fails because I am redirected between the SP and ADFS servers until the ADFS server stops the redirecting.  I have been doing some digging and I found this post: http://blogs.technet.com/b/speschka/archive/2010/08/09/setting-the-login-token-expiration-correctly-for-sharepoint-2010-saml-claims-users.aspx, which describes the situation I have in point # 3 at the bottom.  I have tried setting the token time out as low as 1 second but this hasn't helped. I have also, just to see, tried setting all the other lifetime settings to 1 second - but no luck.  Because the initial login works I think the setup is correct, but something is maintaining some state that is causing the loop

Cannot Add Second FE Server to SharePoint 2010 Farm

Hi folks Well I thought I would add my problem to the others that are also experiencing this issue. I actually reported somthing similar to this forum in Feb 2010 when I was trying the beta version out. I upgraded our WSS farm to SPFS 2010, the upgrade worked, well kinda. Basically our second WFE server would not join the farm after installing the 2010 binaries and runnng the configuration tool and it was complaining with the following error: 07/31/2010 14:35:59  11  INF                              Calling SPFarm.Local and SPServer.Local to get the local farm objects 07/31/2010 14:35:59  11  INF                              SPFarm.Local returned null.  This usually means that the server is not joined.  But, you can delete a server from the configdb without unjoining, which would mean that this machine still thinks it is joined. 07/31/2010 14:35:59  11  INF                              Trying to access th

Same server farm administrator domain account for both Intranet and Internet Sharepoint site?

Hello,   We are planning to setup 2 streams of architecture for both Intranet and Internet web sites. Just wondering whether there is any best practices/security concerns if we are using the same domain account as the Server Farm Administrator for both Intranet and Internet platform?   Thanks,
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