one of my servers currently died (it was a 1u System) Dual Xeon, 3GB RAM. I need the DATA off my SCSI harddrives.. i have a 2U system only, but when i try and put the SCSI harddrive into the Machine, windows crashes on the "Windows 2003 " starting screen. Windows, ugh, horrible. I need to get into windows to get my MSSQL database's backed up and then moved to a new server.
View 11 RepliesI have two servers which both run (very) large databases. To put that into context, one has about 40,000,000 database entries whilst the other has around 100,000,000.
These both currently run on 250GB SATA-II's. I'm considering adding a 147GB SA-SCSI 15k in replace for the 250GB SATA-II's for the live databases.
Would this be beneficial? I've no experience with faster speeded HDD's - especially on servers.
Reason I ask is I have some web applications which access these databases and can often take a while (minutes) to look up data.
I already have MSSQL 2005 on my server, one my the client requested us to install MSSQL express and they want to use the FOC version.
Can I run MSSQL server + MSSQL server express concurrently? Anybody can give me guidelines how to install it?
Do I need to uninstall MSSQL or it would be as easy as installing MSSQL express on top of MSSQL server.
there is no one didnot hear about the Price increased @ LT
so i may need to know and ask evry body..
where did you moved ?
or
where are you think to be moved to?
i'll be more than happey if you help us and tell us with why did you moved to this one
I'm currently getting DDoSed. I'm on a VPS and my host has asked me to get the troubled domain off the server asap.
Question is, should I move to a dedicated to avoid affecting other users? Or should I find some shared/VPS hosting which has ddos protection?
If you check out [url], you can see that its not running super fast. The load is nothing, iostat, vmstat, etc don't show anything out of the ordinary. Is there anything else I can do to see what might be causing it? Am I just in need of some good mysql optimization?
View 6 Replies View RelatedNot all the data was backed up into /var/lib/psa/dumps/domains/xyz.com/databases/xyz successfully.
Use of chdir('') or chdir(undef) as chdir() is deprecated at /usr/local/psa/PMM/agents/shared/Storage/Bundle.pm line 39.
mysqldump: Couldn't execute 'show table status like 'xyz'': Can't read dir of './xyz/' (errno: 24) (1018)
I can see lot of MSSQL Server attacks. In event viewer "Login failed for user 'sa'. [CLIENT: Some IP]"
Most of the attack coming from Chaina. Tipically what I'm doing manually is get that entire IP range and block from Windows Firewall level.
Now I have plenty of blocked IP ranges all over the world.
What would be the best way to avoid from those kind of attacks ?
I have MSSQL 2005 running on the W2k server, can i install SQL Server Express on top of it w/o causing any disruption to other services including MSSQL.
View 2 Replies View RelatedIf I go into the Backup Manager, then click the "Personal FTP Repository", then click "Personal FTP Repository Settings", at the bottom it asks for a password and says how important it is to use a password.
So, I specify a password, then successfully do a backup to a remote FTP site.
But when I examine the backup.zip file at the remote FTP site, it a plain ZIP file that you can open without any password!!!
How is this secure, what's the point of asking us to specify a password when it's not used to password lock the backed up ZIP file?
asp.net 2.0 + mssql server 2005 + ajaxtoolkit support
I need windows hosting with asp.net 2.0 + mssql server 2005 + ajaxtoolkit support for a website project that is being developed. It can probably be launched on shared hosting, but I would prefer at least a VPS. With any success this site would eventually need to be hosted on a dedicated server.
I have been offered a 1U Dell server for free with Windows Server 2003, Dual Xenon Processors, 2 GB ram and 2 x 80gb hard drives. It would probably serve the site well for a long time, but I would need to set it up (or get it setup $) for the above requirements and get it colocated somewhere. BTW, I'm not too familiar with Windows hosting.
To launch the site, I don't really want to spend more than $100 per month. And I'd prefer to stay in the $50 per month range if possible.
Open to any and all suggestions, comments, questions at this point? I've searched and see a lot of suggestions for shared hosting, but I'd really like your opinions on colocating the dedicated server.
My question is regarding Microsoft Access Databases and ASP.NET. I know that you need SQL server installed so that your website can communicate with any sql databases in use. Do you need Microsoft Access installed on a server where you accessing a MS Access Database?
View 1 Replies View RelatedI would like to build a personal website powered by a content management system and I'm wondering: How many SQL Server databases a site requires? At the Godaddy.com site, the plans for Windows offer one, two or three SQL databases and at least 10 MySQL databases.
The integration with MySQL is easy?
I have an account which used a remote MSSQL server which I have since deactivated, but before deactivating I forgot to remove the DB and Server from plesk.
So now I can't remove the remote MSSQL server from plesk as there is a DB associated with it, and I can't remove the DB because it obviously can't find the remote server! I'm now stuck in a loop!
How I can force remove the DB/User from plesk and then the remote server ? I'm now receiving errors whilst backing up the account, so needs to be done.
I have Plesk 12 on Windows Server 2012 and SQL 2014 Express, and I am unable to add the SQL server to Plesk. It looks like it is waiting for a long time for something, then I get this error:
Get database server version failed: mssqlmng failed: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (Error code 1)Click to expand...
When using a remote MSSQL server, the Webadmin link fails to load in a redirect loop.
Is there any way to change this link or disable it?
How can i check (using SSH) which databases/users cause server load to mysql ?
I've tried "mysqladmin proc stat" but it shows just the current. How can i get stats of the last 24 hours for example ?
I've also seen slow connections stats. What is the command to check more detailed report of the slow connections; which databases caused it etc', in the last 24 hours for example as well.
I am using Windows XP Pro, and since I updated to Internet Explorer 7 I am having problems getting web sites to work on my PC in Internet Explorer using the local IIS web server. These web sites are using ASP and Access databases.
The two errors I get are:
Operation must use an updateable query.
or
Cannot modify the design of table 'TABLE_NAME'. It is in a read-only database. (they are not read only!)
Does anyone know how I can get this working so I can test my web sites locally before uploading them to the live sites?
Since I have never worked on the server end of things I had a quick question for all you web hosting gurus.
Is it possible to have PHP installed on ONE single server and still have the ability for the server to work with both MS Access AND MySQL at the same time?
I would think YES, but I am being told by our server branch at my current job that this is not the case. They claim there is no way for the server on one machine to be able to handle both types of databases. Are they right?
If they are wrong and it is possible to have one server run both type of databases, what steps would be necessary to set up the server to handle both types? Do we need to tweak the php.ini file or is there another method of allowing the server the ability to work with both MySQL and MS Access.
Sorry if this question seems stupid or odd, as I said, I have minimal experience on the server end but I am confident that a server can handle both.
How do I get MSSQL Server and MySQL working on the same server?
I have MySQL running but in PHP.INI when I uncomment the extension=php_mssql.dll line MySQL stops working.
Why is this?
I'm trying to upload backup ms sql server file. But the Control panel tells me error: "Error: copy_file failed: filemng cp failed:"
View 4 Replies View RelatedI have upgrade my mysql plesk installation from 5.1 to 5.6 and have troubles in setting utf8mb4 charset for server and databases. Special characters still display badly in my websites. I'm running Windows Server 2012 R2 and plsk 12.
View 1 Replies View RelatedI`ve just got a new Windows 2003 Web Edition box and now I`m going to install a database server on that.
MSSQL 2005 license would costs 270$/mo for me, So thats not possible to use it because of its price.
I`m not sure if MSSQL Express 2005 or MSDE (which are free) can handle all requirements of ASP.NET programmers or not.
Is there any limitations for major scripts on those? or will those make any doubts for programmers?
Please share your experiences and suggestions.
* I`m going to install "Hosting Controller" on that box.
Since I moved to vps emails are some how being blocked by hotmail.
I have a forum which needs email activation but those registering with hotmail do not receive emails
Now cpanel is having some issues. Certain places acknowledge the new IP, others don't. IE all of my nameservers are still set to the old IP's and I can't seem to change them because they are already asigned to the old ones, etc. What can I do to try to fix all of this? Is there an easy tool? Is there a file I can just change?
View 1 Replies View RelatedQuestion for people who have moved to InnoDB: I wonder if it is worthwhile?
I don't care about ACID compliance, my only interest is in the row level locking which I do not get with large MYISAM tables which do table locking and clog up everything. I have a huge database that needs frequent updates, like 50,000 per hour. I also don't care about InnoDB's large size of indexes and such, I have lots of hard disk to throw at it.
My fear is with the backup of InnoDB tables, and the fact that it is not as simple to "fire up" the tables when I restart the database. MySQL manual suggests something like a query to "Warm up" the tables.
Any thoughts would be great, and if possible, any help with what settings you use. FYI, I am on a 4GB RAM machine with dual Core2Duo procs. When I tried the following in my.cnf for the InnoDB stuff ---
Code:
#skip-innodb
innodb_buffer_pool_size=1G
# Set the log file size to about 25% of the buffer pool size
innodb_log_file_size=250M
innodb_log_buffer_size=8M
innodb_data_file_path=/idbdata1:200M:autoextend
innodb_additional_mem_pool_size=20M
innodb_log_group_home_dir = /iblogs
innodb_log_files_in_group = 2
innodb_flush_log_at_trx_commit=1
innodb_lock_wait_timeout=10
--- the MySQLD wouldn't start! Question about the stuff in red: what're those paths for?
Do I need to create those paths?
I been reading this forum for a while now and now i have a VPS for my blog. The reason i moved from shared to VPS was due to my old webhost told me i was usuing to many CPU power and it was causing the server to crash.
Now with the VPS same thing is still happening. My apache keeps hanging due to too many connections and only way to bring my site up is rebooting the VPS. i contacted the webhosting and they have me setup a cronjob to restar httpd every hour but that still doesnt do it.
This is killing me. I get around 1 million hits a month on my blog. I tried optimizing my apache and sql with the instructions i found here but it didnt help.
this is the plan i have:
Disk Space 30,000 MB (30 GB)
CPU Limit Equal Share
Guranteed Memory 256 MB
Burstable Memory 1024 MB
Monthly Bandwidth 2,000 GB
Control Panel cPanel / WHM
I recently moved my website from a shared hosting plan at Siteground to a VPS at WiredTree. All went well but I have this problem : When I try to access my website I can't. I get :
Forbidden
You don't have permission to access / on this server.
Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request.
This happens only for my home computer. If I try to access the website from anywhere else (even via my mobile phone) it works like a charm.
I am thinking this might be a DNS cache problem. Anyone can help me better understand the problem and solve it?