Navigation

    ML
    • Register
    • Login
    • Search
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    1. Home
    2. Tags
    3. sql server management studio
    Log in to post

    • SQL Server Express 2014 Extremely Slow on Network
      IT Discussion • windows 10 rdbms sql server management studio sql server 2014 kennel connection kennel connection 7 • • scottalanmiller  

      12
      0
      Votes
      12
      Posts
      249
      Views

      P

      @scottalanmiller Did you ever solve this problem? Just wondering what you solution was if you did.
    • Learn how to keep your sensitive data safe with SQL Server Always Encrypted
      Starwind • starwind powershell azure sql server sql server management studio sql server always on ssms • • Oksana  

      1
      3
      Votes
      1
      Posts
      303
      Views

      No one has replied

    • SQL Management - Backup to new DB
      IT Discussion • sql express server2012r2 sql server management studio sql server 2012 sql management • • gjacobse  

      8
      0
      Votes
      8
      Posts
      1141
      Views

      I got it restored to a new db,.. but i did have to change the file name.
    • Create SQL History Database
      IT Discussion • backup database sql server server 2012 restore sql server 2012 sql server management studio • • gjacobse  

      13
      1
      Votes
      13
      Posts
      1988
      Views

      In this case, it was a matter of the settings during the restore. Under GENERAL you had to select your source and destination as normal. Destination was changed so that it was the new History file. Under FILES you updated the DB and LOG files to reflect the new DB, otherwise you would over write the originals. This is where they borked it. They didn't mention FILES only going to OPTIONS, and there is where they mentioned updating the file names. The main discovery was that you need to uncheck LEAVE Source database in the restoring state. When I emailed them about removing the 'borked' databases I had created the called me back. I mentioned it to the fellow and we had a short discussion on the matter where he took notes and agreed that the directions were incorrect. When I got to the part about unchecking LEAVE Source database in the restoring state he mentioned that he uncheck Take tail-log backup before restore Hope this helps.