locked
SharePoint 2010 Restore From Backup RRS feed

  • Question

  • Hello,

    We Have A Single SharePoint 2010 Server, with external (other server) Sql 2008 Database.

    We Have A PowerShell (Backup-SPFarm Full) Backup To Folder.

    We Want to Simulate A DR Restore (Restore-SPFarm).

    We Have Copied One Of Our DC To A Test Environment, and installed a new 2008 Server With Internal(Installed On The same Server) SQL 2008 Server Installation.

    1. Does The Test 2008 Server, Where we want to restore the SP Backup, Has To Have the same server name as the source backup server ?

    2. What Other Prerequisites do we need to take into consideration ?

    3. What Do We need to do for the diffrence of the SQL Server location (the original database is on an external with one name, and the restore destination is a diffrenet name on the same server as the SharePoint).

    Thank you.

    Tuesday, October 2, 2012 8:25 AM

Answers

  • Yes, that will be possible, but you still may run into problems, depending on your SQL configuration.  For instance, if your source SQL stored data files on an H: drive and log files on an L: Drive, and your destination server does not have those drives, you may run into issues.  If you run into issues telling you that certain paths do not exist, you may need to go back to just plain SQL backups and a configuration-only backup.

    Hope that helps.


    Roger Cormier

    Microsoft
    Premier Field Engineer, SharePoint

    Blog: http://blogs.msdn.com/b/rcormier/
    Twitter: LinkedIn:

    Note: My posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

    Thursday, October 4, 2012 11:57 AM

