We use sharepoint server 2010 and windows server 2008 R2. Currently, I'm taking backup of sharepoint portal through sql server management studio by backing up the databases (listed for each web application in the central administration).

Will I be able to recover the sharepoint portal in case of crisis by restoring the databases? or m i missing something?

PS: When I initiate the backup using central administration (backup and restore link) the backup status shows as "in progress" but no backup file gets created ever.


The backup operation via central administration normally takes long time based on your farm size and tour backup selections so be patient.

Also,you can perform backup using PowerShell as mentioned here.

for Farm

Backup-SPFarm -Directory <BackupFolder> -BackupMethod {Full | Differential} 
-Item <WebApplicationName> [-Verbose]

For Site

Backup-SPSite -Identity http://mcit-test -Path "C:\\MoveSiteCollection.bak"

Regarding your current situation, you should restore it by attaching it again to your destination farm or your current farm,

but this only backup contents and in this case you will need to reconfigure application services again and all configuration settings.

I advise you to check the same scenario Restore / Migrate a SharePoint Web Application to another farm from SQL Database Backup

  • I'm trying to restore the .bak file created using Backup-SPSite command but it gives compatibility error. My source farm is on windows server 2008 R2 while the destination farm in a development farm is on windows 7 64 bit. I'm doing this operation only to check the integrity of backups and challenges expected while restoring them. – rain Jul 15 '16 at 12:19

if you have the Backup of the Content Database of the web applications, by this you can restore the Content of your portal.

But if you have Custom solutions, Authentication and other custom changes to IIS or Web.config files...You have to Manually restore them.

In case of DR, You have to rebuild the farm, build the webapp, configure the Authentication, Deploy the solutions then restore the content db.

  • For now the only command I could get to work is Export-SPSite command which saves the exported site to .cmp file format. I'm not completely sure of the custom solutions and all. But I know the sites which are extremely important. Thanks a lot. – rain Jul 15 '16 at 12:13
  • But this is not reliable in case of recovery – Waqas Sarwar MVP Jul 15 '16 at 12:41
  • Yea I checked. Some of the webparts didnt get restored. I have the content database backup for the web application. Can i directly restore the database on my windows 7 machine and attach the restored database to the windows 7 web application? The window 7 machine and production server r on same network domain. I dont want to break the production environment. – rain Jul 15 '16 at 16:31
  • I would recoemend fix the issue and go for solid backup, So that on DR you can recover it. – Waqas Sarwar MVP Jul 15 '16 at 16:32
  • Its the compatibility issue that doesnt let restore-spsite command to restore the .bak file on the windows 7 machine. What is DR? :P – rain Jul 15 '16 at 16:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.