Attaching a Database
SOLUTIONS
Inventory Manager
Control Center
NSMC
TASK
How To attach a database to an existing SQL or MSDE Server.
HOW TO
When doing an install, you might choose a Custom Install because of a pre-existing SQL server in the environment. If so, attach the database files installed during the install process to the preexisting SQL Server. Use the following OSQL command to make the attach:
Osql /E /S localhost\INSYSTEK /Q "sp_attach_db 'NSMC', '[SQLPath]\NSMC.mdf', '[SQLPath]\NSMC.ldf'"
»
|