Are you going from SQL 7 to SQL 7? If so, just transfer to data using
DTS. I have done this a few times. Works fine for me.
Install SQL 7
configure and set up your users
Export from the old SQL and import it into the new SQL.
I find it better to create the database (leave it blank) on the new server
and use the transfer object and data selection in the DTS package.
Jacob
At 11:20 AM 10/4/00 -0600, you wrote:
>We are in the process of installing a new web server box. Everything is
>going OK except I'm getting held up on transferring the SQL databases. The
>current plan is to take the file created by the backup process and move it
>to the new box and use the restore wizard in Enterprise Manager. The new
>box does not have the same drive setup as the old and I'm getting an error
>that says something about using "with move". I've been told that I need to
>use transact SQL to make that work. I can't find any decent examples on
>Books Online. Can anyone point me to an example? Am I taking the right
>approach?
>Also do I need to backup and move the Master database? Thanks.
>
>
>_____________________________
>Lee Surma
>Public Radio International
>[EMAIL PROTECTED]
>612-330-9223
>_____________________________
>
>------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebarsts&bodysts/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.
