• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 968
  • Last Modified:

Database Offline

Is there anyway to set the database offline like in
 Micrsoft SQL Server
0
rajar
Asked:
rajar
1 Solution
 
bretCommented:
There is no "offline database" command in Sybase SQL Server.

You can cause the database to be offline by dumping it and
then reloading it.

An alternative is to kill any user connection that are currently using the database and then quickly (before they log back in) run sp_dboption <dbname>, "dbo use only", true.

-bret

0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now