The discipline of Operational and Architectural Management of Database Systems.
0
votes
0answers
28 views
Should My App Use MySQL Or FTP? [on hold]
I have an application and website that communicate with a user file residing on an ftp server.
Processing proceeds as follows:
1) User signs up
2) Application creates a file with required data
3) ...
0
votes
1answer
63 views
What is a bucket in database? [on hold]
I was implementing a code that involves a database and buckets. Just wanted to ask what is bucket and can someone describe it with an example?
Thanks!
1
vote
0answers
44 views
Script to see running jobs in SQL Server with Job Start Time
how to write script to see running jobs in SQL Server with Job Start Time?
SELECT sj.name,
sja.run_requested_date,
CONVERT(VARCHAR(12), sja.stop_execution_date-sja.start_execution_date, 114) ...
-2
votes
0answers
29 views
Is their any way to connect to oracle database via UNIX shell without using sqlplus [migrated]
is there any command string in unix which will provide access to oracle database. i dont want to use sqlplus command.
thanks for help...
-1
votes
0answers
7 views
system.invalidoperationexception: Fill: selectCommand.Connection property has not been initialized (DUPLICATE QUESTION)
I'm working on connecting the MS Access database in Visual basic. Unfortunately, I cannot link the records from my data base into visual basic.
My database is located at C:\Users\lenovo\Desktop\GUI ...
-1
votes
0answers
21 views
Oracle 10.2.0.1.0 - Invalid Handle [closed]
All,
We have a problem in one of the applications whereby the application writes a log as below
DBError exception occurred in ORA9IConnection::determineAudSid(StmtFree)
Invalid Handle
The ...
1
vote
1answer
23 views
ORA-12541 error while connecting to oracle express edition 11g
My oracle express edition was working some months earlier.
I dont know what i changed in the system, now I could not connect to it. I tried logging in from sqlplus as sysdba and altered the accounts ...
1
vote
2answers
77 views
Move a huge databases from one SQL Server to another
I have customers databases located on my SQL Server 2008 machine. The size of these databases are around 300 GB. I would like to move them all to another SQL Server 2008.
Is there a way to shrink ...
0
votes
0answers
13 views
Is there a way to reduce the number of hits on the db [migrated]
Im new to c# MVC and MSSQL but I have got this code working
DateTime startDate = DateTime.Parse(start);
DateTime endDate = DateTime.Parse(end);
...
0
votes
1answer
21 views
Which MongoDB administration UIs offer a table view (OS X)?
The only admin UI we found that offers a table view is MongoVue, which is only available on Windows. We're on Macs with OS X. Do any exist?
0
votes
0answers
33 views
SQL Server A network-related or instance-specific error
I have a windows service that performs a lot of hits to database. Sometimes the database connection is down and I got exception "A network-related or instance-specific error". I got this behavior on ...
0
votes
2answers
46 views
Create database fails with Microsoft SQL Server Error 5133, Operating syste, error 5 (Access is denied)
I just installed SQL server 2012 on Windows 2012 today. After the install, I changed the database settings to create database files in f:\mssql instead of the default. i verified the confired and ...
0
votes
0answers
17 views
InnoDB crashes frequently
My Innodb Engine is getting crashed frequently. I could not find the reason behind this.
This is the error log:
140129 9:22:49 [Note] Plugin 'FEDERATED' is disabled.
140129 9:22:49 InnoDB: The ...
0
votes
1answer
34 views
Rotate Postgres log at 5GB
How to make postgres 9.1 log to have maximum size 5GB and to be circle when comes to 5GB ?
At the moment my log file is over 500GB.
/var/lib/postgres/
3
votes
2answers
129 views
SQL Server Connectivity Issues
I am getting the below error on occasion. Maybe every 30mins or so. I am not sure how to track what is causing the issue. I think it could be a Network problem as there are disk backups running as ...