Posted by Erland Sommarskog on 12/03/07 22:47

velu5 (thirumalaivelu@gmail.com) writes:
> 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).
>
> Are there any major changes between SQL server 2000 and SQL server
> 2005 ?

Well, DMO became dusty and old with SQL 2005, and it's possible
that DMO somehow manages to cause double connections.

I've always stayed away from DMO (and its successor SMO), so I cannot
really say much more.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Using updatable views when moving tables from one DB to another?
• Prev in forum: Re: SSIS is pathetic with ODBC connections ...
• Thread view: Re: DB Backup - Single User Mode

[Reply to this message]