Search results for query: *

I'm getting this message once in a while in my SQL Server Error Log. I'm using Windows 2000 Advanced Server SQL Server Enterprise Edition SP3 I saw one article from Microsoft but they talked about some SQl .Net provider issue. None of the applications that connect to my server are .Net...

Does anyone know of a good step-by-step guide on installing the Sybase client on Solaris? I can't seem to pinpoint the information on the manuals provided by Sybase. The Solaris client machine will be connecting to another Solaris server where Sybase ASE 12.0 resides. Thanks for all your help.

Thanks for the info. So if don't do anything on SERVER B, you mean if I do a restore, it will use the physical devices that I have on SERVER B (regardless of whether they have the same names or paths)? Does the backup dump file retain information on physical device paths and filenames from the...

We're using Sybase ASE 12 on Solaris. I took a backup of a database DB1 on SERVER A and put it onto SERVER B in a disk dump file "/opt/sybase/DB1.dmp" and I want to restore this backup on SERVER B. The same database also exists on SERVER B but the data devices and physical device names (and...

I would like to use my Windows XP machine to monitor SQL Server on a remote Windows 2000 server. What are the minimum Windows rights do I need to remotely monitor the other server? I only have have SQL Server sa access but not local admin access on the remote server.

I am using SQL Server 7.0 on Windows 2000 server. Initially, I used a 10GB drive (D:) to hold both my primary data file and log file. When my database size went up to 8 GB, I added another drive (E:) of 20GB size and added a new secondary data file to this drive. I then put a maximum limit of...

hmmm...no reply...time to pack up my bags and move to OTN and dbforum...bye!

I would like to take a hot backup of an Oracle 9i database on Win 2000 using the OCOPY.EXE utility. I'll be backing up all *.CTL, *.LOG, and *.DBF files. Does this utility do the same thing as a level 0 hot backup in RMAN? Pls advise Thanks

I use Oracle 9i on Solaris 8. I want to create a user that does only backups via RMAN. What are the minimum privileges do I need to give to this user? Pls advise Thanks

When I came on a Monday morning, I found out that there was open transaction running since Friday afternoon by using DBCC OPENTRAN. Is there a way to know what SQL Statement is actually not being committed? Is there any utility that I can use to "read" the transaction log? Any help is...

First, I created a database for a vendor with an Undo Tablespace UNDOTBS. Then the vendor requested me to create rollback segments instead. So I created a new tablespace RBSTBS just to hold these segments. When I tried to create the rollback segment using the newly created tablespace RBSTBS...

I've read in a Security article somewhere that I shouldn't be running my SQL Server service under the Local System account or an admin account. I have SQL 2000 SP3 in Win 2000 server. I don't do any replication or use SQL Mail at the moment. It's a dedicated server and clients connect to it...

Hi, My company gave me a budget of $58 to buy any Oracle book. WE use Oracle 9i Rel 2 under Solaris 8 running on a Sun machine. I've already downloaded all the Oracle manuals in PDF form. Is there one book that I should really own and within my budget? Pls advise Thanks

I need to move some data from a test server to a production server. Is there any useful script that I can use to automatically generate INSERT statements for each table that I need to move to production? I don't really like to use a tool like bcp as I'll be inserting some data to critical...

Hi, We're running SQL 2000 on a Windows 2000 server. Drive D is on EMC (75 GB) which contain the User Database data files (.mdf/.ldf); Database1 has total of 20 GB while Database2 has total of 50GB (leaving only 5GB free space). Drive E (50 GB) is also on EMC and is used to hold the Database...

Hi, We have a Win 2000 server with 1 GB RAM hosting a SQL 2000 Standard Ed. (SP3) and small applications called Call Center Agents that broker requests to the database from the Client PCs that host the Call Center Applications. SQL Memory is dynamically allocated. The vendor who developed the...

Hi, My company wants to do Stress, Performance, and Volume testing on a new Core Banking Application. They would like to know what needs to be measured in terms of database performance (CPU,memory,disk IO, etc.) and how to measure them in Oracle. The vendor was saying that we also have to...

I'm using ArchiveXtender to manage a Plasmon Jukebox on my Windows NT 4.0 server. We use 2.5 GB double sided Optical Disks. We recently had a "Backup Disk Full" alert about a couple of weeks back for Volume 457/458 but the Backup Disk was never ejected. Then, we had another "Backup Disk...

Hi, I'm sort of a newbie in Unix. I created a script which tries to set some env variables. I believe I'm using the Korn Shell. I made it executable by doing chmod 711. When I run the script, the env variables are not being set. But I don't get any errors. Actually, my login is "oracle"...

I'm running SQL Server 2000 SP3 Standard Edition with Windows 2000 on a 4 CPU server with 2GB RAM. I am currently receiving some memory messages in the Error Log like the ff: WARNING: Failed to reserve contiguous memory of Size= 65536 . . . <With corresponding procedure/buffer cache messages...