Deployment Solution

 View Only
  • 1.  Backing up SQL Express DB for DS6.9 SP6

    Posted Dec 05, 2014 03:54 PM

    Anyone know which DB files and the location of the files using DS6.9 SP6 need to be backed up for SQL DB restoring purposes?

    I am running DS6.9 SP6 on Server 2012, SQL Express 2012. I usually just backup the DB files manually with SQL shutdown, but it appears the locations have changed under the newer versions of SQL/SQLExpress.

    Thank You,

    Sean



  • 2.  RE: Backing up SQL Express DB for DS6.9 SP6
    Best Answer

    Trusted Advisor
    Posted Dec 06, 2014 04:51 AM

    If you've got something in there which is changing the defaults here and you can't navigate around SQL Server Management Studio, these commands executed in a command window should locate these .bak files for you,

    cd c:\
    
    dir /s /b *.bak

    Might take a few minutes, but it's a sure fire method! Also, once finished, re-execute it for any other fixed drives you've got.

    If you DON'T have any .bak files come up, then you've got a different problem as the backups aren't running.