Look up the "sp_attach" and "sp_detach" procedures.
You will need to install SQL on the new server, then sp_detach the
databases that you wish to transfer. Copy the mbf and ldf files to the new
server, then use sp_attach to "add" the db's to the new installation.
Chris
----------------------------------------------
Original Message
From: "CF-Talk"<[EMAIL PROTECTED]>
Subject: Re: Moving SQL to new server
Date: Wed, 4 Oct 2000 23:34:24 +0200
>In MS-SQL-Server 6.5 there was a feature called Transfer Manager.
>You could have used it to transfer data, structure and data or only the
>structure of DBs in both directions.
>Either from the old server to the new or vice versa.
>Although you have to install the devices and DBs first on the new mchine.
>Uwe
>----- Original Message -----
>From: "Dave Watts" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Cc: <[EMAIL PROTECTED]>
>Sent: Mittwoch, 4. Oktober 2000 21:39
>Subject: RE: Moving SQL to new server
>
>
>> That still results in the same error. I even went so far as
>> to create a new database, use DTS to transfer all objects and
>> data, create a backup with the same name, replace that back
>> up with the backup from the source and I still got an error
>> saying it's a different database. If I select "force restore
>> over existing database" I get the "with move" error. When I
>> examine the path that you mentioned it points to the correct drive.
>> Others have mentioned using DTS. Are there any pitfalls to
>> this? I'm glad I'm not in a crisis recovery situation.
>
>You can use DTS for this to simply transfer the data from one server to
>another, but I've had better success with the backup/restore method - it
>generally is faster, and produces fewer inscrutable errors in my
experience.
>If you like, simply delete the existing database on the server to which you
>want to restore, then try the restore - then, the database will be created
>from scratch.
>
>Dave Watts, CTO, Fig Leaf Software
>http://www.figleaf.com/
>voice: (202) 797-5496
>fax: (202) 797-5444
>---------------------------------------------------------------------------
-
>--
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>
>
>---------------------------------------------------------------------------
---
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send
>a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
>
_____________________________________________
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.com
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
