Tables Not Listed - MS SQL

Database Tables Not Listed

• If you are unable to see any of the tables in your MSSQL database using SQL Management Studio you may need to set your database user as the database owner.
• You can set your database user as the database owner in the WCP by doing the following:

1. Click on "MS SQL"
2. Click the "Edit" button next to the database
3. Select your database user from the "Database Owner" drop-down menu
4. Click "Save"

Backing Up Database

• Backing up your database in SQL Management Studio is not supported on our MS SQL database servers.
• The reason for this is that doing this creates a backup file on the database server which can be very large depending on the size of your database.
• If you need a copy of your database you'll need to use the MyLittleBackup Tool in your WCP.