Specing Out A New SQL2k Server...need Help
Jan 23, 2007
We are currently running these specs...
CPU: Dual 2.4Ghz Xeons
RAM: 4GB
HD: Raid 5
OS: Windows 2000 SP4
SQL: SQL 2000 32bit
Our RAM is constantly at 75% of the physical memory. The CPU usage ranges from 10-90%. I need recommendations on brand and specs. I would like to keep the cost under $10k.
It needs to have RAID 1 for the OS and at least 200GB RAID 5 or 10 for the data. We would also like to have hot swappable drives.
Here's the configuration I am considering...
Brand: Dell (Not sold on this yet)
CPU: Dual Quad 2Ghz Xeons
RAM: 8GB
HD 1: 36GB RAID 1
HD 2: 300GB RAID 10
OS: Windows 2003 64bit
SQL: SQL 2005 64bit
What are the pros/cons of upgrading from SQL 2000 32bit to SQL 2005 64bit? Also, any recommendations on the hardware?
View 2 Replies
ADVERTISEMENT
Oct 12, 2007
The company for which I work did not have a DBA until I started a few weeks ago. Whoever installed SQL2K used the wrong CD so they have been running Personal Edition on their servers. I have installed a new SQL2K standard instance and have restored everything except the jobs and DTS packages. Can the msdb from the Personal edition be restored to the standard instance?
View 3 Replies
View Related
Mar 15, 2007
Is it possible to downgrade SQL from Enterprise to Standard Edition, or do you have to remove the previous installation (uninstall) and reinstall. Meaning you would also have to restore all user databases? Thanks.
View 1 Replies
View Related
Aug 16, 2000
Anyone of how to link a SQL2K server to a SQL7.0 server ...
I have tried and the two servers from the NT level can see and talk to each other ... but trying to link the servers is not working ...
Thanks
View 2 Replies
View Related
Jan 17, 2008
Hi,
I have a server that has sql server 2000 standard edition, and I just got a new server but this time I'm going to use sql2005 Express (free version).
My databases are not 2gigs in size, so I should be fine.
What is the best method for me to convert the databases? Is it to just detach the database and re-attach in sql2.5?
View 4 Replies
View Related
Jul 23, 2005
Below is the script. The problem is when I simulated the Oracle linkdrop, my SQL2K never have to a chance to head to the GOTO section as itdies with this error msg and exit. Any idea on a workround? Thanks.Server: Msg 7399, Level 16, State 1, Procedure USP_Link_Check, Line 8OLE DB provider 'MSDAORA' reported an error.[OLE/DB provider returned message: ORA-12154: TNS:could not resolveservice name]OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initializereturned 0x80004005: ].----------------------------------------------ALTER PROCEDURE [USP_Link_Check] ASDECLARE @myERROR int -- Local @@ERROR, @myRowCount int -- Local @@ROWCOUNT--- Verify network connectionsselect *from openquery(OraLink,'select count(*) from Oracle.table')IF @myERROR != 0 GOTO HANDLE_ERRORHANDLE_ERROR:Print ' Error in Oracle Link'RETURN @myERROR---------------------------------------------
View 1 Replies
View Related
Aug 1, 2006
We have a current install of SQL2005 Developer on a Win 2003 Server Enterprise and it works as advertised. It is accessed as Test05
Yesterday a SQL2000 Developer Edition was also installed on the same Server as named instance Test05Test052000.
The 2000 seems to start and run OK and can be connect to by Management studio etc from that same box. However it can not be connect to via the network. Any ideas?
View 1 Replies
View Related
Oct 18, 2006
Hi All,
One of my clients has installed SQL5K at their HeadOffice. However there are some production units are there running under SQL2K. We have one stored procedure which used to update the masters from HO to Units. Under SQL2K it was working fine, but when we run the procedure on HO under SQL5K, it returns the following error message.
**************************************
OLE DB provider "SQLNCLI" for linked server "charlie1" returned message "Unspecified error".
OLE DB provider "SQLNCLI" for linked server "charlie1" returned message "The stored procedure required to complete this operation could not be found on the server. Please contact your system administrator.".
Msg 7311, Level 16, State 2, Line 4
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI" for linked server "charlie1". The provider supports the interface, but returns a failure code when it is used.
*************************************
The above also ocurs when I simply issue the command :
SELECT * FROM [server2K].[Mydatabase].[dbo].[MyTable]
I've tried to add the server with "sp_addlinkedserver" it was added successfully. The login info is same across the servers.
Please help me out I am stuck badly.
Thanks
Raoshan
View 1 Replies
View Related
Nov 30, 2001
Hi,I am having a problem in moving data from execl to sql2k.
The data looks like 16.70% , 12.5% etc and when I move it it changes to 0.16700000000000001 etc..
any idea what datatype I should use so that it don't changes it's mode...
Thanks in advance
View 1 Replies
View Related
Apr 6, 2001
Hi,
I am new to sql 2k.
Iam been asked to install sql2k on a new box .
What all things I should keep in mind when I go for the installation of sql2k?
Any / All suggestions appreciated.
Jai
View 3 Replies
View Related
Apr 6, 2001
Hi,
I have to move 2 fields from sql 7 to sql 2k .
the field is text.
feild a is text
field b is text.
I have to add field a and field b and move it to another field (say field c which is also text )in sql 2k.
How to go about it?
TIA.
Jsi
View 2 Replies
View Related
Jun 23, 2001
I moved my DB from SQL7.0/NT to SQL2k/WIN2k.
Everything was fine from the last few months but suddenly I start getting timeout errors.
I checked and rebuild all the indexes - there are no deadlocking at all - everything looks quite normal to me - I am all lost now as what to monitor and where to see for this timeout error messages.
Anyone has any idea as what is going on what should I check to see if that's the cause.
I also ran Profiler but there too nothing too long as to timeout.
My sql box is attached to IIS box and pager is set on IIS box.
The problem is not with IIS box cuz when I shift the applications to another SQL box everything runs fine and there is no timeout messages.
Any thoughts appreciated.
View 2 Replies
View Related
Jan 23, 2007
I have been sent a backup file from a supplier that I have been trying to restore. I have succesfully installed it on my SQL2K5 instance, however, we need to put it on our SQL Server in our DMZ . . . Which is running SQL2K . . . Supplier was informed of this and says that you can restore to a SQL2K DB as long as you use SQL Management Studio . . . Tried that and got an error message Saying That Restore Headeronly is terminating - Too many backup devices specified. . . only 64 are allowed. . . .Supplier suggests that its a SP4 issue . . . Installed SP4 and tried again . . . Got the Same Error again (SQL Server Error :3205)
Am I out of my gourd I am sure that restoring a SQL2K5 Backup to a SQL2K instance is not possible?
I should say that I am Running SQLExpress as my 2K5 Instance and MSDE as my 2K instance . . . Before I invest more time on this and trying it on a development server running Standard edition.
Thanks All
--
Regards
Tony The DBA
View 4 Replies
View Related
May 9, 2008
Hello,
I am trying to script out a new login in SQL 2000. I can script the login, but I am trying to assign the correct permissions, (e.g. db_datawriter, db_owner) and I am have trouble scripting the permissions. Here is a snippet of what I am looking to accomplish in my script. Remeber, this is 2000 not 2005...
-- This works
exec sp_addlogin @loginame = 'LoginName'
,@passwd = 'Password'
,@defdb = 'Database'
go
-- This doesn't. I am not even sure if this is what I need...
exec sp_addrolemember @rolename = 'AdminCVB'
,@membername = 'db_owner'
go
View 3 Replies
View Related
Aug 31, 2004
hi,
i'm hoping somone can shed some light on why this isn't working. basically i have a webform which that passes data back to a database (SQL Server 2000) and uses Windows authentication to perform the UPDATE, INSERT, whatever.
i've defined a role within the database, specifically for the application. for my tests, i've added a global security group from my Windows domain to the logins on the SQL instance. this group has been added to the custom role in the application database.
since i'm a member of this global security group, i was under the impression that my credentials would pass through and everything would be ok, however, it's not recognizing my login - or others in the group as well.
the application web (in IIS5.0) has been set to Windows Authentication, and i've flagged the impersonate=true attribute in the app's web.config file.
lastly, my connection string for the sqlconnection object grabs my user name (or the current user for that matter) in the format of DOMAINaccount. for the sake of argument, i was able to successfully connect using a custom SQL login that was assigned to the custom role.
the error that's returned specifically states that the "Login failed for DOMAINaccount"
any thoughts on what's up here? i guess i'm not understanding SQL Server security to well. thanks in advance.
View 1 Replies
View Related
Nov 12, 2001
Hi,
Is there a way to prevent new users from accessing a SQL2000 db (like to put it into DBO mode) while leaving current users finish their running jobs.
I tried Alter Database and sp_dboptions and both in SQL2000 requires to close all current users. It was working in SQL7 but not in 2000.
Thanks
AAA
View 3 Replies
View Related
Apr 6, 2001
Does any body know if it is possible to register SQL 2000 server from SQL v7.0 enterprise manager.
Thanks
View 5 Replies
View Related
Jan 4, 2001
I don't have any extra machines, so I'm thinking of evaluating SQL2K on one of my existing boxes with SQL 7 already installed. My experience is that SQL 6.5 co-existed extraordinarily well with SQL 7. Does the same apply to the SQL 7 / SQL 2K combination? Thanks!
View 1 Replies
View Related
Jan 4, 2001
I don't have any extra machines, so I'm thinking of evaluating SQL2K on one of my existing boxes with SQL 7 already installed. My experience is that SQL 6.5 co-existed extraordinarily well with SQL 7. Does the same apply to the SQL 7 / SQL 2K combination? Thanks!
View 3 Replies
View Related
May 24, 2003
I am new to sql2k
previously i used to work with sql7
how do i clear the transaction logs in sql2k
pavan
View 2 Replies
View Related
Sep 17, 2003
I am planning to use XP_CRYPT for encrypting and decrypting cc#'s, passwords etc., at database level. Any suggestions or experiences on this. More info about this product at
http://www.activecrypt.com/faq.htm
View 12 Replies
View Related
Jun 11, 2004
I tried to install SQL Server 2K on a W2K server running IIS and SSL. The SQL installation failed until I deleted the certs from my system. Now, the SQL logs say "SuperSocket Info: Bind failed on TCP port 1433". I have tried everything on the MS KB, TechNet, and MSDN sites that I could find. I have also uninstalled IIS and Certificate Services from the server. Since there are no certs left, I suspect that SQL Server is getting in it's own way on startup. Does anyone know of a way to trap/log this kind of conflict?
View 14 Replies
View Related
Sep 10, 2007
Hello,
I have scheduled a job using Job Agent in SQL2K (Management). Every once in a while i get an error when i view job history:
Executed as user: xxx. Transaction (Process ID 53) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. [SQLSTATE 40001] (Error 1205). The step failed.
The process ID changes for every error. Sometimes its 51, 56, or 54 as well.
I have checked several times, but there is no other process that runs at that time. I even rescheduled it for a different time, but even then it fails about once every week or two.
How can i check what is the other procedure it is deadlocking with, if it is? OR what exactly is the problem, if it is not with any other process?
Any help and/or guidance is much appreciated.
Thanks,
J
View 4 Replies
View Related
Jan 24, 2002
Here is a strange one. Have a sql2k box that I upgraded from 6.5 back. Conversion went fine, everything was ok with the sql install. Created and scheduled maintenance jobs while logged on to the box. A few days after the conversion, Enterprise Manager cannot register the server(error message is 'Data source name not found and connection libraries do not exist'). This inablilty to register the server only occurs when working on the server itself. You can register the server while connecting from another box with EM.
So, do some checking and find that the box itself does not recognize SQLSRV32.dll (etc) as even existing on the box BUT IT DOES EXIST in the normal places, it was a working install just a few days prior. As far as the box is concerned, the network libraries do not exist. Therefore, cannot register the server locally, cannot create a Data Source using the SQLSRV32 driver, cannot start the Sql Server Agent(so no scheduled back ups, etc).
Went so far as to re install the connectivity and client tools, which did not fix the issue.
Does anyone have any ideas?
View 1 Replies
View Related
Jan 26, 2002
I am trying to configure a 2 node SQL cluster. MSCS is configured and is failing over correctly, however when I start the installation of SQL Server, and specify the IP address of the virtual server and hit next, the installation hangs, and stops responding. I have configured MS DTC and verified that it shows up in the cluster administrator. I am not sure what else to do, please help.
View 2 Replies
View Related
Apr 8, 2002
We are running SQL2000 on Compaq 8500, want to upgrade the RAM from 4GB to 6GB. What do I need to change in SQL in order to see the more memory?
We want to leave only 1GB for the OS and the rest for SQL2K.
Thanks
View 1 Replies
View Related
Dec 30, 2005
Hi
I have an sql server with very high usage. The web which is connected to the sql server has approx. 1000 unique visitors every time.
The database is optimized and the site goes really fast now.
But a problem we've had since the beginning is that SQL Server constantly uses 1.8 GB of RAM. Never less, never more.
Do you have any idea on how to decrease the usage of RAM. I am sure that this high usage is necessary.
View 4 Replies
View Related
Apr 16, 2004
Hello,
I had a peculiar problem yesterday with SQLserver2000 database restore from one server to the other. I copied the .BAK file ( 11.2 GB) from source server to target server. Target server already had the same name database. I use SEM to do restore the database using the disk file .BAK as source to restore. The NT drive space was 13.5 GB available after copying. Restore failed with an error that not enough disk space is available to restore and it needs 23 GB of space for expansion. What does it mean? The database went into "Loading" state and it got corrupted. I tried to drop the database and cleared the DBF and LDF files on the drive and again tried to restore from .BAK file but it failed again with the same error message that not enough space is available for expansion. Now I do not have the original database or am not able to build the new database.
Finally I did attach/detach methods where I could bring back the database in running state.
What is it complaining about not enough space? Why did it ask for almost 100% more space for some expansion in restore process?
Why it did not fail when doing attach/detach methods from other server.
Any valid explanation is appreciated.
Vinnie
View 2 Replies
View Related
May 8, 2004
Hi All,
I have installed a dual node active passive W2K3 Clusters with SQL 2K.
The cluster has RAID10 for data and RAID1 for Quorum and Transaction Logs.
How do I put the Transaction logs on the RAID1 disk as at install SQL2K only asks where you would like to put the SQL data ?
Any tips appreciated.
View 2 Replies
View Related
May 3, 2007
When I access SQL2K using ODBC (linked table manager), I am not able to display any data. The columns show #Deleted as their data values. How do I display data in ACCESS from SQL2K tables?
View 18 Replies
View Related
Sep 18, 2007
Hi, all,
I did not see this one coming, and I am not sure if I did something wrong.
How do you push data from sql05 to sql2k?
I set up a data flow task, with one sql05 connection magager and another sql2k connection manager. Then when I tried to map them, I cann't!
The message on the box said: The connection manager uses an earlier version of sql server provider. Bulk insert operations require a connection that uses a sql server 2005 provider.
I have been trying different source, destination and transformation, but seems like missing something.
Thanks!
View 3 Replies
View Related
Dec 5, 2007
Hi,
I tried restoring a sql2000 database into sql2005 but the import failed. Is it possible to do a import like this or do you have to do some kind of db conversion?
View 1 Replies
View Related
Jul 23, 2005
hello all,my configuration is: Sql 2000 SP3, OS win2003 serverwhen i try a query with enterprise manager the error message appaers[Microsoft][ODBC SQL Driver] timeout expiredi verify all components ( query time out settings ....)but nothing changePLEASE HELP ME !!Thank you
View 1 Replies
View Related
