Databases
Backups, restores, and database administration
- Can I set my database hostname as ‘localhost’? No, you would need to set the database hostname as the server that it's on at UmbHost. You can find this by going to the SQL Databases area within your
- 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 request this.
- 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 ticket to request this, being sure to include your
- 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 databases. You need to use a specific connection string to
- 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
- How do I restore my database? You will need to export your database using Generate Scripts with some advanced settings configured for the restore to complete successfully
- I cannot see database details in my sub user account For security account sub users are not automatically granted access to see the service owners database details/credentials. If you wish to share your
- I'm receiving error "SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process.", how do I fix it? When trying to connect to our SQL servers you may receieve the following error: SqlException (0x80131904): A connection was successfully established with
- What is the database containment type? All of our databases use the "Partial" containment type. You can learn more about contained databases here
- What’s the MSSQL database size limit? At UmbHost, each MSSQL database can store up to 5120 MB (5 GB) of data, and you can store up to 500MB of LOGS. As databases comprise of only text, this is
- Where do I find my MSSQL Database information? The MSSQL Database details can be found in the "SQL Databases" area in your My.UmbHost account.