Database operations
Database operations
The Database Wizard allows you to also perform several common database operations. These can also be done via SQL Server Management Studio.
Rename Database
To rename your database, you can do one of the following:
- Use Microsoft SQL Server Management Studio. Right-click on the database and rename it from there or,
- Use the HelpMaster Database and Reports Wizard to back it up and then restore it with a new name.
Backup Database
Restore Database
Attach / Detach Database
Execute SQL
To execute SQL directly against your HelpMaster database, you can use this screen.
No undo!
Please note that there is no undo with SQL. Once an SQL statement has been executed, there is no simple way to undo it. Please ensure that you know exactly what the SQL statement is doing before executing it (test on a backup/dev database), and ensure that you have made a full backup of your database just in case.
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.