Home Forums SQL Server 2005 Data Corruption Backup the database when the database is set to single user mode RE: Backup the database when the database is set to single user mode

  • 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