When DB maintenance is run, ie backup, is the DB taken offline?

10 Sep 2007 7:46 PM

Rick

Can I run a DB every 2 hours during work hours without interrupting my users?
Or does a backup need to run after hours in order to take itself offline?

Sorry, cant find this info anywhere else.

thanks for the help.

10 Sep 2007 7:56 PM

Russell Fields

Rick,

The SQL Server BACKUP command is completely online. You will not interrupt
your users and nobody needs to go offline. Here a couple of links to help
you:

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx -
SQL Server 2000
http://msdn2.microsoft.com/en-us/library/ms187048.aspx - SQL Server 2005

RLF

Show quote

"Rick" <R***@discussions.microsoft.com> wrote in message
news:842CEAF0-D9D2-4F21-8652-DA60407BD0F0@microsoft.com...
> Can I run a DB every 2 hours during work hours without interrupting my
> users?
> Or does a backup need to run after hours in order to take itself offline?
>
> Sorry, cant find this info anywhere else.
>
> thanks for the help.

10 Sep 2007 8:10 PM

Rick

Much appreciated.

Show quote

"Russell Fields" wrote:

> Rick,
>
> The SQL Server BACKUP command is completely online. You will not interrupt
> your users and nobody needs to go offline. Here a couple of links to help
> you:
>
> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx -
> SQL Server 2000
> http://msdn2.microsoft.com/en-us/library/ms187048.aspx - SQL Server 2005
>
> RLF
>
> "Rick" <R***@discussions.microsoft.com> wrote in message
> news:842CEAF0-D9D2-4F21-8652-DA60407BD0F0@microsoft.com...
> > Can I run a DB every 2 hours during work hours without interrupting my
> > users?
> > Or does a backup need to run after hours in order to take itself offline?
> >
> > Sorry, cant find this info anywhere else.
> >
> > thanks for the help.
>
>
>

11 Sep 2007 1:15 PM

Yashwant

DB is not taken offline when you take backup. Though it affects performance
little bit. Your users may or may not feel the difference. You will have to
test it yourself.
Usually followed practice is to take full backup may be once in a day when
the load on system is not high and take transaction log back on smaller
interval say 15 minutes.

Yashwant

Show quote

"Rick" <R***@discussions.microsoft.com> wrote in message
news:842CEAF0-D9D2-4F21-8652-DA60407BD0F0@microsoft.com...
> Can I run a DB every 2 hours during work hours without interrupting my
> users?
> Or does a backup need to run after hours in order to take itself offline?
>
> Sorry, cant find this info anywhere else.
>
> thanks for the help.