none
Direct Restore of Sharepoint Backups RRS feed

  • Question

  • Hi folks, i took backup of a site collection (project web app).

    When i go to SSMS and type restore headeronly command in SQL server; i get below error:

    The media family on device is incorrectly formed. SQL Server cannot process this media family.


    You miss 100% of the shots you do not take!
    Tuesday, July 20, 2010 2:51 PM

Answers

  • Looks like the backup directory is an issue.

    Create a network share and provide appropriate permission to access from SQL and Sharepoint servers.

    Later try to take the backup. Check the backup log.


    Cheers. Happy troubleshooting !!! Sriram E - MSFT Enterprise Project Management
    Thursday, July 22, 2010 1:43 PM
    Moderator

All replies

  • How did you take the backup ? (STSADM) If yes, you need to use stsadm -o restore

    Only SQL backup you can restore in this method.

    Go through the following sites for SPS backup / restore.

    http://office.microsoft.com/en-us/sharepoint-designer-help/back-up-restore-or-move-a-sharepoint-site-HA010069939.aspx

    SPS backup / restore:

    http://msdn.microsoft.com/en-us/library/bb447517(office.12).aspx

    Back up and restore an entire farm (Office SharePoint Server 2007)

    http://technet.microsoft.com/en-us/library/cc262412(office.12).aspx


    Cheers. Happy troubleshooting !!! Sriram E - MSFT Enterprise Project Management
    Wednesday, July 21, 2010 12:02 PM
    Moderator
  • Hi, i try to take full farm backup: central administration --> backup and resote --> perform a backup

    it's failing with below error in the spbackup.log:

     

    FatalError: Object Search_Service_Application_DB_8c11ce06c315418db7d2c042ea6ecaa8 failed in event OnBackupComplete. For more information, see the spbackup.log or sprestore.log file located in the backup directory.
     Aborted due to error in another component.
    [7/3/2010 10:29:23 PM] Verbose: Starting object: Admin (C: on ).
    [7/3/2010 10:29:25 PM] FatalError: Object Admin (C: on ) failed in event OnBackupComplete. For more information, see the spbackup.log or sprestore.log file located in the backup directory.
     Aborted due to error in another component.
    [7/3/2010 10:29:25 PM] Verbose: Starting object: Search_Service_Application_CrawlStoreDB_30e554dd555e4e9e99a696afa44e5e3f.
    [7/3/2010 10:29:26 PM] FatalError: Object Search_Service_Application_CrawlStoreDB_30e554dd555e4e9e99a696afa44e5e3f failed in event OnBackupComplete. For more information, see the spbackup.log or sprestore.log file located in the backup directory.
     Aborted due to error in another component.
    [7/3/2010 10:29:26 PM] Verbose: Starting object: Crawl-0 (C: on ).
    [7/3/2010 10:29:28 PM] FatalError: Object Crawl-0 (C: on ) failed in event OnBackupComplete. For more information, see the spbackup.log or sprestore.log file located in the backup directory.
     Aborted due to error in another component.
    [7/3/2010 10:29:28 PM] Verbose: Starting object: Search_Service_Application_PropertyStoreDB_7ab8e3dd88e845809fea2e228d5fa361.
    [7/3/2010 10:29:29 PM] FatalError: Object Search_Service_Application_PropertyStoreDB_7ab8e3dd88e845809fea2e228d5fa361 failed in event OnBackupComplete. For more information, see the spbackup.log or sprestore.log file located in the backup directory.
     Aborted due to error in another component.
    [7/3/2010 10:29:29 PM] Verbose: Starting object: Index Partition 0.
    [7/3/2010 10:29:31 PM] Verbose: Starting object: Query-0 (C: on ).
    [7/3/2010 10:29:32 PM] FatalError: Object Query-0 (C: on ) failed in event OnBackupComplete. For more information, see the spbackup.log or sprestore.log file located in the backup directory.
     Aborted due to error in another component.


    You miss 100% of the shots you do not take!
    Thursday, July 22, 2010 11:00 AM
  • Looks like the backup directory is an issue.

    Create a network share and provide appropriate permission to access from SQL and Sharepoint servers.

    Later try to take the backup. Check the backup log.


    Cheers. Happy troubleshooting !!! Sriram E - MSFT Enterprise Project Management
    Thursday, July 22, 2010 1:43 PM
    Moderator