> Really? I've always been under the impression that that was not possible.
> I'd be very interested in knowing how you've done that as that is
> one of my
> biggest fears for my SQL box.
In the enterprise manager if you click on the database and click on all
tasks? > then there is a backup function. Use this to backup the database.
Then, on the new machine, perform the same action, but this time restore the
db. I have gone from MSSQL7 to 2000. I don't restore it, I have only ever
backed up. One of my clients hosts at DataReturn. I put the DB on our FTP
site and they download and restore it.
John Cesta
ColdFusion ASP ActiveState PERL Hosting
---------------------
Includes 10 Domains
100% Browser Based Administration
--------------------------------------------
http://www.cybersmarts.net
--------------------------------------------
SearchItPRO - IIS LogFile Management Tool
-------------------------------
http://www.serverautomationtools.com
> -----Original Message-----
> From: Derek Hamilton [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 23, 2001 5:02 PM
> To: CF-Server
> Subject: Re: OT moving a database in sql server 7
>
>
> Really? I've always been under the impression that that was not possible.
> I'd be very interested in knowing how you've done that as that is
> one of my
> biggest fears for my SQL box.
>
> Would you be willing to share that config?
>
> Derek Hamilton
> Systems Developer
>
> on 1/23/01 1:48 PM, the esteemed Dave Watts at [EMAIL PROTECTED]
> postulated:
>
> >> 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...
> >
> > I've done backups from one machine, then restored to another
> before without
> > any problem - although not to and from tape. There's a setting in the
> > restore process that you can configure to allow this.
> >
> > Dave Watts, CTO, Fig Leaf Software
> > http://www.figleaf.com/
> > voice: (202) 797-5496
> > fax: (202) 797-5444
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
