Solved

Database Offline

Posted on 1997-11-17
1
689 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

A customer recently asked me about anti-malware and the different deployment options available for his business. Daily news about cyberattacks, zero-day vulnerabilities, and companies that suffered a security breach made him wonder if the endpoint a…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

895 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now