can SQL Server do hot backups?

Can SQL server handle High Availability or does it have to go down
occasionally for a cold backup? Does it support incremental backups?Ryan wrote:
> Can SQL server handle High Availability or does it have to go down
> occasionally for a cold backup? Does it support incremental backups?

Yes,no,yes :-)|||can you do hotbackups with the standard edition? what about incremental
backups?

or do you have to purchase the enterprise edition?
"Trev@.Work" <no.email@.please> wrote in message
news:400c0f09$0$4907$afc38c87@.news.easynet.co.uk.. .
> Ryan wrote:
> > Can SQL server handle High Availability or does it have to go down
> > occasionally for a cold backup? Does it support incremental backups?
> Yes,no,yes :-)|||"Ryan" <rgaffuri@.cox.net> wrote in message
news:a0VOb.4224$_H5.115@.lakeread06...
> can you do hotbackups with the standard edition? what about incremental
> backups?
> or do you have to purchase the enterprise edition?
> "Trev@.Work" <no.email@.please> wrote in message
> news:400c0f09$0$4907$afc38c87@.news.easynet.co.uk.. .
> > Ryan wrote:
> > > Can SQL server handle High Availability or does it have to go down
> > > occasionally for a cold backup? Does it support incremental backups?
> > Yes,no,yes :-)

All backups in MSSQL are 'hot' in the sense that you do not have to stop the
MSSQL service, and you do not have to disconnect users from the database.
This is true in all versions of MSSQL, and all backup types (full, log,
filegroup, differential) are also available in all versions. Other high
availability options (replication, clustering, log shipping) do depend on
the version in terms of what functionality is available.

Simon|||On Mon, 19 Jan 2004 13:06:02 -0500 in comp.databases.ms-sqlserver,
"Ryan" <rgaffuri@.cox.net> wrote:

>can you do hotbackups with the standard edition? what about incremental
>backups?

What part of "yes" don't you understand? :-)

You can do both.

--
A)bort, R)etry, I)nfluence with large hammer.