More in this section
Forums / Deployment / Restoring SF DB from Prod to Dev

Restoring SF DB from Prod to Dev

The forums are in read-only mode. In case that you want to directly contact the Progress Sitefinity team use the support center. In our Google Plus group you can find more than one thousand Sitefinity developers discussing different topics. For the Stack Overflow threads don’t forget to use the “Sitefinity” tag.
5 posts, 0 answered
  1. Chris
    Chris avatar
    10 posts
    13 Jan 2011
    15 Sep 2011
    Link to this post
    In our development & production environments we have SF, we just did our first backup/restore from production to development(to get a fresh copy of what production looks like), and we're having some issues.  We can login to the SF backend, but when we click on Pages, Content, ... etc. we get a 404 popup message.  This happens repeatedly and the only way to stop it is to kill the browser(we're using IE 8, but we're having the same issue with Chrome & FF). 

    The database name is the same in dev & prod and all the connections from the application to the database seem to be working(we're able to login to SF backend).  I've looked through the .config files in App_Data/Sitefinity/Configuration folder, but nothing jumped out at me as being incorrect.
    1. The connections string int he DataConfig.config looks good
    2. The projectName in the ProjectConfig.config matches what I am seeing in the tables: sf_page_node, sf_object_data

    We can get to the development web site, and there aren't any broken links there, so it's just the backend that's having problems.

    I'm not sure what else to check.  Any suggestions would be appreciated.
  2. Victor Velev
    Victor Velev avatar
    1345 posts
    06 Jul 2015
    16 Sep 2011
    Link to this post
    Hi Chris,

    Can you run Firebug and check what comes up in the Net tab? Also can you login in the backend of the website and reproduce the errors - then attach the trace log  and send it to me so I can have a closer look at the service exceptions ( if the system caught any ).

    Please consider reviewing the following forum thread.

    Victor Velev
    the Telerik team
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. Chris
    Chris avatar
    10 posts
    13 Jan 2011
    19 Sep 2011
    Link to this post
    From Firebug(Net Tab),


    Params Tab
    hierarchyMode true
    itemType Telerik.Sitefinity.Pages.Model.PageNode
    managerType Telerik.Sitefinity.Modules.Pages.PageManager
    sortExpression Title ASC

    Headers Tab
    Content-Type text/html
    Set-Cookie .SFAUTH=47A7C7EB22551AB650F361115A1C2028A8F3FB334AE90A5467F552D9521A0E4C5C7DE7E6B3F1A93A566E023396AD4F8DC21C34119EF5D74383BB2E766C478ADEF9FEFB01F1EA6AA64478C2E7706A35CD0630C8D0F123DDFB7388E7B8AB2833BE81814E627AD56CBB8B0099564AB459DEFA3160C338E6ED8D8C9E815B3F33E53D36BFC119E81EE47C5836FA17A0EDEFA29ECE38CBD53FD7120B2CD50237B60C48902D0A09F67D842EB7C13E613138E8C22F6FA7E99B94A30F49E8EE457EF05261EEDDB34CEDDBDB2CA10484A5876E485D4D36BF4B8AFA1EB7AA7E537B08E2881293E9138812451F3F60587B3BD6600F1BFCFD34D39A5D58ECE6B5C992CB90CE17771C00786837CE223B7F6D6EFA58B249; expires=Fri, 16-Sep-2011 18:06:18 GMT; path=/; HttpOnly
    X-UA-Compatible IE=8
    Date Fri, 16 Sep 2011 16:06:18 GMT
    Content-Length 1245
    Request Headersview source
    Host ndbhdev
    User-Agent Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv: Gecko/20110303 Firefox/3.6.15 ( .NET CLR 3.5.30729; .NET4.0E)
    Accept text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    Accept-Language en-us,en;q=0.5
    Accept-Encoding gzip,deflate
    Accept-Charset ISO-8859-1,utf-8;q=0.7,*;q=0.7
    Keep-Alive 115
    Connection keep-alive
    X-Requested-With XMLHttpRequest
    Referer http://ndbhdev/Sitefinity/Pages
    Cookie .SFAUTH=DE7C59C72362BEE55F54158EA4F4BF3FCFC358F2FD72EF98DA01A69DEBCCE08D8649BEFFD467F59F5BB592673D384BE40F17E8A99869983CE5DB4CF0C7F62312D39423458FF5A35C0B45ACABF08BD11C65AC71330568A499AF1189E3BD56DF6BB4D74938C8B0B2A0D3AD049958F70FA7BA983E1D725F2B33A523F1EA991D8B617D641150949FD4F66F5DB383D11F6B706FD75C820E4F49A01326EA1EF197E0CCC20B578D0638A045913A347CCF4B8D5495E1A3CE19F97E1FF355FEAC475F87175DF9EE96EA349C939859F8D3C3FAF18FE78EA546E40A1CE18B04FF68E54DCE55B3193072EAFBF8FAE2D3055C9C32173C19AB88E61F263B03C26C5E69192D73D4E77C587657C05DB6700EC672DADAB6AC; .SFROLES=9CCpy3qt8i+tlz4FO0oSiWIIHwRmzAkjeAHPgir90QeJE0qJnIQ8wzoUus9UBFytjyBRguuxCwLq0QD587jI6H/Ynvr5qbG7SZglnKnEuCNTJkBJUslF9vaRmHj2GAchugB3b3uqYsDdwgW+utNUFkR+B3g+cBONkhXjw2MXcFMyBhOHxZuvganzGErlsGlkbGygbV9YwF+3wWCvpeo4qrGlps/ep6syX76f8utBSpoLO/U/cfj5oU3m8VNKrUcMVuKmAugoeTjXwTP7uqCaszXffAEGuYZ6IqNc8XsVmvPe2iKCZ2ugZIW5A0dqNbIG5juhm+GZwPigauZ3E8MaxmVLSbSG5Zm+fStl4kTA0JyAmrHXlruNnM5Mxdm1tjZ5bQgohYRK2g6dphsdZZKlXguiTNpf/blVkRL7dlHmdVCCTT05O+F12+yo3Dbe0Fdb7Rv6h9+HfPm06S83aEZtiaYMbkbZS1k2OBkbsTcuhcpO4tE3DeumbXdeSBrx0OIJ0cXgeqb5Enf/DXXwng0S6fZ0jV4dwIJ9OYaDmGHVWgcC0ZxHnmZRgBey+bptF7e78y/lqO5A+SKDlp9LwMFDb4Dvj4P3gQy8OTOYAT85TrFQEgo67YL762MFOh03RpRptszWzR8Nr39zG4qGIMSY+nsYNtUy7g61ioQ1hCzTG+ibvFnvF8XElRhTIM7xzN7vayKz70wam6/GaoB6JR7Ayrq84/v3LHXt+XpsA6Sua4zfkExDomiJqAFlhGzzd2uOlcDMa2I6rRZSsRYX5JRs9CawDJ/nLNCm0bDp9LiOSMk4KouCczdO5mbnomJDRCdsmzLeIJsFwYkGnj5/xwK2mEF2D6BXOxXAIZ2lq0h+uqxGvwr743gSSFkvZgaXDe7ufx4qQOR+g9tg8+FsBJ5w6oJt2KqWBiCbXaN9ahbT+RnFo2wdUFiWZvfTzBcFZwx3xIJZNj3EEDQwpWFkpugDsU67bIEAxx/GV860EJjSbl2gb+yeFhBdv8celSeoPOkOjQQF2BMzZCZpa1qVuERs8lVz/MJ8Dzd4XyBvXWD7AuoAnXPc1lSmrh8L4tc7DW9EJByCnNSBFj0vGPgs+qmOREUe8eMLVMx8AVAAA/JIC+gtGNwVBn6fa5zl2LplOma1LijAnWv2XAKAq8NiuwZoTnjaKqY4aOrn9MCuTxWQK/s7tPJ6uYk6nlVBVtncowbqqo8ZG/qd4tIxzw/riO1Yp2IA5yUWe3NZSRaw+yOOcaZXgItdgVy6OGsmvVqsyWRx0u0ViihoGVm8AwAA; .ASPXAUTH=B8E66F56D637A3E9E2FC270DAE796875DA3155B2C7BDCADF7D6071C8AD5A91230649C6A9F3619DD2ECC23B11DFC5C93B8FE698DF5338847DFA1717DA2E04E6ED96ED67B69C49E6176583245C88F1E762B6FFB150CF741604A79C30A62F950186F396C6E4976A6FFB069CC825159418C2CCEC96F994372348E60691DD095E3AAA9C0BCA3971A3516F9BE19A95062FA431; SessionCookie=1digqat5golb0u44bhnhhnib

    Response Tab
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "">
    <html xmlns="">
    <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"/>
    <title>404 - File or directory not found.</title>
    <style type="text/css">
    body{margin:0;font-size:.7em;font-family:Verdana, Arial, Helvetica, sans-serif;background:#EEEEEE;}

    fieldset{padding:0 15px 10px 15px;}
    h3{font-size:1.2em;margin:10px 0 0 0;color:#000000;}
    #header{width:96%;margin:0 0 0 0;padding:6px 2% 6px 2%;font-family:"trebuchet MS", Verdana, sans-serif;color:#FFF;
    #content{margin:0 0 0 2%;position:relative;}
    <div id="header"><h1>Server Error</h1></div>
    <div id="content">
     <div class="content-container"><fieldset>
      <h2>404 - File or directory not found.</h2>
      <h3>The resource you are looking for might have been removed, had its name changed, or is temporarily unavailable.</h3>

    I'm still working on the trace log for SF, it doesn't seem to want to want to output anything.

    Can you provide me information on how SF builds out urls/pages?

  4. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    12 Sep 2017
    20 Sep 2011
    Link to this post
    Hi Chris,

    Please send the service tracer log from the error. Most probably your machine - dev and production are not having the same configuration. It looks like there is some issue with the service. You can take a look at our installation and administration guide to see if all requirements are met and settings are correct.

    Ivan Dimitrov
    the Telerik team
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  5. Chris
    Chris avatar
    10 posts
    13 Jan 2011
    20 Sep 2011
    Link to this post
    Hi Ivan,
    It turns out another developer(unbeknownst to me) installed some software on our dev server(url scan or something similiar) that was causing the problems with SF.  So it wasn't a SF issue.
    Thanks for your help.
5 posts, 0 answered