I'm not on top of SQL server...we use IBM DB2,
but in case of a system failure.....YES YES YES...you must be able
to restore a DB from a backup into any running SQL server.
Use the backup & retore util, that is installed with Ms SQL. 7
_________________
Herman A Cremer
Systems Engineer
S o l i d L i q u i d
South Africa
Tel +27 82 806 5030
www.solidliquid.com
_________________
----- Original Message -----
From: Kola Oyedeji <[EMAIL PROTECTED]>
To: CF-Server <[EMAIL PROTECTED]>
Sent: Tuesday, January 23, 2001 12:45 PM
Subject: RE: OT moving a database in sql server 7
> Sorry i should have explained i'm a newbie to sql server can i use the
> enterprise manager to back up and restore?
> Is it possible to restore a database to a new install of sql server where
> the database never existed (for that
> installation) in the first place?
>
> -----Original Message-----
> From: Herman Cremer [mailto:[EMAIL PROTECTED]]
> Sent: 23 January 2001 10:13
> To: CF-Server
> Subject: Re: OT moving a database in sql server 7
>
>
>
> try backup & restore....simple yet effective.
> I depend on your needs....
>
>
> _________________
> Herman A Cremer
> Systems Engineer
> S o l i d L i q u i d
> South Africa
> Tel +27 82 806 5030
> www.solidliquid.com
> _________________
> ----- Original Message -----
> From: Kola Oyedeji <[EMAIL PROTECTED]>
> To: CF-Server <[EMAIL PROTECTED]>
> Sent: Tuesday, January 23, 2001 12:02 PM
> 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
