MSSQL Database's Backed Up And Then Moved To A New Server
Jan 5, 2007
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.
I 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.
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?
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.
If 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?
I 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.
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...
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.
I 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.
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?
Question 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?
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?