Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: offline

Should an OFFLINE database be SET EMERGENCY before dropping?

By adminPosted on February 5, 2023

Question : As a rule before dropping a database I, SET OFFLINE, for 30 days before dropping it. If there […]

When was a Database taken Offline

By adminPosted on April 12, 2022

Question : I am trying to find a way to figure out when was couple of my sql databases were […]

Does an OFFLINE Database use space? [closed]

By adminPosted on November 14, 2020

Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]

Start mysqld.exe but as offline at the begining

By adminPosted on March 15, 2020

Question : How can I start my mysql server as usual using “./bin/mysqld.exe” on windows, but it has to be […]

Can’t change _log database physical location in SQL Server

By adminPosted on March 12, 2020

Question : I just installed Microsoft ServiceBus and it created 5 databases. Now I want to move them to some […]

Can a offline database be in use?

By adminPosted on January 1, 2020

Question : I have a SQL Server 2014 DB where the log file filled up the disk. Since it was […]

Recent Posts

  • How to pass a parameter into a subquery in a join statement [closed]
  • Replicate a database with a subset of data offered by custom queries [closed]
  • Are there any benefits in certain ordering of columns when defining indexes
  • Logins aren’t syncing across Availability Groups
  • Finding same values and updating rankings
  • Servers running on Microsoft Windows instead output carriage
  • Master ip has changed in postgresql replication
  • optimize design for a table with 50 columns [closed]
  • SQLServer In-Memory database and log file size unexpected increase
  • Is it worth to optimize queries with EarlyTermination Timeout?
  • Is there way to get transaction commit timestamp in Postgres?
  • MySQL/PHP Returning Blank Error Message [closed]
  • Mysql might have too many indexes
  • Database replication with ability to revert to previous states
  • Linked server to Oracle doesn’t use filters. Are there any performance changes in different versions of SQL Server?
  • Enable query store for all databases
  • SQL Server 2012 Enforce Password Policy [closed]
  • Maintenance in MYSQL when innodb_file_per_table disabled
  • SQL Server stored procedure producing data related to months between two dates [duplicate]
  • Efficient way to store multi choice in a column with few options

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding