.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

How to Backup Single Server (Database on same server )Extra-net SharePoint Site MOSS 2007 SP1? and H

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :C#


I have to create Test Server (Single server with Database on Same Server).

What Kind of Backup should i be asking  to Hosting Company,SharePoint MOSS 2007 SP1 Extra net site Hosted by 3rd Party.

How to restore it to Test Server and Has any one documented this process and has anyone had sucess in doing similar work ?

I do not have any access to Production server.How to make sure i have same server setup & configuration as Production Server.


I have to customize this site and do some development work so i thought this would be best approach ?


Please let me know..thanks..



View Complete Post

More Related Resource Links

SharePoint 2010 Server: Cannot manage all user profiles from upgraded MOSS SSP database

I have upgraded an SSP database to SharePoint 2010 and successfully performed User Profile Synchronization with Active Directory, however I cannot manage ALL of the user profiles in the database. I go to "Manage User Profiles" in Central Administration and perform a filtered search (i.e. I want all DOMAIN accounts beginning with "j" so I search for "DOMAIN\j" in Manage User Profiles), but I don't receive ALL the user profiles back. I receive about 8 in return when I know there are about 20 starting with "j". If I create a new AD account beginning with "j" it is successfully synched with SharePoint 2010 and I see it in the Manage User Profiles. I ran an stsadm -o sync to clear any old synchronization information, and the Forefront Synchronization Service appeared to pull in many changes to existing accounts (including ones I can't currently manage), but I still cannot manage them using "Manage User Profiles". I really need to be able to manage all the profiles so I can manually edit some fields. Can anyone please help? Thanks in advance.

Upgrade from MOSS 2007 Trial to Sharepoint Server 2010

I have a client who setup MOSS 2007 Trial and are coming up on the expiration.  Instead of buying a key for MOSS 2007 they purchased Sharepoint 2010.  I'm having some problems upgrading because its the trial.  What are my options for upgrading/migrating over to Sharepoitn 2010?

MOSS 2007 to SharePoint Server 2010 Hybrid Upgrade Approach on Windows Server 2003 x64

There's some guidance circulating about upgrading to 2010 with a mix of In-Place and Database Attach upgrade methods. My Central Admin and SharePoint Web App are on a 64 bit server, but it's running on Windows server 2003 x64 and not on Windows Server 2008 or 2008 R2. SharePoint Team Blog says Server 2008 or 2008 R2 is required for SP2010. If I want to do the hybrid upgrade approach, is it possible to first upgrade the OS to Server 2008 R2 on the server where my Central Admin and SP Web App runs?  Or will this break MOSS 2007?

Cannot Restore Backup from Sharepoint Server 2007 to Sharepoint Server 2010 Trial Version

After installing the trial version of Sharepointn 2010 I wanted to restore my Sharepoint 2007 sites to it but received the following error:  "The site collection could not be restored. If this problem persists, please make sure the content databases are available and have sufficient free space." I went on to create a new content database in sharepoint 2010 but it still did not work. The old database i.e the one used by the sharepoint 2007 server is SQL 2005. During the installation of the sharepoint 2010 version I selected SQl Server Express for the database. Is there any specifics for migrating from MOSS 2007 to sharepoint 2010? Thanks for helping

Moving a larger Sharepoint 2007 site collection over to a new server



We have a Sharepoint 2007 site collection roughly 36 GB in size and have been having problems moving the site to a new server farm (Also 2007). We are trying the Sharepoint backup and restore method, but I understand that this method is not recommended for sites over 5GB. Has anyone moved a site of this size and how did you do it?

Thanks  Ron


My Site Issue: "The evaluation version of Microsoft Office SharePoint Server 2007 for this server ha


Hi Guys,

when i opened my site am getting following error, but moss 2007 server is Licensed Verison.


Thanks  Advanced.



Move Single MOSS Content Database to Different SQL Server

We want to mmove the single database of MOSS on Network Test and Development to the Production SQL Server. But MOSS aplication server remains same!

So in this condition it points out for the two database servers at the same time.

Is it possible? Or I need to migrate the all concern databases to the another SQL Server?

Pls HelP!

unable to save data in SQL Server database through Sharepoint 2007


Hi All,

I have created dummy database, Table in SQL Server 2005 with some values.
Iam able to pull data from the SQL database to sharepoint dataview webpart through data connection using sharepoint desigher.

Now i have to enter new record in to SQL table through sharepoint. i have checked with sharepoint designer but unable get it done.

Can some one have idea on this. Please help me to get it done

Thanks in Advance.

