Backing Up MS SQL 2000
Apr 25, 2007
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.
View 0 Replies
ADVERTISEMENT
Mar 6, 2007
Is there a registry key that can distinguish between Windows 2000 and Windows 2000 server?
In
HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionProductName
That key is Windows 2000 for both Win 2k and Win 2k server so if there's anything else that would be GREAT.
View 2 Replies
View Related
May 25, 2009
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.
View 10 Replies
View Related
Mar 12, 2009
How well patched and secure is Windows 2000 and old ASP as it stands today? I am considering using this combo for something and need to know if there is anything I need to be concerned about?
View 4 Replies
View Related
Jun 8, 2007
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?
View 4 Replies
View Related
Mar 12, 2007
Our windows 2000 NT server will not allow users to login to the FTP unless they are classified as administrators. I have the domain set up with all of the correct permissions (to my knowledge).
1. Access to FTP folders
2. Access to Read under FTP
If there is some permission not set, please let me know.
The users are added to the Domain controller under Active Directory. I saw a post about the same exact problem on another forum, but there was no answer.
View 3 Replies
View Related
Apr 14, 2008
Recently I have noticed at least a couple of SQL 2000 databses hacked in different servers. The hacker inserts a javascript code whose source is [url] file. The code is inserted in all records of some tables especially the tables having html code in the records. We are running SQL 2000 on some unused port and not the default port and also we have firewalls enabled in all the servers. We also have the latest updates and fixes applied in the servers. Can anybody throw some light on this and help me find the cause and solution to prevent this from happening again?
View 14 Replies
View Related
Feb 14, 2008
Rather than repost everything and cause multiple search engine results, anyone know the answer to this little issue I am having?
View 6 Replies
View Related
Nov 12, 2008
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.
View 0 Replies
View Related
Apr 23, 2007
These few days I keep having error logs for form delivery
Message delivery to the remote domain 'xxx.xxx' failed for the following reason: Unable to deliver the message because the destination address was misconfigured as a mail loop.
Perviously everything was fine , wonder anyone know what could have suddenly cause this issue.
View 2 Replies
View Related
Oct 27, 2007
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
View 4 Replies
View Related
Jan 19, 2007
I keep getting
The website has encountered a problem and cannot display the page you are trying to view. The options provided below might help you solve the problem.
For self-help options:
Frequently Asked Questions
Find Solutions
Windows Update Newsgroup
For assisted support options:
Microsoft Online Assisted Support (no-cost for Windows Update issues)
I followed their FAQ and still cant update.I am already using IE 6
View 12 Replies
View Related
Nov 8, 2007
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?
View 1 Replies
View Related
Jul 17, 2008
I currently run the odd backup using rsync on my linux computer. However, for convenience I'd like to run backups on windows to my desktop PC.
I was just wondering if anyone knew of a decent program that does incremental backups, hopefully via rsync. My VPS is running debian.
What I'd love to have is a backup folder containing 12 monthly backups and 7 daily backups:
daily.0
daily.1
daily.2
daily.3
daily.4
daily.5
daily.6
monthly.0
monthly.1
monthly.2
monthly.3
monthly.4
...
Any idea if this can be done in windows? If not windows, is there an easy to use script I can set up on my linux computer?
View 4 Replies
View Related
Dec 12, 2007
What and how often you backup on Centos/cpanel/fantastico/rvskins/rvsitebuilder installed server??
Can you still make backups to 2nd hd, if you're running raid-1?? Is it recommended?
View 3 Replies
View Related
Apr 11, 2008
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.
View 3 Replies
View Related
May 1, 2007
I recently signed up with cartikahosting.com only to find out they do not support SQL server 2005 when I tried to install my application.
Their features and price are excellent so I would like to stay with cartika if possible, is there a way to convert my database to 2000? Or backup the database using sql server scripts?
View 4 Replies
View Related
Mar 17, 2005
I am looking for some good tutorials or advice on backing up IMAP mail directly from the server.
Does anyone have any?
View 2 Replies
View Related
Feb 18, 2009
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?
View 2 Replies
View Related
Jul 8, 2009
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.
View 1 Replies
View Related
Oct 26, 2009
I have a cPanel control panel for my site and noticed the backup feature.
Now my site consists of a homepage and a vBulletin forum. If I use the cPanel backup feature will this backup my entire vBulletin forum as well?
I just want something where I can backup on a weekly basis with a click of a button if possible.
Also, is it simply a case of clicking a few buttons to restore the backup should I need to at a later date?
View 11 Replies
View Related
May 12, 2008
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.
View 2 Replies
View Related
Feb 20, 2007
I just ran into a problem. My cPanel license expired, and im in the middle of moving my site over to a new host.
However I cant access any of my sites cPanel,so i can go straight to phpmyadmin to backup.
My question would be:
Is it posible to backup all DBs in the server via shh?
Or is it posible to upload phpmyadmin to every sites root folder and after configuring
it to access the DBs?
View 14 Replies
View Related
Jan 17, 2007
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).
View 3 Replies
View Related
Aug 21, 2009
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?
View 1 Replies
View Related
Mar 11, 2008
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.
View 2 Replies
View Related
Apr 12, 2008
Would anyone have an idea how much resources it would take to seed 1000 - 2000 torrents ?
The bandwidth is not the problem, i am mostly concerned with what kind of box i should get. should i concentrate more on ram or more on cpu or do i need both?
View 11 Replies
View Related
May 23, 2008
to migrate some Windows 2000 and Window 2003 server from 1 IDC to another. Wonder what is the easiest way to change all the IPs in the IIS?
View 2 Replies
View Related
Aug 9, 2008
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.
View 0 Replies
View Related
Nov 27, 2007
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?
View 1 Replies
View Related
Aug 19, 2007
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.
View 2 Replies
View Related
