none
Restore the latest backup to sub site - Getting an error

    Question

  • Hi,

    When i try to restore the latest backup to TEST site by using STSADM command, i am getting an error

    "This operation can be performed only on a computer that is joined to a server fa
    rm by users who have permissions in SQL Server to read from the configuration da
    tabase. To connect this server to the server farm, use the SharePoint Products a
    nd Technologies Configuration Wizard, located on the Start menu in Administrativ
    e Tools."

    I don't have DB access in this environment (Test environment), because of that i am getting an error for my login. Is it correct?.

    Regards,

    Raghav

    • Edited by Mike Walsh FIN Thursday, September 03, 2009 5:18 AM "I need ..." deleted. Don't pressurize forum members.
    Thursday, September 03, 2009 4:58 AM

Answers

  • I would like to explain you cannot restore the backup in an environment without DB access. If the DB access is available, Here is the detailed Syntax of stsadm to restore the backup.

     

     

    For site collection restore

    stsadm -o restore

       -url <URL name>

       -filename <file name>

       [-hostheaderwebapplicationurl] <Web application URL>

       [-overwrite]

    For catastrophic restore

    stsadm -o restore

       -directory <UNC path>

       -restoremethod <overwrite or new>

       [-backupid] <GUID from backuphistory, see stsadm -help backuphistory>

       [-item] <created path from tree>

       [-percentage] <integer between 1 and 100>

       [-showtree]

       [-suppressprompt]

       [-username] <user name>

       [-password] <password>

       [-newdatabaseserver] <new database server name>

       [-preservechangelog]

       [-quiet]

     

    You can find more information via link below:

    http://technet.microsoft.com/en-us/library/cc262087.aspx

    Thursday, September 03, 2009 8:56 AM

All replies

  • NEVER NEVER post the same question to more than one forum. It wastes everyone's time.

    I've deleted the duplicate sent to general. Please don't do this again.



    (moderator)

    WSS FAQ sites: http://wssv2faq.mindsharp.com and http://wssv3faq.mindsharp.com
    Total list of WSS 3.0 / MOSS 2007 Books (including foreign language) http://wssv3faq.mindsharp.com/Lists/v3%20WSS%20FAQ/V%20Books.aspx
    Thursday, September 03, 2009 5:18 AM
  • Sorry for that. I wouldn't do this agin. Thanks Mike.

    Thursday, September 03, 2009 7:08 AM
  • Hi,

    You need to have DB access or at least to apply windows authentication for SQL test instance



    Best Regards, Ammar MCT
    Thursday, September 03, 2009 8:34 AM
  • I would like to explain you cannot restore the backup in an environment without DB access. If the DB access is available, Here is the detailed Syntax of stsadm to restore the backup.

     

     

    For site collection restore

    stsadm -o restore

       -url <URL name>

       -filename <file name>

       [-hostheaderwebapplicationurl] <Web application URL>

       [-overwrite]

    For catastrophic restore

    stsadm -o restore

       -directory <UNC path>

       -restoremethod <overwrite or new>

       [-backupid] <GUID from backuphistory, see stsadm -help backuphistory>

       [-item] <created path from tree>

       [-percentage] <integer between 1 and 100>

       [-showtree]

       [-suppressprompt]

       [-username] <user name>

       [-password] <password>

       [-newdatabaseserver] <new database server name>

       [-preservechangelog]

       [-quiet]

     

    You can find more information via link below:

    http://technet.microsoft.com/en-us/library/cc262087.aspx

    Thursday, September 03, 2009 8:56 AM
  • Thanks for your replies. I requested to my tech to give an access for the DB.
    Is it possible to restore the backup without having DB access?
    Friday, September 04, 2009 5:59 AM
  • Hi Raghav,

     

     

    Based on my research, the DB access is necessary when restore a backup in Sharepoint. It’s impossible to restore a backup without it.

    Regards.

    Monday, September 07, 2009 1:47 AM
  • Thanks for your timely help to solve this issue. I got an access from my tech and i could able to do the restore a backup.
    Friday, September 11, 2009 6:03 AM