Windows Shared MSSQL Frequently Asked Questions

If you are on a Windows Shared hosting account and have questions regarding MSSQL, we have compiled the following list of some common questions and answers.

Is there a database size limit on MSSQL?
There is no set database size limit, but TOS disk rules/restrictions apply.
Can we use the full-text search with your server?
Full-text search is not enabled for Windows Shared hosting
Can I use stored procedures with your MSSQL server?
Yes, stored procedures are allowed, and you may create them without interaction from our Administrators.
Are there any features that you do not allow on your MSSQL server?
We are not able to support or provide the features:
- bulk insert
- full-text search
- database mail

Do you have another Windows Shared MSSQl question? Please contact us via phone or chat for further assistance. You can also let us know by filling out this article’s survey pop-up to rate the article. You’ll have the opportunity to provide us feedback, like your other questions regarding Windows Shared MSSQL, to improve this article.

HostGator is committed to making it easy to transfer your site to your new hosting account. We can transfer website files, databases, scripts, and one free domain registration transfer.

What qualifies me for a free transfer?

HostGator provides free transfers for new accounts within 30 days of sign-up, and to newly upgraded accounts. For upgraded accounts it must be an inter-server upgrade to qualify. Please note that downgraded accounts do not qualify for free transfers.

Depending on which type of account you sign up for, we offer differing numbers of free transfers. Please refer to the chart below to see what we include for new packages.

Full cPanel Transfers is the number of cPanel to cPanel transfers that are included.

Max. Manual Transfers is the maximum number of Manual Transfers that are included with your account.

Total Free Transfers is the total number websites that we will move for you.

Account Type	Total Free Transfers	Full cPanel Transfers	Max. Manual Transfers
?Shared	1	1²	1
?Reseller	30	30²	30
?VPS	Unlimited¹	Unlimited²	10 per VPS level
?Dedicated (Basic)	Unlimited¹	Unlimited²	75
?Dedicated (Standard, Elite, Pro)	Unlimited¹	Unlimited²	100

¹While we can do unlimited cPanel to cPanel transfers for you, depending on your account, you will have a limited number of Manual Transfers.

²Full cPanel transfers include all domains, Addon Domains, Subdomains, and cPanel settings. This will also include your emails and email accounts. Please note that this does require that your old host's cPanel backup generator to be active.

A few examples: An Aluminium Reseller account includes up to 30 free transfers. Out of this 30, you can have 20 cPanel to cPanel transfers and 10 Manual Transfers, or any combination of the two that totals 30 or less websites. Another example: A Pro Dedicated server includes unlimited cPanel to cPanel transfers, this means you can have 150 sites (or even more) moved. Also since there is an unlimited total number of transfers, you can utilize up to 100 Manual Transfers.

For more information please see ourTransfers Support Article, contact our transfers department at transfers@hostgator.com, or call 866.96.GATOR