Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: antzzz
  • Order by date
  1. antzzz

    Invalid buffer received from client

    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...
  2. antzzz

    Step-by-step guide to install Sybase Client on Solaris?

    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.
  3. antzzz

    Restore Database onto another server

    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...
  4. antzzz

    Restore Database onto another server

    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...
  5. antzzz

    what rights to do I need to remotely monitor a server using PerfMon

    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.
  6. antzzz

    Adding a Secondary file in same filegroup

    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...
  7. antzzz

    ocopy.exe utility

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

    ocopy.exe utility

    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
  9. antzzz

    Minimum privileges needed to create user to do RMAN backup

    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
  10. antzzz

    More info needed than given by DBCC OPENTRAN

    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...
  11. antzzz

    Rollback Segments in Oracle 9i using UNDO tablespace

    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...
  12. antzzz

    Under which user account should I run the SQL Server service?

    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...
  13. antzzz

    Best Oracle book to buy under $58?

    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
  14. antzzz

    Any Script to generate INSERT Statements

    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...
  15. antzzz

    Disaster Recovery Scenario

    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...
  16. antzzz

    SQL 2000 Memory problem

    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...
  17. antzzz

    Application Performance Testing

    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...
  18. antzzz

    ArchiveXtender problem

    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...
  19. antzzz

    Env variables not being set in the script

    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"...
  20. antzzz

    Getting message: WARNING: Failed to reserve contiguous memory of Size=

    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...

Part and Inventory Search

Back
Top