Open Microsoft SQL Server Management Studio

If you don't have Microsoft SQL Server Management Studio you can download and install it from here

Connect to the SQL Server instance with the current Microsoft SQL Server Book on it

1. Expand Databases

2. Select the Microsoft SQL Server Book / Database to move.

Ex: Demo Book

1. Right Click on the Book

2. Select Tasks->Back Up...

1. Select Copy-only backup

1. Click the Add button

1. Click the ... button to specify the file name for the backup

2. Select a Path

3. Enter a File name

4. Click Ok

Click the OK button

Click the OK button

If the backup is successful you will see the following message

Create EZ Arms Keeper login on new server with EZ Arms Keeper

1. Open EZ Arms Keeper

2. File->Open

3. Bound Book Type: Microsoft SQL Server

4. Server Name: Microsoft SQL Server Instance name the book is being moved to

5. Method: SQL Server Authentication

6. Login: Login that has permissions to create databases and add logins

7. Password: enter the password

8. Bound Book Name: TestBook

9. Click the OK button

Creating the TestBook on the server will also setup the EZArmsKeeper login on the server which will be important for restoring the backup

Connect to the SQL Server instance that the Book is being moved to

1. Expand Databases

2. Select the TestBook

3. Right Click on the TestBook

1. Select Delete

Select OK

1. Select Databases

2. Right Click on Databases

3. Select Restore Databases

1. Select Device

2. Click the ... button

Click the Add button

1. Select the file that was previously backed up

2. Click the OK button

Click the OK button

1. Click the Files page

2. Click the Relocate all files to folder Option

3. Click the OK button

If the database was successfully restored you will see the following message

1. Expand the Database that was just restored

2. Expand Security

3. Expand Users

4. Select EZArmsKeeper

5. Right Click on EZArmsKeeper and select Delete

Click OK

1. Select Users

2. Right Click on Users

3. Click New User...

Click the Login name ... button

Click the Browse button

Select the [EZArmsKeeper] Login

Click the OK button

Click the OK button

1. Copy the Login name and enter it as the User name

2. Enter dbo for the Default schema

Select the Membership Page

Select the following Database roles

• db_accessadmin

• db_backupoperator

• db_datareader

• db_datawriter

• db_owner

• db_securityadmin

Click the OK button

The Book has now been setup and should be able to be opened via EZ Arms Keeper

Open EZ Arms Keeper

Open the Bound Book via File->Open

Bound Book Type: Microsoft SQL Server

Server Name: Enter the Microsoft SQL Server Instance Name. If the SQL Server Browser Service is running and the Firewall is properly configured then you can select the dropdown and select <Browse for more...>. This should populate the list of available servers to select from.

Bound Book Name: Name of the Book that was moved. You can select the dropdown and select <Browse for more...>. This should populate the list of available bound books on the server to select from.

Click OK

If you are able to successfully open the book you will see the EZ Arms Keeper update the Acquistion Counts, etc.