Database Administrators Questions, Problems & Solutions : TransWikia.com ~ Page 29

Where does each MySQL data file type belong?

I'm in the process of transferring a database from one server to another.I'm moving the data files directly, instead of using a SQL dump. To do this, I:ensured that...

Asked on 02/16/2021 by BenMorel

1 answer

Postgresql update timestamp without timezone to have timezone

When I created the table, a Timestamp column without timezone was created. All the imported time is in UTC. Now I want to add the timezone information explicitly, and I...

Asked on 02/15/2021 by hanxue

2 answer

Recover from Postgres FATAL: could not open file pg_tblspc/

I have a pretty big PostgreSQL 9.1.3 running on Ubuntu 10.04. The data is spread over multiple tablespaces = physical drives. One of these drives is gone, so the directory...

Asked on 02/15/2021 by alfonx

5 answer

SQL query with Like operator with Leading Wildcards

I have a query as follows: select top (30000) * from table1 where licenseplate like '%as43bv%'I have an index on licenseplate but the query will not hit the index...

Asked on 02/15/2021 by SQL_NoExpert

1 answer

The media family on device '' is incorrectly formed. SQL Server cannot process this media family

RESTORE VERIFYONLY and RESTORE DATABASE always fail immediately with this error:Msg 3241, Level 16, State 201, Line 1The media family on device '' is incorrectly formed. SQL Server cannot...

Asked on 02/15/2021 by Mark Copenhaver

0 answer

conversion failed when converting datetime from character string while inserting and updating to database

I'm trying to insert time and date separately and calculate if it is late to the set time and then insert it to database... here's my try code for update...

Asked on 02/15/2021 by Mark Luzon

0 answer

Problem creating subscriptions on Replication Server version 15.7.1

if anyone knows what is the error? Can not use active or standby connection names for subscriptionsI got this error when I'm trying to create my subscriptions. I have...

Asked on 02/15/2021 by Tittus

1 answer

Unable to attach SQL Server database with shared folder in docker on Linux

The problem I'm having is that my SQL Server 2017 Linux container is not able to read my database files. I guess it has something to do with permissions and...

Asked on 02/14/2021 by SQLStad

1 answer

Slave_SQL_Running_State init

I have a master-slave configuration. The slave stopped replicating with no errors. The only thing strange i see is thisSlave_SQL_Running_State: initin show slave status; I seeenter code hereSlave_IO_State:...

Asked on 02/14/2021 by Euratus

0 answer

How to cast in oracle -Spatial Database?

Im trying to get data inside the table which is below. CREATE TABLE Eshot ( eshotNumber NUMBER, eshot_geo_location SDO_GEOMETRY);Using this query...

Asked on 02/13/2021 by marchest

1 answer

Ask a Question

Get help from others!

Database Administrators : Recent Questions and Answers (Page 29)

Ask a Question