Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [offline]

A database state wherein the database is completely inaccessible. An offline database can be brought back online to resume access.

OFFLINE

The database is closed, shut down cleanly, and marked offline. The database cannot be modified while it is offline.

https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-set-options

11 questions
11
votes
3 answers

When was a Database taken Offline

I am trying to find a way to figure out when was couple of my sql databases were taken offline. I checked the the logs but could not find any such info and moreover there is no default trace enabled. I just have a info that earlier there was a DBA…
KASQLDBA
  • 7,203
  • 6
  • 30
  • 53
5
votes
1 answer

How does offline-first database design work?

I would like to make an offline-first To-do app which works on both the mobile app (SQLite) and the web app (PostgreSQL). The app will have these business…
Robin
  • 151
  • 3
3
votes
2 answers

Can a offline database be in use?

I have a SQL Server 2014 DB where the log file filled up the disk. Since it was a test db, we decided to just delete the whole database. We took it offline, but when we try to drop it, we get a message that it cannot be dropped since it is in use.…
GHauan
  • 615
  • 8
  • 24
2
votes
0 answers

Distributing MS Access Database

I develop an application that saves records in MS Access DB. Each user has it own DB copy on his local machine, and there is a central DB that reflects all the copies from everyone. The central DB is located in a URL that everybody can access. I…
user3165438
  • 131
  • 2
2
votes
2 answers

Should an OFFLINE database be SET EMERGENCY before dropping?

As a rule before dropping a database I, SET OFFLINE, for 30 days before dropping it. If there is anything that was missed and the database is still needed, I can SET ONLINE quickly for a full restore. USE master GO ALTER DATABASE database_name SET…
James Jenkins
  • 6,318
  • 6
  • 49
  • 88
1
vote
1 answer

Bringing an Availability Group online after taking it offline

Answer in the following thread says: activate Service Broker on a database in an Availability Group "You need to set RegisterAllProvidersIP to 0 Thereafter take the availability group offline and bring online again." Is it easy to bring an AG online…
Warer
  • 11
  • 3
1
vote
2 answers

Can't change _log database physical location in SQL Server

I just installed Microsoft ServiceBus and it created 5 databases. Now I want to move them to some specific location so I can join them to SQL Server AlwaysOn Availability group. I stopped service bus farm and tried to execute the following queries…
Andrew
  • 153
  • 6
0
votes
0 answers

User does not have permission to alter database '', the database does not exist, or the database is not in a state that allows access checks

Our log file was full, so I made a mistake in trying to shrink it. My original thought was to move the log file to a different drive, shrink the log, then move it back. However, I did it incorrectly. What I did was the following: Set the…
A M C
  • 9
  • 2
0
votes
1 answer

Start mysqld.exe but as offline at the begining

How can I start my mysql server as usual using "./bin/mysqld.exe" on windows, but it has to be offline at the very begining? Right now when I start mysqld.exe, I always need to start Mysql Workbench and push the button "bring it offline" at…
ElSajko
  • 101
  • 1
0
votes
2 answers

Does an OFFLINE Database use space?

I took my SQL Server Database OFFLINE. Is it still occupying the same space as when it was ONLINE? Should I keep it OFFLINE or is it better to BACKUP the database and DROP it?
pds
  • 11
  • 1
  • 6
0
votes
2 answers

How to display User Mapping for offline databases?

When I use the GUI (SSMS) to review the User Mapping, where the Login has mapping to a database that is offline (or otherwise not available) I get the message below and it only displays Mapping for databases that are online. One or more databases…
James Jenkins
  • 6,318
  • 6
  • 49
  • 88