Search results for query: *

Hi, We want install 2 reporting service on a 2 node sql clustering. I read some articles and awared of the scale out need use Enterprise Edition of SQL Server. the problem is we already have the standard edition of sql clustering setup, can we install the SSRS using enterprise edition? Is it...

I'm new to the SQL Clustering. Can someone give me some good reading material for me to start to know it?

We have a lot of message like following: SQL Server has encountered 294 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\MSSQL\DATA\tempdb.mdf] in database [tempdb] (2). The OS file handle is 0x00000814. The offset of the latest long I/O is...

Someone deleted the databases on purpose, the SQL Server starting fine and most of the critical production databases are gone. The people who did this must have dba password or can physically logon the box. Looks like the error logs are also modified. Is there any way we can trace this event in...

I have a windows box have oracle 9i installed. I install another oracle 10G home and create a 10G database. I didn't touch the existing 9i database, but the application running on the same box that connecting to the 9i database stops working. Give me error like 'can't resolve service name..."...

Hi, This is a real trouble for me! I didn't aware of the messy before I started doing upgrade for a 9i database on a wondows server. I made a cold backup for the database files as well as the controls files and redo files, then I started the DBUA, it fails in the middle. Now I realized I...

In SQL Server 2005, the syntax for index reorganize is awful. it's like: alter index <index name> on <table name>.<column name> reorganize I tried to first detect the fragmented index and then using alter index ... reorg ... to defrag them. But this weird syntax blocks me. Is it necessary to...

Following query is complained by our user that it is too slow: PLAN_TABLE_OUTPUT ------------------------------------------------------------------------------------------------------------------------------------ Plan hash value: 735290276...

If the response of a dataabse getting slow, what is the steps we need to check it? I looked the OS using vmstat, I can see that the CPU idle is 0 when the database is being used. kthr memory page faults cpu ----- ----------- ------------------------...

I want duplicate a database on a different server. I am pretty clear about the process. But the issue is that the source database is 9.2.0.5 and the target machine only have 9.2.0.7 installed. Do I need to upgrade the source database to 9.2.0.7 before I copy over the database? Thanks!

The process to configure the log shipping seems to be very easy, then after the configuration the database is initialized on the secondary server. but the transaction logs generated to the target server had never been restored to the secondary database. I don't know where to check the error...

I upgraded one of our databases, there are some objects under XDB and ORDPLUGINS invalid, any idea? Thanks

We are planing 10g upgrade on one of our 9i database, the chanlleange is that it's 9i enterprise edition and we need to upgrade it to 10G standard edition. I was told the only way I can do is export and import, my question is which system schema I need export and then import to 10G? I don't...

I backuped the database using level 0 incremental and level 1 incremental, then I wanted to restore it, but the rman doesn't pick up the latest change which I believe included in the level 1 incremental. What I missed? Thanks

To specify multiple channels in RMAN only for backing up to tape, right? Thanks

When I backup a database at level 0, I want rman backup everything including the readonly datafiles too. It seems it's not and I don't know how to force it to, since the backup tape will be recycled once a while, we need the readonly datafiles written to the tapes too when the oldest tape is...

I want use RMAN as our backup tool, it seems there are not so much materials I can find in the internet about it. I collected piece by piece, here and there, hard to get a clear picture of RMAN really like. Any good articles for it? Thanks

I'm testing RMAN with oracle netbackup client. I deleted all the datafiles as well as the control files. Then I wasn't able to restore the database from RMAN, because the database should be in mount mode to start restore. so I wanted to create controlfiles, it seems I can't create control files...

We want to use rman to do the backup/restore. I installed the netbackup for oracle, I can do backup eithor from the wizard or the script. The problem is that I can't get the restore working, it complain can't find the backupset on the tape. Anyone have experience on this? Thanks.

It's old topic. I have a sql server 2000 database, there are a lots login account created and I want them copied to the SQL Server 2005, how can I do that? Thanks!