can SQL Server do hot backups?

[Ryan]

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

[Trev]

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]

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:40**********************@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 :-)

[Simon Hayes]

"Ryan" <rg******@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:40**********************@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

[Trevor Best]

On Mon, 19 Jan 2004 13:06:02 -0500 in comp.databases.ms-sqlserver,
"Ryan" <rg******@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.