I am basically a Mac user and my windows desktop just went kaput. I am looking for a cheap and dirty way to make back-ups of my MS SQL 2000 DB.
Is it possible to run a script that creates a copy of it in MS Access which can later be convereted back into MS SQL?
Is it possible to go from MS SQL to MySQL?
The MS SQL 2000 server is hosted on a shared server and I cannot leave DTS packages on it. I prefer not to go the DTS route as it goes way over my head anyway. I do, by the way, have a dedicated Win 2003 server.
I'm leasing a single dedicated server and it's over 2 TB of traffic this month. It should be almost 3 TB by the end of this month.
The site is very well optimized (mostly static pages, cache, lighttpd, etc) and I'm guessing it could survive 6-10 TB/month traffic with one server.
Traffic is growing for the third month in a row. Not much, but it's noticeable.
It's the first time I'm over standard 2 TB traffic limit. I'm hosting at Leaseweb and I asked them how much does it cost to upgrade my bandwidth, but haven't heard from them since last Friday.
Where do I get a server with a decent amount of bandwidth and wouldn't have to sell my soul to afford it? The problem is, my budget is quite low (hence all the optimizations on the site - to save money on hardware).
Most of my traffic is from US, so I may have to consider American host.
A customer of ours is looking to use ColdFusion and MS SQL 2000.
Our VPS provider does not provide for ColdFusion or MS SQL so we referred them to another host. This host is unable to properly configure for their needs, and we are standing by the client to assist until everything is working properly.
Can anyone recommend a good host who provides cold fusion / ms sql plans using VPS?
Is this too much to ask and should they be looking at a dedicated server?
to change the external IP address on a Windows SBS 2000 server running Exchange. Is there a wizard to handle changes to the NIC, Exchange, etc, all at once? Or do I have to go into each one and change the settings?
Also, does anyone know of a good guide for doing this that might be posted on the Internet? I looked but could not find anything.
I have successfully installed PHP onto my MS Server 2000 platform, and can execute the files without problem.
html files no longer work, but I think this is to be expected? Renaming them .php allows them to work.
However, I am struggling to set a default page - I have gone to 'document' in the IIS settings, and removed all other default pages, and added index.php. This has not worked. I can access xxx.myserver.com/index.php, but it does not show when accessing xxx.myserver.com
After I create a backup of a VPS using Virtuozzo (I'm using the 1and1 VPS), where is the image stored? Is it necessary to manually save this image to a different server, or do 1and1 take of that automatically?
The minimum requirements that I am seeking for is that it must be a Windows 2000 or Windows XP machine with at least 1024 MB of DDR PC3200 RAM and at least a single-core 2 GHz CPU whether it be AMD or Intel (something suitable for a gameserver and webserver combo), 40GB SATA/RAID Harddrive, and a Full Duplex 100 Mbit port with plenty of bandwidth to run a 32-Player 66tic CSS Server.
The price range that I seek is between $60 to $120 per month.
I understand that servers can do automatic backups of information, yet I also see forum modifications that enable simple ways of doing a backup. Are there different types of backups? Why is it necessary to manually backup a forum database when its done automatically by the server? In terms of assuring the data, what is required and whats a typical procedure, what does it entail, is it manual and if so usually how often, or is it usually automatic?
I currently have 2 VPS accounts. The first one runs cPanel and hosts my website's files.
The second VPS hosts the mysql databases which the website uses. There are about 70 databases, each averaging about 120MB in size.
At current, i use sourceforge.net/projects/automysqlbackup/ to backup each database over two days. (This crashes the server briefly for about 10 minutes per day ). I then use rsync on both servers to backup everything to off-site location.
Obviously, I need to find a better solution. I was thinking about backing up the databases weekly instead. However, the 10 minute downtime period from the script will still happen.
We have a dedicated server with CPanel/WHM. It appears that the CPanel/WHM backup portion of the control panel is not functioning properly, as we just had an incident where all mySQL databases were deleted from the system and the last backup we had was from 03/31/08. This is not acceptable, as we need to have atleast at the min. weekly backups done of our system.
We are in need of a FREE 3rd Party (preferrably open source) solution where we can install on our Linux CentOS system to be able to have backups, and would like to have this software preferrably be able to backup to a remote location, but this is not required.
Just had a quick question about backing up a large MySQL DB. I have a database that is 50gb with about half a billion entries in it. One table itself is about 40gb, the other 10gb consists of smaller tables.
The problem is, I want to back the database up and be able to keep it LIVE at the same time (as it will fall behind quickly if it's pulled for more than a few hours, as there are somewhere in the area of a million entries an hour, plus other deletions and queries).
I have a windows 2000 server and I would like to configure two domain names, c.com and bnvsaj.c.com and requests to these domains should be forwarded to 192.168.0.1 and 192.168.0.2. How can I configure like this?
how do you guys do the maintenance for shared hosting SQL 2000/2005? Do you just let the customers do the maintenance, compacting and optimizing themselves or do you scheduled a task to do that?
Till now I had let my clients do that. But some clients it seemed do not really know much about this. But if we were to compact or optimize all the databases by task scheduling, I am worried that it is something against their privacy.
Can I upgrade MS SQL 2000 Standard Edition to SQL 2005 Express Edition? I know I can upgrade to SQL 2005 Standard as well as Enterprise Editions, but I want to know if I can also upgrade to the SQL 2005 Express Edition.
I have a Windows 2000 Advanced Server where there's a performance issue with some of the .asp pages that retrieve data from Access databases, (I know Access databases aren't ideal for data). These pages will just get stuck/freeze, and then either suddenly spring back to life, or give a script timeout error 0113.
The largest Access database I've seen is 136MB (is that way too large?)
I will probably move some of the large Access databases onto a different server but before I do:
- Are there any tools you can recommend to diagnose exactly what files / databases are causing the problem. I don't think the Win 2000 performance monitor tools even work.
- Can anyone explain more about the technicalities behind this issue. I expect it has something to do with processes, threads, memory, Access drivers being loaded into memory etc etc. Can anyone tell me what they know to put me in the picture better?
I have a Windows 2000 server running Raid 1 software raid. Recently, one hard disk in the mirror crash, I replace another trying to build the mirror. Problem is the existing hard disk has a few bad blocks, even after chkdsk it still failed to rebuild the software raid, error msg was due to bad blocks in the existing hard disk.