Posted by Greg D. Moore \(Strider\) on 12/03/07 12:20

"velu5" <thirumalaivelu@gmail.com> wrote in message
news:3686490e-167c-4062-9ecf-2c043615e22a@s19g2000prg.googlegroups.com...
> Tx for your response.
> I completely understand and accept that there is no need to do a
> backup in single user mode, but for one case if the server is already
> in single user mode ..
> Here is what I found, in SQL 2000 it was possible to do the
> backups(in single user mode) while the SQL 2005 server fails to accept
> the connection for backup (the same code/binary SQL-DMO statements are
> used for both).
>

Hmm, you sure you don't something else already making a connection?

> Are there any major changes between SQL server 2000 and SQL server
> 2005 ?
>


Yes. Many changes. But I don't know any specifically that would cause this
particular issue.



> On Oct 31, 3:00 am, Erland Sommarskog <esq...@sommarskog.se> wrote:
>> velu5 (thirumalaiv...@gmail.com) writes:
>> > Is it possible/recommended to doSQLserver instance backups inSingle
>> >usermode?
>>
>> Just to emphasize what David said: Yes, it's possible, but the only
>> reason
>> you would do it, is because you have already put the database
>> insingle-usermode. That is, it's works perfectly well to have backups
>> running with
>> users active.
>>
>> --
>> Erland Sommarskog,SQLServer MVP, esq...@sommarskog.se
>>
>> Books Online forSQLServer 2005
>> athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
>> Books Online forSQLServer 2000
>> athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>



--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

[Back to original message]