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


Top 5 Contributors of the Month
Kaviya Balasubramanian
Sgraph Infotech
Imran Ghani
Post New Web Links

SharePoint Backup fails

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :SharePoint
 

Hello all,

I am having problems doing a backup of the SharePoint 2007 Server, served by SQL 2005 on a different machine.  This worked once a week or so ago, but now I only get a "completed with errors" message.  The content database failed to backup, with the error: "SqlException: Cannot open backup device &#39;" followed by the pathname of an expected .bak file.  If there are 20 backup files in a particular backup, then the pathname above would be <name>21.bak.  I am logged in using the setup account, can view the content database in Management Studio, but cannot back up the SharePoint site.

Any help would be appreciated.

David




View Complete Post


More Related Resource Links

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?

SharePoint configuration wizard fails at 9 th step after installation of KB961749 on MOSS2007 SP1 se

  
Hi,   System details: 2003 enterprise OS, 2005 SQL server, SharePoint 2007 SP1 with 12.0.0.6327 version. Now i m trying to install KB961749 (February 24, 2009 Cumulative Update), installation completed successfully after this while running SharePoint configuration wizard its failed at 9th (last step) in the wizard. Share point version also not updated after this. i tried to upgrade through psconfig command line also, same result. failed at 4th step. Logs gives below info: Not running in high contrast, so we will paint the background with our trademarked image 09/02/2010 14:21:24  11  ERR                      The B2B upgrader timer job failed. Resource retrieved id UpgradeTaskFailConfigSyncDisplayLabel is Failed to upgrade SharePoint Products and Technologies.  Task upgrade has failed with a PostSetupConfigurationTaskException An exception of type Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException was thrown.  Additional exception information: Failed to upgrade SharePoint Products and Technologies. Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException was thrown.  Additional exception information: Failed to upgrade SharePoint Products and Technologies. Microsoft.SharePoint.PostSetupConfigur

Why saving to SharePoint library fails from Office 2007 client?

  
I have test environment where I have successfully able to create Excel document with the client and publish it to the SharePoint 2010 sites. In the test environment I was using my personal Windows 7 workstations for Office 2007. When I repeat process in the customer environment, it fails. I'm using front-end Windows Server 2008 machine for Office 2007. I'm using admin account and machine is certaily in the domain. 1. Open Excel 2007 and modify it 2. Publish 3. Document Publish Server 4. Input http://intra I get error: This location cannot open with program Why the error? What do I miss? Is the Windows Server 2008 the problem?Kenny_I

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

