Viewing 15 posts - 331 through 345 (of 482 total)
Yes, I read it.
And you're correct, on the one system, there is a backup log w/ truncate only.
However, the log file kept growing on one of the "twins" over the...
February 22, 2010 at 7:27 am
Furthermore, the same source DB is transferred to 2 other servers.
Of these, one is exhibiting the same behaviour as noted above.
The other, SQL 2K sp2 on Win2K, is not:...
February 19, 2010 at 9:23 am
Respectfully, that is not borne out by my experience.
We do a single daily full backup of the prod DB, and it has *never* -- in 10 years -- grown...
February 19, 2010 at 8:58 am
Yes, destination is set to full recovery. A full backup is done immediately prior to transfers.
No tran. log backups required, since there is no other activity on the server.
It's...
February 19, 2010 at 8:44 am
How many users, what are they doing, how is the data accessed?
Some possibilities: SELECT * queries on big tables; stored proc recompilations?
February 19, 2010 at 7:51 am
In SQL Server, each new database created is a copy of the model DB.
This applies to tables, stored procedures, and file sizes.
So if you want every new DBs to...
February 19, 2010 at 7:15 am
Failed:
VNI-2015 : The Node preferred credentials for the target node are either invalid or do not have sufficient privileges to complete the operation.
On Windows platforms, the Node credentials...
August 11, 2009 at 12:19 pm
It turns out it was done with the Oracle export utility.
August 11, 2009 at 10:06 am
I've initiated an inquiry.
I'll respond when I get an answer.
I hope they're not on holidays...
Thanks for the help so far.
August 6, 2009 at 1:17 pm
Nice!!! The people who did the backup cleverly named the file h26b_full.Mar04 -- no doubt so we could tell it was done on March 4 -- which we already knew...
August 6, 2009 at 12:40 pm
Thanks for that.
Now, I have access to a DB I created, Test.
I have placed it in Mounted mode, which should enable recovery.
I right-click on the Test database, Backup Management, Recovery....
August 6, 2009 at 12:16 pm
Alright, getting somewhere now.
I have the Oracle Management Server up and running, can connect using Oracle EM.
However, when I try to click on my database, I get a login screen....
August 5, 2009 at 11:03 am
Thanks for the response.
These services are running under local system accounts.
OracleOraHome92Agent
OracleOraHome92TNSListener
That's a start, I guess.
I can't find the strings "service name", or "service name" in any .ORA file on...
May 21, 2009 at 1:05 pm
And furthermore, assuming we can switch to app.sec., can we still determine their login name (SUSER_SNAME()) at the server?'
The auditing requires that we know who's done what.
February 10, 2009 at 1:27 pm
Thanks for the quick replies.
OK, more info:
These same users are members of an Active Directory group (IMS_Live), which is granted DB access.
They are to use only one application (IMS) to...
February 10, 2009 at 1:19 pm
Viewing 15 posts - 331 through 345 (of 482 total)