Databases - SQL
Error while transfering a SQL Databases
The Situation:
"I can access my web site just fine, and I can attach to and browse the SQL server
just fine using Enterprise Manager. However, I'm receiving a login error when I begin the
'transfer' from my local SQL server to the SQL server. What's going wrong?"
Suggested Action:
Due to restrictions with SQL you have to have SA (SQL administrator) on the server you
are transfering to. The best way to transfer a SQL database over is to do a SQL
dump of the database and FTP it to your account. Once this is accomplished send us and
make a support ticket to notify us that you need it restored and
where to find it in your site content.
Database size
The Situation:
"I need to set up a couple of databases for me on the SQL Sever. Both are quite
large. Are there any additional costs associated with this?"
Helpful Information:
Due to the resources and methods involved in running and administrating SQL servers,
SQL server space doesn't be included in all webhosting plans.