> 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?
If you're using SQL Server 7, when you restore, there's an "Options" tab
which will allow you to change the file names and paths that the restore
will use.
> Also do I need to backup and move the Master database? Thanks.
No, you don't need to bother with the master database - in fact, unless the
configuration of the new server matches that of the old one, you don't want
to transfer it.
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.
