Home Forums SQL Server 2005 Administering indexing online vs offline, and setting a database offline RE: indexing online vs offline, and setting a database offline
M&M
SSC-Insane
Points: 21700
More actions
January 19, 2010 at 11:57 am
#1105634
There was once when I had to restore a database.
Due to some reason, connections continued to persist on this database because of which I couldn't restore.
To overcome this, took the database offline and then performed the restore. 🙂