All replies

  • 1. Does The Test 2008 Server, Where we want to restore the SP Backup, Has To Have the same server name as the source backup server ?

    You mean the Hostname of the Windows 2008 server I guess. No, that shouldn't be a problem. SharePoint content is stored in the content DB. As long as your Farm is able to connect to the SQL Server you should be able to mount a contentDB to your web Application. The Adressing of the Site is then done by the Web Application it self.

    2. What Other Prerequisites do we need to take into consideration ?

    Make sure you have installed all features and Solutions. They normaly install stuff into the .net GAC. Also configuration changes you might applied to the web.config muss be restored as well.

    3. What Do We need to do for the diffrence of the SQL Server location (the original database is on an external with one name, and the restore destination is a diffrenet name on the same server as the SharePoint).

    That's no issue. I've installed plenty of SharePoints with the SQL on the same server (Classrooms). It will be slower but that's about it.

    After all, if it's a test enviroment give it a try, get some experience and if you break it you do it again.

    Tuesday, October 2, 2012 10:05 AM
  • Thank You Hagen for Your Quick and Professional Response.

    1. Are The ".net GAC" you mentioned is the %windir%\assymple Directory ?

    2. Where is web.config is located ?

    3. When Restoring the Farm, do i need manually to change the accounts for the: DB,
    Services, Application Pool Identities as was on the original SP Server ?

    Is there any other accounts I need to change as they're where on the original server ?

    Thank you Again.



    • Edited by The_MichMan Tuesday, October 2, 2012 11:05 AM
    Tuesday, October 2, 2012 11:02 AM
  • Hi MichMan.

    It's not as easy as that(What Hagen said). SharePoint works in a single server Environment but you can't do restore anyway you want...
    Read the entire article on TechNet on the subject Before trying anything. You will benefit from that.

    Restore a farm in SharePoint Server 2010
    http://technet.microsoft.com/en-us/library/ee428314.aspx

    Among other things it states that:
    'You cannot restore a multiple-server farm to a single-server farm or a single-server farm to a multiple-server farm.'

    There is a lot to Think of, but just the notion that you are trying a restore Before you have even had a faliure is admireable.

    I hope that this helps you to move forward

    Regards


    Thomas Balkeståhl - Technical Specialist - SharePoint - http://blog.blksthl.com
    Download the SharePoint Branding Project here
    Download the SharePoint 2010 Site Settings Explained here

    Tuesday, October 2, 2012 11:16 AM
  • 1. Are The ".net GAC" you mentioned is the %windir%\assymple Directory ?

    yes

    2. Where is web.config is located ?

    in every IIS virtual directory and in the 14Hive. But if you don't know where to find them i guess you havn't changed them yet ;)

    Here is a nice Blog entry that gives you an overview what the web.config is all about.

    3. When Restoring the Farm, do i need manually to change the accounts for the: DB,
    Services, Application Pool Identities as was on the original SP Server ?

    What Thomas wrote. You can't just restore the farm to an other infrastructure. How ever, you can restore the Databases and then mount them to your new enviroment. There are different approaches to do Backup/Restore with SharePoint and they must be planed and tested. The Technet Link Thomas has posted is definitely the place to start.

    • Proposed as answer by Hagen Deike Friday, October 5, 2012 3:15 PM
    Tuesday, October 2, 2012 11:49 AM
  • Hi MichMan.

    It's not as easy as that(What Hagen said). SharePoint works in a single server Environment but you can't do restore anyway you want...
    Read the entire article on TechNet on the subject Before trying anything. You will benefit from that.

    Restore a farm in SharePoint Server 2010
    http://technet.microsoft.com/en-us/library/ee428314.aspx

    Among other things it states that:
    'You cannot restore a multiple-server farm to a single-server farm or a single-server farm to a multiple-server farm.'

    There is a lot to Think of, but just the notion that you are trying a restore Before you have even had a faliure is admireable.

    I hope that this helps you to move forward

    Regards


    Thomas Balkeståhl - Technical Specialist - SharePoint - http://blog.blksthl.com
    Download the SharePoint Branding Project here
    Download the SharePoint 2010 Site Settings Explained here

    Thank you for the link, as I understand we don't have a Multi-Server Farm, and we are
    restoring to a Single-Server Farm.

    Correct Me If I'm Wrong.

    I Will Try To Follow the Link given By You and hagen And Will Update if the Restore was
    Successful or we encounter other Problems.

    Thank you both.



    • Edited by The_MichMan Wednesday, October 3, 2012 10:23 AM
    Wednesday, October 3, 2012 10:23 AM
  • I think the article referenced (Restore a farm in SharePoint Server 2010) May have some ambiguous wording in it - which isn't surprising, considering it hasn't been updated in over 2 years.

    Just to clear this up... the "single-server farm" they're talking about is this:
    Deploy a single server with a built-in database (SharePoint Server 2010)

    If you have 4 servers in your production farm, and you only have 1 SharePoint server, which also runs on the same server, this does not mean it's not possible to restore your farm.

    That also doesn't mean that you won't run into issues.  Drive configuration and file placement on the database server (think having multiple data files) could also cause some issues with the restore process.  In that case, you could still always, as Hagen pointed out, restore the databases using SQL tools instead of PowerShell, or the SharePoint backup.

    Hope that helps.


    Roger Cormier

    Microsoft
    Premier Field Engineer, SharePoint

    Blog: http://blogs.msdn.com/b/rcormier/
    Twitter: LinkedIn:

    Note: My posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.


    Wednesday, October 3, 2012 8:57 PM
  • I think the article referenced (Restore a farm in SharePoint Server 2010) May have some ambiguous wording in it - which isn't surprising, considering it hasn't been updated in over 2 years.

    Just to clear this up... the "single-server farm" they're talking about is this:
    Deploy a single server with a built-in database (SharePoint Server 2010)

    If you have 4 servers in your production farm, and you only have 1 SharePoint server, which also runs on the same server, this does not mean it's not possible to restore your farm.

    That also doesn't mean that you won't run into issues.  Drive configuration and file placement on the database server (think having multiple data files) could also cause some issues with the restore process.  In that case, you could still always, as Hagen pointed out, restore the databases using SQL tools instead of PowerShell, or the SharePoint backup.

    Hope that helps.


    Roger Cormier

    Microsoft
    Premier Field Engineer, SharePoint

    Blog: http://blogs.msdn.com/b/rcormier/
    Twitter: LinkedIn:

    Note: My posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

    The Two Link's Provided By You Are Both The Same.

    Does One SharePoint Server (One Computer) And Its One Database's Server (Second Computer) Are considered as a Multi-Server Farm, and cannot be Restored To a Computer That have Both, the sharepoint server and the database ?

    Thank you.

    Thursday, October 4, 2012 7:01 AM
  • I've corrected the link in my post now, it's still incorrect in your quote.

    If you did an actual SQL install, versus using the "built-in" database that you get when you choose "single server" in the installation GUI (or pass it as a command line parameter), then you should be alright.


    Roger Cormier

    Microsoft
    Premier Field Engineer, SharePoint

    Blog: http://blogs.msdn.com/b/rcormier/
    Twitter: LinkedIn:

    Note: My posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

    Thursday, October 4, 2012 10:31 AM
  • I've corrected the link in my post now, it's still incorrect in your quote.

    If you did an actual SQL install, versus using the "built-in" database that you get when you choose "single server" in the installation GUI (or pass it as a command line parameter), then you should be alright.


    Roger Cormier

    Microsoft
    Premier Field Engineer, SharePoint

    Blog: http://blogs.msdn.com/b/rcormier/
    Twitter: LinkedIn:

    Note: My posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

    Thank you Roger,

    So to Summurize this point:

    When Using The Backup-SPFarm, and Then Restore-SPFarm:

    1. One Share Point Server And Diffrent Database SQl Server To One SharePoint Server and in the same server an Sql Server installation - Possible ?

    Thursday, October 4, 2012 11:28 AM
  • Yes, that will be possible, but you still may run into problems, depending on your SQL configuration.  For instance, if your source SQL stored data files on an H: drive and log files on an L: Drive, and your destination server does not have those drives, you may run into issues.  If you run into issues telling you that certain paths do not exist, you may need to go back to just plain SQL backups and a configuration-only backup.

    Hope that helps.


    Roger Cormier

    Microsoft
    Premier Field Engineer, SharePoint

    Blog: http://blogs.msdn.com/b/rcormier/
    Twitter: LinkedIn:

    Note: My posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

    Thursday, October 4, 2012 11:57 AM
  • http://gallery.technet.microsoft.com/backup-Full-and-Differentia-5bbae819

    backup Full and Differential SharePoint farm day by day.Using Stsadm for SharePoint 2010 / 2007 


    Deepesh Yevle - MCTS MCITP

    Thursday, June 6, 2013 1:54 PM
  • https://www.youtube.com/watch?v=K_G_NADFfHE

    In This Video , I take you through Step by Step instructions answering two questions :
    1-What should you backup (From SharePoint , SQL Server , IIS)
    2-What should you do in every Disaster data loss.

    I give 13 Disasters of Data loss and step by step what should you do.
    I also show you how to automate your backup process and schedule  it  .

    Thursday, July 31, 2014 1:40 PM