How do I manage my Microsoft SQL database?

We recommend using SQL Server Management Studio (SSMS) for managing your Microsoft SQL databases.

This industry-standard software provides a comprehensive environment for Microsoft SQL database creation, access, configuration, development, and other management features. It includes a variety of components including visual database tools, code and text editors, object management, boilerplate text management, and more. With SSMS you can deploy, monitor, and upgrade the data-tier components used by your applications, as well as build queries and scripts.

SSMS also helps you download and back up your MS SQL databases, which we recommend you do at regular intervals in the interests of best practice security.

You can download the software for free on the Microsoft SSMS download page.

To connect remotely you will need to use Server ''.

You will also need to enter your database name in the "Connect to database" field found under "Options" or "Connection Properties".

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How do I connect to my database via .NET?

A website built using .NET can be connected to databases of different types: MSSQL, and Access...

Can my database be restored from a bacpac file?

We will happily restore your database from a bacpac file. Please open a support ticket to...

What is the database containment type?

All of our databases use the "Partial" containment type. You can learn more about contained...

Can you restore my database from my old/current SQL server?

We will happily restore your database from your old/current SQL server. Please open a support...

How do I restore my database?

You will need to export your database using Generate Scripts with some advanced settings...