Backup Database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shapper - 30 Sep 2008 05:35 GMT

Hello,

What is the best way to create a backup of an SQL 2005 database on my
hosting server?

A side question:

I have an SQL database with 4 tables.
On one of the tables I added one new column and deleted another.

How can I download the data from the old database version I have on my
server and place the data on the columns of the new table that still
exist?

Thanks,
Miuel

Reply to this Message

Eric Isaacs - 30 Sep 2008 08:00 GMT

> What is the best way to create a backup of an SQL 2005 database on my
> hosting server?

The best method will be largely determined by the authority that the
hosting company grants you on the server. Contact the hosting company
and ask them for a backup or how to do it yourself within their
environment.

> How can I download the data from the old database version I have on my
> server and place the data on the columns of the new table that still
> exist?

Assuming you have BOTH databases on the same SQL Server, you can just
INSERT the data from the old database.tablename into the new
databasename.tablename.

INSERT newdatabasename.newtablename
(
col1name,
col2name,
col3name.
)
SELECT
col1name,
col2name,
col3name
FROM
olddatabasename.oldtablename

Alternately you could just alter the old database to drop the one
column and add the new column, which might be easier for you??

- Eric Isaacs

Reply to this Message