Before following this FAQ, please read
FAQ 112 - How to Migrate NumberCruncher All
Orders to MS SQL
The following FAQ will provide you with an installation utility
and guidance on installing and configuring MSDE. Note: If you has MS
SQL Server you do not need MSDE.
MSDE only needs to be installed on the computer the will store
your data files. It does NOT have to be installed on every user's machine.
Download and run
MSDEInstallSetUp.exe. This is a self extracting file
that will copy the MSDE Installation and Management Utility as well as the MSDE installation files to your machine
using a default directory of C:\MSDEInstall. The MSDE installation files
will be installed to sub-folder C:\MSDEInstall\MSDE.
Close all running applications.
Using Windows Explorer navigate to C:\MSDEInstall and double click
MSDEInstall.exe. You will see a screen that looks like this:
At this point you are only concerned with the Install MSDE
button. If this button is disabled (grey) then MSDE is already
installed and you should press Exit. If its enabled, click the
button and follow the onscreen instructions.
MSDE will be installed in the sub-directory C:\Program
Files\Microsoft SQL Server. The sa password is sysadmin and the Security
mode is SQL. Press Exit.
Note: At this point you have not created any
databases so you should not use the Database Management buttons.
Now that MSDE is installed you need to allow access to client
machines. Navigate to sub-folder C:\Program Files\Microsoft SQL
Server\80\Tools\Binn and double click SVRNETCN.exe. You will see a screen that
looks like this.
Make sure that Named Pipes in Enabled. You may need
to enable other protocols to use the database on an IIS server.
RESTART THIS COMPUTER TO ENSURE THAT ALL SETTING ARE PROPERLY
You are now ready to create a database and transfer data from
FAQ 114 - Converting NumberCruncher data
from Access to MS SQL.
You should use MSDEInstall.exe for Back up and restore
procedures. When you create a database in MSDE, 2 files are
created in sub-folder C:\Program Files\Microsoft SQL Server\MSSQL\Data being
dbname.MDF, the data file, and dbname.LDF, the log file.
Attach and Detach work together.
Attach, attaches an existing MDF file to the server and Detach, does the
opposite. Once a file is detached it cannot be used. You
would use Attach/Detach to:
Move the database to another server
Move the database files to another hard drive or computer
Make the database unavailable
To Attach a database, pick the file using the Browse
button and input the Database Name (This should autofill). To detach the
database, wimply type in the
Backup and Restore work together.
You should back-up your database daily. Should you have data
loss, you can quickly recover the data by using the Restore function.
Note: By default, NumberCruncher uses the Simple Recovery
method. Meaning the data can only be restored from the last back-up.
Other recovery methods (eg FULL or BULK) can be used which will restore from the
time of the data loss based on the transaction log. You can implement FULL
recovery methods yourself if you have Enterprise Manager.
Call to speak with a NumberCruncher Solutions Consultant at: