The Dopefly Tech Blog

<< The Dopefly Tech Blog Main page

Do you back up your personal production web site?

posted under category: Database on September 26, 2008 at 1:00 am by MrNate

Along the trail of web-based ad-hoc query tools, I also have the need to back up my database from time to time. Having no direct connection to SQL Server across the internet on my host, I can't just use the SQL Server tools to do it.

Another scenario: a couple weeks ago I installed SQL Server Express 2008 64 bit. It's been running really well on Vista 64 and working fantastically with ColdFusion 8. The problem is, I had to recreate a local copy of dopefly.com's database (it runs the blogs and family photos apps). Then, I knew I wanted to populate it with some data, as close to the live data as possible. This is a pain because the only way to get the structure is to eyeball and hand-jam it. yuck, no thanks.

Well, I came up with a pretty good solution for myself, but I was hoping to get some advice from other people as to how they would do it. Any ideas out there?

Too old to comment!
On Sep 26, 2008 at 1:00 AM Ryan Stille (ryan has underestimated cfwebtools.com) said:
Migrate to MySQL? Just kidding. But I do use phpMyadmin quite a bit and love it. Maybe there is something similar for MS SQL Server.

On Sep 29, 2008 at 1:00 AM Nathan Miller (nathan whose email lies with nmconsulting.us) said:
Here's your problem:

Having no direct connection to SQL Server across the internet on my host...

I've never had a website that uses SQL server where I <em>Haven't</em> had access to sql. If nothing else, you could ask the support team to send you the most recent .bak file and you could restore it locally.

Too old to comment!