If the servers are both on the same network (or depending on your security)
you can just import the data from one to the other. You can do this in Ent
Manager. I use it all the time when all I want to do is transfer data from
one machine to another. SQL Server will create all the tables for you. One
of the drawbacks is that this will not transfer User information or any
Maintenance plans or anything like that.
One note on the backup and restore. SQL Server 7 has a little glitch where
you cannot restore a DB on a machine where the system files do not show a
record of the backup. So if you do a backup to tape and try to restore to
the other machine it will not let you because the destination machine shows
no record of the backup. Hope that made sense...
Good luck!
Derek Hamilton
Systems Developer
on 1/23/01 2:02 AM, the esteemed Kola Oyedeji at [EMAIL PROTECTED]
postulated:
> 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
