1-888-365-2779
+1-888-365-2779
Try Now
More in this section

Forums / Bugs & Issues / Database backup

Database backup

6 posts, 0 answered
  1. Richard
    Richard avatar
    164 posts
    Registered:
    21 Nov 2009
    03 Feb 2011
    Link to this post
    Hi

    We;'e tyrying to set an automatic database backup and are running into problems. It won't let us attach to it in SSMS whilst the website is running. How should this be done?

    Thanks

    Cheers
    Richard
  2. Radoslav Georgiev
    Radoslav Georgiev avatar
    3370 posts
    Registered:
    01 Feb 2016
    05 Feb 2011
    Link to this post
    Hi Richard Cross,

    If you are trying to attach an mdf file to SSMS while the website is still running you will not be able to do this. This is because the application pool identity in which your website is running is putting a lock on the mdf file since it is working with it. What you have to use is to stop the website, attach the mdf file and schange the connection string in ~/App_Data/Sitefinity/Configuration/DataConfig.config to use the database attached to your SQL server. Then you will be able to perform automatic backups.

    All the best,
    Radoslav Georgiev
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. Rich
    Rich avatar
    27 posts
    Registered:
    20 Feb 2010
    08 Feb 2011
    Link to this post
    Could you explain this configuration change more specifically?  I'm looking to use Microsoft Backup (DPM) of SQL Server and need to understand how to take a safe backup. 

    Thanks,
    Rich
  4. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    12 Sep 2017
    10 Feb 2011
    Link to this post
    Hi Rich,

    My colleague explained that you had to stop Sitefinity server and use Visual Studio "Deattach" option, because the MDF could be locked. You can use Microsoft Server Management Studio to create a backup.

    Kind regards,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  5. Rich
    Rich avatar
    27 posts
    Registered:
    20 Feb 2010
    13 Feb 2011
    Link to this post
    Ivan,

    I'm looking for a hot backup solution.  I've traditionally used BackupExec or Microsoft DPM with the SQL extension to backup my databases every 2 hrs to allow rollback.

    It appears that Microsoft DPM still works fine for backing up and restoring MS SQL Server databases for Sitefinity.  Is there any reason to think otherwise?

    Thanks,
    Rich
  6. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    12 Sep 2017
    18 Feb 2011
    Link to this post
    Hello Rich,

    I have not used Microsoft DPM with the SQL extension, but the Sitefinity database is standard SQL database, so I believe that there would not be problem if the DPM supports your requirements.

    Best wishes,
    Ivan Dimitrov
    the Telerik team
6 posts, 0 answered