.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

Schedule full and differential backup in sharepoint 2010

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


Hello guys ,


I need to Schedule full and differential backup in sharepoint 2010 using powershell how can I do that ?


Appreciated your answers in advanced

View Complete Post

More Related Resource Links

SharePoint 2010 backup is failing - Error - "Unable to read full interval from database - Operation



I am having a problem backing up a site collection, when trying to backup the collection I get the following error "Unable to read full interval from database" and "operation is not valid due to the current state of the object".

The backup does run and manages to backup 182MB of the site collection and then the backup fails, it fails at the same point what ever backup method I use e.g. STSADM, Powershell or Central Admin.

I'm getting the same error whether I use CA "granular backup" or "Farm backup", and using either STSAMD or Powershell. I can backup CA or the mysite collection but not the Home Portal site collection. I even tried installing the commuvaults 2010 agents and running a commuvault backup but this is also failing. i have included the log file entry below.

Does anyone have any suggestions on what i can do to either fix the problem or an alternative way to backup the collection or farm, I am currently taking a full SQL backup but am not sure how reliable this is as I haven't tried to restore the sites. 

P.S. I am not using the "UseSQLSnapshot" parameter.

11/30/2010 09:34:25.23  OWSTIMER.EXE (0x17E8)                 

SharePoint 2010 Unable to restore differential backup


Sharepoint 2010 farm and SQL server are two separate 2008 R2 servers.  Ran full backup in the administration site and ran a differential of part of the site.  Cannot restore the differential.  It is looking for the full.

Here is the error message:

Object WSS_Content_PubSrv failed in event OnRestore. For more information, see the spbackup.log or sprestore.log file located in the backup directory.
SPException: The restore operation cannot locate the backup file F:\MSSQL\Backup\WSS_Content\SQL_WSS_Content_PubSrv_Full_201104111900.safe. Verify that the file exists and then run the operation again.

I tried mapped F to the F drive on the SQL server but it still fails.  I have full rights and the service account has read rights to that directory on the SQL server.   Share is full rights 


sharepoint 2010 Backup error !

While the job was execting a backup I received it message ! Object SharePoint_Config failed in event OnBackup. For more information, see the spbackup.log or sprestore.log file located in the backup directory. SqlException: Cannot open backup device 'C:\Backup\spbr0000\0000009D.bak'. Operating system error 3(The system cannot find the path specified.). BACKUP DATABASE is terminating abnormally. would you please help me ?BRUNO SOUZA

Full Farm Backup Fails on Windows Sharepoint Services Search Database

I am just now starting to us central administration to backup the entire sharepoint farm.  All content backups fine except for the Search Database.  In looking through the backup log, it appears that the search database may not exist.  How can I determine if the search database actually does exist and if it does not can it be recreated?

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

switch off full text search in sharepoint 2010

Hi I need to switch off full text search in sharepoint 2010 so that the search only searches on title filename and metadata. How can I do this? Juran

Your backup is from a different version of Microsoft SharePoint Foundation -- Sharepoint 2010


I made a backup of SharePoint farm from 2010 and tried to restore on a dev server and kept getting this error.  I looked at the versions of SharePoint on both servers, and they were identical:  14.0.4763.1000

I'm posting this although it is not a question, but a statement that might help someone else.  It took a while to notice that there had been an upgrade on the original server that the new dev box did not yet have... not an SP, but more like a hotfix type upgrade.

In Central Admin, go to "Upgrade and Migration".  Click on "Check product and patch installation status".  Scroll down the page of results and see if there are any links to updates that have been installed on the original server that are not on the new server, or vice-versa.  I did find a link on my original server.  Clicking on it opened the update page, so I copied the URL, went to my dev server, opened that page and installed the update, and voila!

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?

SharePoint 2010 Backup Question


Hi Guys,

I have just configured my SP2010 backup and I want to make sure that I am not missing anything.  I was hoping I could list off steps and precautions I have taken and that you could lend me some of your expertise.

  • I have a MOSS server and a SQL2008 server.
  • Symantec Backup Exec backs up the content database every night.
  • I have created a script to backup the SharePoint config every night.  Saves it on my moss server in a backup directory.  (gets cleaned out every 7 days)
  • I have created a script to backup the //MOSS site every night into the same backup directory. (over writes itself every night)
  • This backup folder, is backed up nightly using Symantec Backup Exec as well.
  • I am also backing up the logs folder in the 14 hive (using Symantec)

