Restoring Kennel Connection 6 .bak backup file through SQL Management Studio

Restoring Kennel Connection 6 .bak backup file through SQL Management Studio

You will need to have SQL Management Studio installed on your computer to do these steps.  This will require a .bak format backup of your SQL Server Database file.


Please note:  In the steps below, the database name is Test DB.  You will need to name the database 'wkennel' without the quotations in order for Kennel Connection to read the database properly.


1.  Open SQL Server Management Studio in Object Explorer Right.


2.  Click on 'Databases' node and select 'Restore Database'



SQL restore



2.  'Restore Database' dialog will be displayed on the General page.


3.  The name of the restoring database appears in the To Database list box.  To create a new database, enter its name in the list box.


4.  Select 'From Device'


5.  Click button to display 'Specify Backup' Dialog


6.  Click 'Add' to browse the .bak file from the directory and click OK



SQL restore



If the above steps fail, click the Options tab and select "Restore (With REPLACE)" then click OK.  This will allow SQL Server to replace the database file with the .bak backup file.


    • Related Articles

    • Downloading and Installing SQL Management Studio Only

      Downloading and Installing SQL Management Studio Only, no Login Warning:  SQL Management Studio gives you full access to your SQL Server and your databases.  Any changes made in this program could severly impact the Kennel Connection database and the ...
    • Restoring your Kennel Connection 6 database

      There may be times when you have to restore your database to a new computer. IMPORTANT:  When you restore the database, it will overwrite any data that is currently there.  If you are not sure whether you have or want to save any data on the ...
    • Restoring the Kennel Connection 7 database using Microsoft SQL Management Studio

      Restoring the Kennel Connection 7 database using Microsoft SQL Management Studio If you have been advised to use SQL Management Studio to restore your KC7 backup, there is a good chance it is because there are Windows or SQL Server permissions ...
    • Restoring the Kennel Connection database using Microsoft SQL Management Studio

      Restoring the Kennel Connection database using Microsoft SQL Management Studio Restoring the Kennel Connection 7 database using Microsoft SQL Management Studio If you have been advised to use SQL Management Studio to restore your KC7 backup, there is ...
    • Installing Kennel Connection 7 & SQL Server

      Installing Kennel Connection 7 & SQL Server Welcome to the installation guide for Kennel Connection 7.  Kennel Connection 7 is compatible with Windows 7 or higher operating systems.  Windows 10 is recommended.  Important:  If you are installing ...