Solved

Database Offline

Posted on 1997-11-17
1
720 Views
Last Modified: 2008-02-20
Is there anyway to set the database offline like in
 Micrsoft SQL Server
0
Comment
Question by:rajar
1 Comment
 
LVL 10

Accepted Solution

by:
bret earned 50 total points
ID: 1098090
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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article outlines the process to identify and resolve account lockout in an Active Directory environment.
Ransomware is a growing menace to anyone using a computer or mobile device. Here are answers to some common questions about this vicious new form of malware.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question