backing up SQL qhile it it running

Hello:
Is it possible to backup SQL databases whiel SQL is running?
I'm not concerned with the means of backing up. I just want to know if the
databases can be backed up whil the SQL Server Service is running.
Thanks!
childofthe1980sYou can back up SQL Server databases with the native back up while SQL
Server is running. You _can't_ backup the database files with a file backup
program while SQL Server is running. Well, technically you can, but in 99%
of the cases your backups will be unusable.
--
Jacco Schalkwijk
SQL Server MVP
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:0E595127-3A63-4172-80C0-EA1E746DF466@.microsoft.com...
> Hello:
> Is it possible to backup SQL databases whiel SQL is running?
> I'm not concerned with the means of backing up. I just want to know if
> the
> databases can be backed up whil the SQL Server Service is running.
> Thanks!
> childofthe1980s|||Look at the commands BACKUP and RESTORE in books online.
En Enterprise Manager, right click on the DB and select Backup.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid> wrote
in message news:#rhbdlK3EHA.1404@.TK2MSFTNGP11.phx.gbl...
> You can back up SQL Server databases with the native back up while SQL
> Server is running. You _can't_ backup the database files with a file
backup
> program while SQL Server is running. Well, technically you can, but in 99%
> of the cases your backups will be unusable.
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
> message news:0E595127-3A63-4172-80C0-EA1E746DF466@.microsoft.com...
> > Hello:
> >
> > Is it possible to backup SQL databases whiel SQL is running?
> >
> > I'm not concerned with the means of backing up. I just want to know if
> > the
> > databases can be backed up whil the SQL Server Service is running.
> >
> > Thanks!
> >
> > childofthe1980s
>|||"Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid> wrote
in message news:%23rhbdlK3EHA.1404@.TK2MSFTNGP11.phx.gbl...
> You can back up SQL Server databases with the native back up while SQL
> Server is running. You _can't_ backup the database files with a file
backup
> program while SQL Server is running. Well, technically you can, but in 99%
> of the cases your backups will be unusable.
Unless you use specific "agents" designed for SQL Server.
But generally the native tools are far easier to use.