Deleting a database through ScfUtils (Model Explorer)
|
|
• Only Modeler System Administrators and Database Owners (dbo) can perform this task.
|
|
|
Before deleting a database, you must consider the following:
• It is recommended that you backup the database before deleting.
• Ensure that no user is currently working on the database that is to be deleted.
|
To delete a database using the ScfUtils command
ScfUtils provides a command line interface for performing Model Explorer functions.
You can delete a database through ScfUtils.
If you have installed Modeler to the default locations, ScfUtils resides in the following location:
<<INSTALLDIR>>\Modeler\Exe\SCFUtils.exe
For information about deleting a database through Model Explorer refer to
Deleting a database (Model Explorer).
Syntax:
ScfUtils -deletedb Enterprise "<database-ref>"
Where:
• <database-ref> specifies the reference to a database for deletion.
Enter the database reference in the following format: \\SQL\<instance-name>\<database>
Example:
ScfUtils -deletedb Enterprise "\\SQL\Server1@MODELER\ModelerDB"