Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backup the database when the database is set to single user mode Expand / Collapse
Author
Message
Posted Wednesday, April 29, 2009 3:28 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 31, 2011 12:36 AM
Points: 145, Visits: 67
I am planning to take database backup when the database is set to single user mode.Is there any problem while restoring the same backup file.
Post #706565
Posted Wednesday, April 29, 2009 6:12 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 2:09 PM
Points: 2,035, Visits: 1,655
Nope - just be aware that when you restore it, the database will be in the same state as when you backed it up - i.e. it will be in single-user mode.

Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
Post #706708
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse