Backups

Hello,
Our backups are failing as we have connections to them,
and the error is that the database must be in single mode.
Our recovery plan is set to full, so I was wondering what
the best practise is i.e could we set the database to
single mode killing off all connections, use some SQL
commands to kill off connection, or change the recovery
model to something else.
Any help would be appreciated.
Thanks
PeterHello, Peter!
Is this through a maintenance plan ?
SQL Server backups can be taken with users still on the system. A Database
cannot be restored with users in the database. Is this error being
generated by SQL Server trying to put the DB into Single User mode to fix
minor errors ?
You can quite easily test the BACKUP ni isolation by going to QA and issuing
the statement there.
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
: Our backups are failing as we have connections to them,
: and the error is that the database must be in single mode.
: Our recovery plan is set to full, so I was wondering what
: the best practise is i.e could we set the database to
: single mode killing off all connections, use some SQL
: commands to kill off connection, or change the recovery
: model to something else.
: Any help would be appreciated.
-- Microsoft CDO for Windows 2000|||Thank you, I will change my options.
Peter
>--Original Message--
>Yes, I agree with Allan in that this is due to the fact
you have the option
>checked to do an integrity check before the backups and
that is what needs
>to be in single user mode. This is a bad option anyway
because people
>usually have the integrity jobs running from the other
page of the MP
>dialog. So now it does DBCC's 2 or 3 times.
>--
>Andrew J. Kelly
>SQL Server MVP
>
>"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in
message
>news:enfKY0UQDHA.3016@.TK2MSFTNGP10.phx.gbl...
>> Hello, Peter!
>> Is this through a maintenance plan ?
>> SQL Server backups can be taken with users still on the
system. A
>Database
>> cannot be restored with users in the database. Is this
error being
>> generated by SQL Server trying to put the DB into
Single User mode to fix
>> minor errors ?
>>
>> You can quite easily test the BACKUP ni isolation by
going to QA and
>issuing
>> the statement there.
>>
>>
>> --
>> Allan Mitchell (Microsoft SQL Server MVP)
>> MCSE,MCDBA
>> www.SQLDTS.com
>> I support PASS - the definitive, global community
>> for SQL Server professionals - http://www.sqlpass.org
>> : Our backups are failing as we have connections to
them,
>> : and the error is that the database must be in single
mode.
>> : Our recovery plan is set to full, so I was wondering
what
>> : the best practise is i.e could we set the database to
>> : single mode killing off all connections, use some SQL
>> : commands to kill off connection, or change the
recovery
>> : model to something else.
>> : Any help would be appreciated.
>> -- Microsoft CDO for Windows 2000
>>
>
>.
>