Just a side question...what does taking a db offline really do for us, i.e.
a non-BOL practical explanation would be great.
Erwin Sloboda
Database Specialist, Database Services Group
Assante Advisory Services Ltd.
905-984-6803, 289-241-3874
St. Catharines, ON
-----Original Message-----
From: Justin Gilli [mailto:[Email Address Removed]
Sent: Monday, January 26, 2004 12:09 PM
To: LazyDBA.com Discussion
Subject: RE: Taking DB offline
In SQL Server 7.0 the functionality of taking the database offline is hidden
from the Enterprise Manager. So you would take the database offline using
T-SQL statement i.e. using sp_dboption procedure. For example to take the
'pubs' database offline you execute the following statement
sp_dboption 'pubs','offline','true'
But before taking the database offline ensure that no processes are using
the database. You can make the database online by using the 'false' keyword
as
sp_dboption 'pubs','offline','false'
Whereas in SQL Server 2000 you can take the database offline by using the
Enterprise Manager i.e. By right clicking on the 'database' and then choose
'All tasks' and then choose 'Take offline'.
(Or) Alter database pubs set offline (replace 'offline' with 'online' to
bring the database back online)
(Or) by using sp_dboption as above.
Sincerely,
Justin Gilli
-----Original Message-----
From: Usman Farhat [mailto:Usman.[Email Address Removed] Monday, January 26, 2004 11:48 AM
To: LazyDBA.com Discussion
Subject: Taking DB offline
In Sql Server 7 how to take Database offline..
Thanks,
Usman
--------------------------------------------------------------------
NOTA CONFIDENZIALE:
Questo messaggio ed i suoi allegati sono indirizzati esclusivamente
alle persone indicate in testa e possono contenere informazioni
confidenziali. Se avete ricevuto il messaggio per sbaglio, sappiate
che qualunque utilizzo improprio del contenuto è proibito, Vi
preghiamo quindi di inoltrarlo immediatamente al mittente e di
cancellare il messaggio. Per qualsiasi informazione vi inivitiamo a
contattarci scrivendo a [Email Address Removed]
Grazie
CONFIDENTIALITY NOTICE:
This message and its attachments are addressed solely to the persons
above and may contain confidential information. If you have received
the message in error, be informed that any use of the content hereof
is prohibited. Please return it immediately to the sender and delete
the message. Should you have any questions, please contact us by replying
to [Email Address Removed] you
--------------------------------------------------------------------
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] All e-mail to or from this address is recorded by Assante
and is subject to archival, monitoring and/or review, by and/or disclosure
to, someone other than the recipient. This message is intended only for
the persons to whom it is addressed. It may contain information that is
privileged and confidential. If you are not the intended recipient, please
contact the sender immediately and delete the e-mail without reading it
or making a copy.
Any distribution, copying, or other use of this e-mail by
a person other than the intended recipient is prohibited. Precautions have
been taken to screen this e-mail for viruses but it may not be virus free.
We are not responsible for any damage that may be caused by this
e-mail. This communication is for information purposes only and is not
an offer to sell or a solicitation of an offer to buy any financial product,
an official confirmation of any transaction or an official statement of
Assante. E-mail transmission cannot be guaranteed to be secure or
error-free.
--------------------------------------------------------------------------
MS Sql Server LazyDBA home page