Posted by velu5 on 12/03/07 06:13

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 ?

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

[Back to original message]