Got SQL Server on a Go Daddy Shared Hosting Plan?

Not sure how to put your development database live?

Want to copy the live database back to your development project?

Salmon Training has developed a 10-chapter E-book which walks step-by-step through the process of copying SQL Server databases between Go Daddy Shared Hosting and your development environment.

Going live? Need to load a live copy back into your development database? Chapters 4 to 10 use tutorials, screenshots and video to show you how. Developers will be tempted to jump straight to these walk-throughs. But don't skip the opening chapters ...here's why:

As professional database administrators, we are fanatical about disaster recovery. You have a live database so you should be too! Chapters 1 to 3 show you how to to plan and implement the backup strategy that will protect your users and your reputation from the risks of losing your data.

Check out the Table of Contents for descriptions of each chapter, and links to two free chapters.

Going Live & Backing Up!

Software Cover

The Go Daddy Shared Hosting Tutorial

This online E-book walks you step-by-step through the SQL Server administration tasks required for database-driven web applications using Go Daddy shared hosting plans.

Ten extensive chapters show you how to:

  • Deploy a database to the live site for the first time
  • Publish database changes to the live site
  • Grab and load a live copy into your development database
  • Devise a Database Backup Strategy
  • Recover your live database in the event of disaster

We use tutorials, screenshots and video to teach you to do what we do as professional database administrators.

 

Purchase Your Training

We provide this training as an Online E-Book. This means that you access the training by logging into our web site using any standard web browser. You must be online to use the training.

There are screenshots on each page as well as a video tutorial. We recommend a high-speed connection.

Access to the training is instant on purchase. When you register, you are logged in straight away to our site and can start reading! We send a link to the login page and your login details to your email address for use 24X7.

Clickbank sells our products - they are a trusted online retailer specializing in digitally delivered products.

credit cardsCLICK HERE TO PURCHASE

We're offering the E-Book at a Special Price of $6.00.

Additional VAT may be added inside the European Union, and where else applicable.

Contact us on "feedback [at] salmontraining.com" if you have any queries.
   

Table Of Contents

Chapter 1. Data Loss

You may have never experienced a total database failure, and thankfully this scenario is quite rare due to the stability of SQL Server. But it's important not to be complacent - most problems with databases are due to the users or applications interacting with the data! This chapter covers the cost and causes of losing data.

Chapter 2. SQL Server Architecture

For those new to SQL Server, this chapter covers the basic architectural concepts you need to be familiar with to understand database backups.

Chapter 3. Backup Strategy

How often should you back up? What storage media will you use to keep your backup files? How long will you keep them? In this chapter we use two of our own clients as examples to explain the different factors to be considered when planning a backup strategy.

Chapter 4. Go Daddy Live Backups

Go Daddy has stringent security requirements with their shared hosting plans, which mean that you can't use local database tools to back up the live database. This chapter provides a step-by-step walkthrough of backing up your live database using the Go Daddy Control Panel. e. An excerpt of this chapter is available as a free article on SQL Server Backups on Go Daddy Shared Hosting.

Chapter 5. Local Backups

Why would you want to back up a development database on your local machine? Losing your live database is less likely than losing your local hard drive! This chapter provides a step-by step walkthrough using SQL Server Management Studio to back up a local database.

Chapter 6. Recovery Planning

The recovery plan includes the process of actually recovering the database itself, which we'll walk through in the next chapter. In this chapter we discuss being prepared for the wider implications of reloading your live database.

Chapter 7. Go Daddy Live Restores

This chapter provides a step-by-step walkthrough with screenshots to show you how to restore your SQL Server database. An excerpt of this chapter is available as a free article on SQL Server Restores on Go Daddy Shared Hosting.

Chapter 8. Local Restores

Aside from disaster recovery, one of the most useful functions of knowing how to backup and restore a database is that it gives you a way to copy an entire database from the live site to your development environment. This chapter walks through the process of restoring a backup file into your development environment.

Chapter 9. Putting Your Database Live - Part 1

If you don't know already, you will be disappointed to learn that you cannot backup your development database and restore it into the live database on the Go Daddy shared hosting site. The Database Publishing Wizard is a tool that lets you deploy your local database to the live shared database server. This chapter walks through the process of using the tool to deploy directly to live.

Chapter 10. Putting your Database Live - Part 2

This chapter deploys changes to the live database by working with the SQL script generated by the Database Publishing Wizard. Instead of working with screenshots, we use a video tutorial to show you how to use the Go Daddy Control Panel to apply the database scripts.