Is there anything else I should be backing up???  Am I missing anything?

Thank you




How to change SharePoint 2010 Web Analytics Reporting Schedule?


Hello Everyone,


In the Site Collection Web Analytics Reports, the Data Last Updated  time is always shown as 2.00 AM. We need to update usage data more frequently. Therefore, please let me know where to change this schedule.

Tried running following timer jobs, but no luck,


Health Analysis Job (Daily, Web Analytics Data Processing Service, Any Server) 

Microsoft SharePoint Foundation Usage Data Import  

Microsoft SharePoint Foundation Usage Data Processing  




Backup SharePoint 2010 farm configuration settings only get an error for not enough disk space when



I am trying to do a backup the Backup using the Backup and Restore feature in SharePoint 2010 Central Administration.  I just want to backup only the farm configuration settings only.

so I followed the GUI 

Open CA Backup and Restore, checked the Farm checkbox,  click Next 

I chose the following:

Backup Type :  Full

Data to backup:  Back up only configuration settings

Backup File location  :   use an UNC shared location   \\servername\sharedname

at this point,  I see the Estimated disk space required is:   1.2 GB 

the server hard disk available space is  30 GB

but when i click the Start Backup,  i got an error in RED saying "There is not enough disk space. Free additional space on your hard disk and then try again. Approximate amount of space needed is 40 GB.   Amount of space free on disk:  30 GB."

Why is this happened?  and the estimated disk spaced required still showed at 1.2GB

If anyone had experience this problem and have a solution, please advice









Will full or differential backup break LSN chain if compatibility level = 80 in SQL Server 2005/2008

My understanding is that full or differential backup will not break LSN chain starting in SQL Server 2005.  However, I'm not sure whether this applies to databases with compatibility level 80 in SQL Server 2005/2008 or not.

Backup/Restore Sharepoint 2010 using Powershell.


Hello all!

I can't say, that i'm new in Sharepoint and particularly in Sharepoint 2010, but i've never used for Backup powershell, so i've got a question.

When i perform Backup using powershell i get as a result folder with a lot of .bak files within. To get know what .bak file to use for Restore of some DB i need to open that XML file, to find by the name needed DB and to restore. The problem is, that when i find needed DB in this XML file i see three .bak files for this DB like these:

1.<SPParameter Key="Features.xml">

- <![CDATA[00000047.bak  ]]>

SSRS 2008 R2 running in SharePoint 2010 Integration mode - Not able to schedule reports.



I am unable to schedule report am getting following error when trying to schedule an SSRS report from ReportViewer Webpart in SharePoint 2010.

  • The current action cannot be completed. The user data source credentials do not meet the requirements to run this report. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified. (rsInvalidDataSourceCredentialSetting)

I have SSRS 2008 R2 running in SharePoint 2010 Integration mode on Win 2008 R2 System.

I have also setup the unattended execution account from the Reporting Services Configuration Manager, which has appropriate privilates on the database to generate report.

Also, I have reporting webservice setup @ following url (am using the named instance of SQL Server):


Am able to view the report from report viewer webpart but unable to schedule it.

Kindly let me know what's going wrong.

Thanks in Advance,

Sachin R. Chavan.

Sachin R. Chavan.

Short Overview of SharePoint Features in Visual Studio 2010

As you probably know, Visual Studio 2010 was announced earlier this week and it contains a lot of cool features and project templates for SharePoint developers. Below is a short overview for some of the SharePoint development related features and project templates.

How to get more information about the exceptions that can happen in SharePoint 2010 projects?

In case there is an exception anywhere in the SharePoint 2010 project (most common place an exception would happen is during deployment of your SharePoint project, custom deployment configuration or custom deployment steps), there's a registry key EnableDiagnostics available for you to use.

InfoPath 2010 cannot connect to SharePoint 2010

You have installed Office 2010 beta and you are trying to connect to SharePoint 2010 from InfoPath but you get an error
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