There are a couple ways you could accomplish this. The easiest would be to
use Enterprise MGR to make a backup of the existing DB to tape. The goto the
other server (make sure your SA name and pwd's are the same I have seen some
odd problems if they are not. (btw,Im used to using 6.5 so my instructions
might be a little off. For instance you might not have to recreate the
devices in 7. 7 might restore them for you.) Then you will have to create
your DB's devices the same as they were on the other server(ie size and
names). Then try restoring.
Another way to do this, especially if you are going to want to do some
renaming etc, is to dump the contents of your files into TAB files. Goto the
help and lookup ISQL and BCP. This is normally very clean and doesn't have
any problems unless you have some large 'text' areas.
Good luck.....
-----Original Message-----
From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 23, 2001 5:03 AM
To: CF-Server
Subject: OT moving a database in sql server 7
Hi
I realise this is off topic but i'm sure a lot of you use SQL server, i have
a database i would like to make a copy
of it and move this copy to another server to use with a different
installation (of coldfusion and sequel server)
any pointers or tips would be appreciated - thanks
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
