— The following commands take database ‘foo’ offline and then on again:
use master
GO
ALTER DATABASE foo SET OFFLINE
GO
ALTER DATABASE foo SET ONLINE
GO
Solving Suspect Database
Random outpourings of a software developer
Random outpourings of a software developer
— The following commands take database ‘foo’ offline and then on again:
use master
GO
ALTER DATABASE foo SET OFFLINE
GO
ALTER DATABASE foo SET ONLINE
GO
Developer Rants 