sql server new users: Are you aware of SQL Server's BACKUP and RESTORE commands? If that
doesn't meet your requirements then consider using sp_atttach_db and
sp_detach_db. All these commands are documented in Books Online.

--
David Portas
SQL Server MVP
--

You can backup and restore an entire datatabase. If you need to merge
with some other existing database you could restore it to the same
server and just selectively copy over the data you need.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_9zcj.asp

How have you been backing up the data until now? Although it's possible
to shutdown the database and backup the physical files the point of
SQL's own backup is that it can be done without taking your site
offline. If you haven't previously been taking backups then make sure
you do so and verify it with a test restore to another location before
you attempt anything.

Hope this helps.

--
David Portas
SQL Server MVP
--

Hi,

I have a shared SQL database which drives a web site that I have created.
This is hosted on a particular domain.
I am transferring the site, and I want to move the SQL database data into a
new SQL database on our new server.

What is the best way to do this? I have, in the past, saved the data off
into Access tables, but how reliable is this when it comes to re-uploading
into SQL? Will it not re-format all the fields into Access format? My
particular worries are date fields!

Any advice would be greatly appreciated. Thanks.

Regards
Nath.

Hi David,

I am not aware of BACKUP and RESTORE. Can you provide a basic outline of
what they do?

I am using Enterprise Manager to view the tables in my shared SQL database.
Can I, basically, save the tables and views from this database and then
upload them to my new shared SQL database?

Thanks for your help. I will have a look at the Books Online.

Regards
Nath.

[quoted text, click to view]