Upgrade from MOSS 2007 to SharePoint Server 2010 but with a catch...


... and the catch is that the MOSS 2007 Site Collection is contained in the SharePoint Central Administration v3 Web Application and therefore the SharePoint_AdminContent_... database which is used by Central Administration (not my doing btw).  Please let me know how to copy it to a new 2010 server farm and then upgrade just our sites and content while removing all of the 2007 Central Administration stuff.



Migrating MOSS 2007 installation from one database server to another - configuration database issue


The database server which our sharepoint installation is currently using is going to be shutdown and a new one is going to be put in production.

I read in some post that the configuration database cannot be moved (while the same operation type is documented for content database). Is this correct?

Isn't there a way by which I can modify my current moss installation to define the use of another sql server for configuration (and then later for content) databases?

Any other workaround or procedure?

Thank you!


"Error in PortalCrawl Web Service." error while crawling People on MOSS 2007 from Sharepoint Server


Hi All,

I am getting "Error in PortalCrawl Web Service. " error while crawling people [SSP] on MOSS 2007 box from Sharepoint 2010 box.

NOTE: I am able to crawl People i.e SSP application on other MOSS 2007 box successfully by following same steps which i am using to crawl above mentioned SSP which is giving error.

If anyone has faced similar error ,please suggest.



"Error in PortalCrawl Web Service." error while crawling People on MOSS 2007 from Sharepoint Server


Hi All,

I am getting "Error in PortalCrawl Web Service. " error while crawling people [SSP] on MOSS 2007 box from Sharepoint 2010 box.

NOTE: I am able to crawl People i.e SSP application on other MOSS 2007 box successfully by following same steps which i am using to crawl above mentioned SSP which is giving error.

If anyone has faced similar error ,please suggest.



Database server migration - renaming database server in SharePoint 2007


We are migrating our SharePoint databases to a new database server.  This new database server will have a new name for SharePoint to reference.  How do I go about pointing SharePoint 2007 from the old database server name to the new name?

It seems like there should be a simple solution, but I have yet to find a solid procedure.

Thank you,

- Tom


SharePoint Server 2007 Database


Hi Guys,

I'm done with the installation of our new SharePoint Server 2007 but i was not able to find its config database. Can you please help me locate it? We are running SQL Server 2005.

Best Regards,

Albie Bokingkito
Systems Administrator

SQL Server database permission problem in SharePoint 2007


Hi All,

I created few users from "Computer Management" --> "Local Users and Groups" --> "Users" --> "New User" as my login user in SharePoint 2007

Then I having a custom page where store the data into SQL Server Database.

below is how my connectionstring look like:

<add name="XXConnectionString" connectonString="Data Source=XXX;Initial Catalog=YYY;Integrated Security=True" providerName="System.Data.SqlClient"/>

however I hit error when browse to the custom page by the users.


Cannot open database "XXX" requested by the login. The login failed. 

Login failed for user 'xx\user1'.   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) 

It was fine if I login as System Account.
Can anyone help me in this? thank you in advance.

Gathering MOSS: New Dev-Centric Features In Office SharePoint Server Keep Your Apps Rolling


Microsoft Office SharePoint Server (MOSS) 2007 provides great portal and search features and much more, and Ted Pattison puts them to good use here.

Ted Pattison

MSDN Magazine August 2006

VS Studio WorkFlow Failed on Start in MOSS 2007 ON Windows Server 2008 64 Bit


I have created a sequential sharepoint workflow in WSP Builder in my Sharepoint Server and Deployed it.

But the workflows says Failed on start and retrying ans stops there forever says couldn't start the workflow.

I repaired .NET Framework 3.5sp1 installed

 tried this

 1. I tried again, in C Prompt:  Lodctr "c:\Windows\Microsoft.Net\Framework\v3.0\Windows Workflow Foundation\perfcounters.ini"  it says initiation file cannot be found

2   i again tried this C prompt Lodctr /R "c:\Windows\Microsoft.Net\Framework\v3.0\Windows Workflow Foundation\perfcounters.ini"

it says reloaded  from the system restored

i am still getting the same error.

When i manually go to my  C:\Windows\Microsoft.NET\Framework\v3.0\Windows Workflow Foundation i can see a folder for SQL that's it nothing more than that..

I dont know what is happening i am trying it from 2 days and still no solution.

any ideas would be real great help for me.

My system is 64 bit , Window server 2008, MOSS SP2, Visual Studio 2008 Version 9.0.30729.

.Net Framework 3.5 sp1

and WSP builder the one from Codeplex for 64 bit machines

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