 | |
DB Backup - Single User Mode
comp.databases.ms-sqlserver comp.databases.ms-sqlserver
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
DB Backup - Single User Mode -
10-30-2007
, 03:02 PM
#2
| |||
| |||
|
|
Hello , Is it possible/recommended to do SQL server instance backups in Single user mode ? Thanks in advance, atv |
especially needed to prevent any changes (for example if you were backing up
in advance of an upgrade or planning to decommission the original database).
--
David Portas
#3
| |||
| |||
|
|
Is it possible/recommended to do SQL server instance backups in Single user mode ? |
you would do it, is because you have already put the database in single-
user mode. That is, it's works perfectly well to have backups running with
users active.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
#4
| |||
| |||
|
|
velu5 (thirumalaiv... (AT) gmail (DOT) 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... (AT) sommarskog (DOT) 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 |
#5
| |||
| |||
|
|
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). |
Quote:
|
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.
Quote:
|
On Oct 31, 3:00 am, Erland Sommarskog <esq... (AT) sommarskog (DOT) se> wrote: velu5 (thirumalaiv... (AT) gmail (DOT) 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... (AT) sommarskog (DOT) 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
#6
| |||
| |||
|
|
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 ? |
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 (AT) sommarskog (DOT) se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.