Database SQL Server

Modified on Thu, 09 Feb 2017 at 03:28 PM

Q: What is SQL server and why do I need it?

A: Most .NET-based e-commerce solutions, including AspDotNetStorefront, require a Microsoft SQL server database. The database is used to maintain the customer, product, and order information for your website. SQL server allows your site to be more customizable and perform better under heavy user load.

Q: Can I get remote access to my database?

A: Yes, remote access to the database is provided to clients who supply us with a static IP address to add to our firewall. Without a static IP address, clients will be unable to connect directly to their live database. Please contact us to request remote database access.

Q: How can I connect to my database?

A: Any SQL program should allow you to access the database server. We suggest you use Microsoft SQL Management Studio.

Q: What are your Database backup policies?

A: Databases are backed up once a day and stored in an off-server location. Full backups are taken weekly and differential backups are taken each night. AspDotNetStorefront maintains these backups only for disaster recovery. Customers should request a database backup from our Help Desk before making any changes that could result in data loss.

Q: How do I backup my database?

A: Clients do not have access to backup and restore their own databases. You can contact us and a member of our Hosting Help Desk staff will be able to assist you with this.

Q: Do you host any other database software?

A: AspDotNetStorefront also offers MySQL databases for PHP-driven sites like WordPress.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article