Sharepoint 2010 configuration fails at step3 after a while

  
I submitted to another post that has a simular issue than be but not entirely the same. Below is my problem: All the pre-reqs for SP2010 installed good, the installation went well without any problems but when I start the configuration it fails after a while at step 3(Configuring the content db's). Two db's gets created. Sharepoint_Config and Sharepoint_AdminContent_[guid]. Below is the error in the log file after the config has failed. Task configdb has failed with an unknown exception 09/03/2010 17:33:12  9  ERR                          Exception: System.Runtime.InteropServices.COMException (0x80090016): Keyset does not exist (Exception from HRESULT: 0x80090016)    at Microsoft.Web.Administration.Interop.AppHostWritableAdminManager.CommitChanges()    at Microsoft.Web.Administration.Configuration.CommitChanges()    at Microsoft.Web.Administration.ConfigurationManager.CommitChanges()    at Microsoft.Web.Administration.ServerManager.CommitChanges()    at Microsoft.SharePoint.Administration.SPIisServerManager.CommitChanges(ApplyChanges applyChanges)    at Microsoft.SharePoint.Administration.SPIisProvisioningAssistant.ProvisionApplicationPool(String name, SecurityIdentifier sid, Strin

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

STSADM -o Backup for SharePoint 2003 SiteCollection throws "The specified URL is not a top-level Web

  
I'm attempting to backup and restore a site collection in a 2003 implementation as part of a process to migrate ~1500 subsites to a MOSS 2007 implementation. My first step was to backup the site collection these subsites were residing in http://CompPortal/sites/MySiteCollection/ When I run the below command in STSADM I get the error "The specified URL is not a top-level Web site. The backup and restore operations work only for top-level Web sites. Enter the URL for a site to try the operation again. stsadm.exe -o backup -url http://CompPortal/sites/MySiteCollection/ -filename "C:\backup\BL" -overwrite I checked in Central Admin to confirm that this is a site collection and I assume a top-level site and site collection are synonymous. Does anybody have a suggestion on what I could be missing? Thanks

SharePoint 2007 SP2 VSS backup error ?

  
Hi Everyone, I've been getting this error below all the time regarding the VSS backup error in the event viewer, eventhough the VSS Writer status got no error in the cmd prompt. and also Symantec Backup Exec 2010 R2 agent got error in backup the farm using the DOMAIN\SPService username which is the owner of this WSS_ContentDB and also member of the Farm admin group. Log Name:      ApplicationSource:        Windows SharePoint Services 3Date:          8/09/2010 10:11:31 PMEvent ID:      3760Task Category: DatabaseLevel:         ErrorKeywords:      ClassicUser:          N/AComputer:      MOSSDEV01.domain.comDescription:SQL Database 'SharePoint_AdminContent_f632e5bf-cbd9-4d9f-a819-1811feb4f2b6' on SQL Server instance 'MOSSDEV01\MOSSDB' not found. Additional error information from SQL Server is included below.Cannot open database "SharePoint_AdminContent_f632e5bf-cbd9-4d9f-a819-1811feb4f2b6" requested by the login. The login failed.Login failed for user 'DOMAIN\Administrator'. Log Name:      ApplicationSource:        VSSDate:          8/09/2010 10:08:52 PMEvent ID:      12289Task Category: NoneLevel:         ErrorKeywords:

SharePoint Farm Backup Error in Search instance function

  
I'm working with MS Project Server 2007 with SharePoint WSS. When doing a full farm backup in SharePoint Central Admin > Operations > Backup and Restore > Perform a Backup, I encountered 2 errors in "SharePoint Windows Services Search, Search instance". 1) Error: Object a8b2cbfe-ef8b-45ce-92a0-c5675f534ec0 failed in event OnBackup. For more information, see the error log located in the backup directory.  InvalidOperationException: System.NullReferenceException: Object reference not set to an instance of an object.    at Microsoft.SharePoint.Search.Administration.SPSearchBackupRestoreTimerJob.Execute(Guid targetInstanceId)   2) Error: Object a8b2cbfe-ef8b-45ce-92a0-c5675f534ec0 failed in event OnBackupComplete. For more information, see the error log located in the backup directory.  Object a8b2cbfe-ef8b-45ce-92a0-c5675f534ec0 failed in event OnBackup. For more information, see the error log located in the backup directory.  InvalidOperationException: System.NullReferenceException: Object reference not set to an instance of an object.    at Microsoft.SharePoint.Search.Administration.SPSearchBackupRestoreTimerJob.Execute(Guid targetInstanceId)  InvalidOperationException: System.NullReferenceException: Object reference not set to an instance of an object.    at Microsoft.SharePoint.Search.Administ

SharePoint 2010 Fails Installing On Step 5 Of The Configuration Wizard

  
Hello,I installed SharePoint Server 2010, and its installed properly, I installed SharePoint over Windows Server 2008 SP2 with the Standalone version (MSSQL Express) - when i run the products configuration wizard i get the following message:----------------------------------------------------------------------------------------------------------------------------------------------------------------- Failed to register SharePoint services. An exception of type System.TypeLoadException was thrown. Additional exception information: Could not load type 'Microsoft.Office.Server.Search.Administration.SearchWebServiceManagerService' from assembly 'Microsoft.Office.Server.Search, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71E9BCE111E9429C'. System.TypeLoadException: Could not load type 'Microsoft.Office.Server.Search.Administration.SearchWebServiceManagerService' from assembly 'Microsoft.Office.Server.Search, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71E9BCE111E9429C'. at System.RuntimeTypeHandle._GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark, Boolean loadTypeFromPartialName) at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark) at System.RuntimeType.PrivateGetType(String typeName, Boolean t

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

Sharepoint Product and Technologies Configuration Wizard fails at step 8 for sharepoint 2007

  
Hi All, I have upgraded moss 2007 with Service Pack 2 after successfully completion of installation automatic Configuration  started and it got succeed till step 7 when it reaches to step 8 after some time it get fails. Please help me to recover. Thanks in Advance. Mohammed

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

Cannot import backup from Sharepoint 3.0 to replacement server

  
I want to retire a Windows 2003 Standard server (named Meton) running Sharepoint 3.0 and transfer its entire database in a transparent manner (I want it to be exactly like it is on the old server) to a 2008 R2 standard guest partitian. I have sucessfully backup up the old server using both the operations tab of the web GUI and this bat file: cd\ cd Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN stsadm -o backup -url http://meton.pond_rd.wtpsmercer.k12.nj.us -directory D:\Wholesite -backupmethod full -percentage 10 -backupthreads 3 pause Both worked. Giving credit where due both this and the import bat were derived from information on http://www.epnetworking.com/blog/?p=179. Attempting to import with the GUI produced nothing. Then I ran this bat: c: cd\ cd Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN stsadm -o restore -hostheaderwebapplicationurl http://sharepoint.pond_rd.wtpsmercer.k12.nj.us -directory C:\ -restoremethod new -username xxxxxx -password xxxxxx -newdatabaseserver sql2008 pause   Despite the information on technet that stsadm is not interactive there are a series of questions and it would not let me choice the default database name, see below. Verbose: Adding WSS_Administration to Restore list. Verbose: Adding Web Application to Restore list. Verbose: Adding SharePoint_AdminContent_c829909f-fe1e-48d8-8649

Installation of Sharepoint 2007 Service pack 2 fails on Step 8 of Sharepoint Configuration Wizard

  

Here's the deal:-

Our test environment consists of one SQL Server 2005 machine, 1 Domain Controller and 1 Windows 2008 R2 server with Sharepoint 2007 and Project 2007 installed.

We wanted to test the installation of Sharepoint 2007 Service Pack 2 in our test environment. I followed the instructions available from Technet to install both the WSS 3.0 SP2 and MOSS 2007 SP2 http://technet.microsoft.com/en-us/library/dd637740(office.12).aspx BUT the last part of the Sharepoint Configuration Wizard failed with the following error:-

 

SQL Database 'ProjectServer_Published' on SQL Server instance 'SPDatabaseServiceInstance'

not found. Additional error information from SQL

Server is included below.

 

Cannot open database "ProjectServer_Published" requested by the login.

The login failed.

Login failed for user 'domain\FarmAdmin'.

The weird thing is my database is called 'MTL_Project_Published'

So it looks like it's looking for the old project databases.


Has anyone encountered this issue before when installing the service pack 2 of Sharepoint 2007 in their environment?

Thanks,


I have tried all the other solutions posted on the Internet such as running the upgrade via the command prompt, cleari

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.

 

Thanks

Faisal


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 12.0.0.7777 to a server with say 12.0.0.6666 assuming that the versions of SQL is the same in both cases.

Will the version difference in SQL create issues

Thanks in advance

 

 


pv
Categories: 
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