.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

Sharepoint SQL migration using restore from central admin backup

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

I have a SharePoint 2007 farm which consists of a single application server and a separate SQL box.

The DB is SQL 2000. The objective is to upgrade to SQL 2008.

I have read countless articles on how to migrate the DB server from 2000/2005 to 2008. There does not seem to be a consensus on which approach is best.  One approach I do not see much written about is one I tried and successfully implemented.

What I did was simply take advantage of the built in backup feature in the central administration site. I performed a full backup of the site and copied the back up to a development server in a different domain.

I then created a new farm in the development environment and pointed to a 2008 SQl database. The only databases in the farm after I created the farm were the config_Db and central administration DB.

View Complete Post

More Related Resource Links

SharePoint 2007 Central Admin - blank page, isapimodule error in IIS


I've got a Windows 2008 SP2 server runing x64.

When i try to access the SharePoint Central Admin site, I just get a blank page. No errors in the Windows logs, nothing showing up in the SharePoint logs. The IIS log shows a 500 error.

I enabled Failed Request Tracing for the 500 status code, which gives me the following information:

ModuleName IsapiModule

Notification 128

HttpStatus 500

HttpReason Internal Server Error

HttpSubStatus 0

ErrorCode 2147942593


SharePoint 2010 Central Admin error

I'm having problems when I open certain things up in Central admin To name a couple each time I open backup or Configure service accounts I get this The specified user or domain group was not found. Troubleshoot issues with Microsoft SharePoint Foundation. Correlation ID: c9e3eb26-45d8-4f17-985b-54bb178d3184 Date and Time: 7/9/2010 4:51:03 PM For the most part almost everything works in Central admin but for some reason there's a few things that keep throwing this error. Any ideas? Thanks

Cannot login to Sharepoint 2010 central admin

Hi Guys, I am relatively new to MOSS and have started investigating the product. I had MOSS 2010 fully funtioning in a test environment and had an issue with authentication. Each time a user accessed the site for the time, they would be prompted for a username and password. I then came across an article that indicated i should enable Kerberos authentication in Central Admin. I did this but once the configuration completed i could no longer access Central admin. The normal site sites are available and functioning. What could the issue be? thank you,

Backup through Central Admin fails; works using stsadm

Hi, I'm trying to schedule automatic backups of my SharePoint 2007 site.  I wrote a .vbs script that does the backup with the following line:   objShell.Run "cmd /c stsadm.exe -o backup -directory """ & BACKUP_DIR & SITE_DIR & """ -backupmethod full -item ""Farm\Windows SharePoint Services Web Application\SharePoint - SharePointSites"" > """ & CURR_DIR & "log.txt""", 0, True   I ran the vbs script from the command line and everything worked fine.  I used the Windows Task schedule to run the script as a scheduled task.  The script ran fine and the backup completed successfully (according to the logs), but now if I go to the Central Admin page and try to do a restore, I get the error:   The backup/restore job failed. In order to rerun the backup/restore the timer job must be deleted from the Timer Job Definitions page. Failure Message: Backup or restore is already running.   The odd thing is I can do another backup or restore using stsadm at the command line and it works fine.  I can also run the scheduled task to do another backup and that works fine too.  I just can't do any backups or restores from Cetnral Admin anymore.   Any suugestions or ideas? Thanks. -Cynthia

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

Sharepoint Designer Backup/Restore problem


I am trying to use Sharepoint Designer's backup and restore functionality to move a site from one server to another.  The backup seems to complete successfully, but when I go to restore the site: It gives an error pls restore a backup in empty site. can any body tell me what will be the steps of restore site and sub-sites.




version dependency while backup restore of SharePoint 2007 Site Collections


hi all

I am aware of a version dependency on the stsadm -o backup/restore operation.

But will the same dependency exist for a content DB backup restore..

i.e. for example will we able to restore a content DB backup taken from a server with version say to a server with say assuming that the versions of SQL is the same in both cases.

Will the version difference in SQL create issues

Thanks in advance




Backup and Restore Sharepoint 2010 to new server

I have a Sharepoint 2010 server running SQL Express. (SERVER A)     I have an identically configured Sharepoint 2010 server running SQL Express (SERVER B).   I want to migrate the data from SERVER A to SERVER B.   Does anyone out there have a step by step guide for this?

BackUp and Restore through Central Administration fails




I took the backup through Central Administration.


Now I installed MOSS as Server farm installation on 2 different servers.I mean, one is Application server and the second one is the Database server.

While Restoring the Backup :

I could not connect to the Database server.

But if I restore the same backup on a stand alone/Single server installation of MOSS, I could succeed.


Hence for a server farm installation of MOSS on 2 different server, Why I could not connecct to the Database server,while restoring ?


Is there any special configuration I need to configure for Database server Access.


can anybody tell me, the step by step restore process of a backup through Central Administration for the Server farm installation(2 different servers in the farm.).



sharepoint 3.0 service, database backup restore


I am using stsadm to run daily backup of the server, but would like to run hourly database backup, not sure if it works to restore database and log for sharepoint service 3.0, the db is on sql 2005 embedded edition. does any one know or has any suggestions to backup WSS3.0 hourly?

I tried the backup restore feature in the admin site, didn't get it work when last time the server crashes, so right now only use stsadm backup / restore.

SharePoint 2010 Central Admin--Create/Extend Web Application button on Ribbon are disabled


My Dev Environment is  SharePoint 2010 on WIN 7. I have 2 users

1) Built in Administrator- Member of FARM Administrator

2) Dinesh02\Dd – Also member of FARM Administrator

Now when I Sign-in with my account and use Manage Web Application link, on the Top Ribbon none of Button is enabled. I can not create Web APP nor Extend it.  When I select web application from list, some button are enabled but not all. Also I can see role as Contributor

This does not happen When I sign-in with Built-in\Administrator account.

Backup & Restore sharepoint site



I want to be able to back & restore of subsite in same application, or in another application, or another server. I want to make backup of site and restore it whereever I want :)



Backup of ShareService Provider database using Central Admin fails

Anybody have an idea of what causes this?  It's very consistent on one of my farms.

SharePoint Designer still shows in Sites after i disabled it in Central Admin - SharePoint 2010

Is there a way to remove SharePoint Designer from the Ribbon in document libraries or even in the Site Actions > Edit in SharePoint Designer. The business wants that removed.

Luis A Segura

Sharepoint 2007 Central administration Backup



I was running Sharepoint backup from central admin, then i want to stop the process so i deleted the timer job in central admin, but still the backup process showing its running,

please suggest an solution to stop the process





Thanks, Ramachandra Murthy,

Doubt in Sharepoint Central Admin


Hi ,

I cannot able to access the Operations Tab , Applications Tab In Sharepoint Central Administration. Actually i checked the properties of the sharepoint central administration in Inetmgr. i think it  made any changes. Due to this i cant able to access the central admin in my VPC. Is there any way to rectify this ?

While clciking theApplication tab i get error like this ...

Server Error In /_admin application Application

Thanks In Advance


Varathan GS

SharePoint Designer still shows in Sites after I disabled it in Central Admin - SharePoint 2010

Is there a way to remove SharePoint Designer from the Ribbon in document libraries or even in the Site Actions > Edit in SharePoint Designer. The business wants that removed.

Luis A Segura
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