Upgrading From MS SQL 2000 To SQL 2005 Express Edition
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.
I have never upgraded SQL 2005 express edition before thats why a bit worried. What is the safest way to upgrade it to Service Pack 1? Secondly the management console upgrade. Which to upgrade first the SQL or the SQL Express Management console?
I am using SQL 2005 Express Management Console in the CTP version, but when I upgrade to the release version, it can't login. Do I need to upgrade the SQL 2005 Express to Service Pack 2 first before it can login? Anyone facing similiar issues?
Secondly is there anyway I can upgrade from SQL 2005 Express to SQL 2005 Express Advance version?
I have one customer installed with plesk 11.5 + power pack integrated with mssql 2008 express on his server.But now client want to install Mssql 2008 web edition. Is this possible to replace the express edition with web in plesk panel?
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.
I have some questions about Windows 2003. I have tested many different Windows VPS hosts and I have noticed that some of them offers Windows 2003 enterprise edition and some offers Datacenter edition. What is the difference between the two?
I remember that godaddy had datacenter ed and the vps I use now (eukhost) is using enterprise edition.
According to microsoft, Only SQL Express 2005 can be installed on windows 2003 web edition. N other sql server editions allowed. Sure, ok. So I downloaded express (SQLEXPR_ADV.EXE) and go to install. Install always stops (shuts down) with no warning ...
smooth Microsoft, really smooth.
-- And before anybody chimes in. Yes .net 2.0 and 3.0 are installed.
I am trying to transfer around 20 accounts from one server to another, via cpanel/whms multi transfer account script. I notice that cpanel/whm has the express transfer feature which is the following :
"Express Transfer = This will edit the zone on remote server to reflect the new DNS which can result in expedited propagation, forward any incoming mail from the remote server to the new server, suspend the account on the remote server, and prevent dynamic content from being loaded on the remote server (so no data will be lost)."
For some reason I can't seem to activate the express transfer option, or even figure out how to use it at that matter. Can someone please tell me how in the world I can enable this option? It will save me a huge headache from having to redirect the DNS zones manually.
I want to install ASP.NET 2.0 and MS SQL2005 express on a VPS server, which provides me with 256 MB's of dedicated ram, and I was wondering if anyone with the same type of setup has experienced performance problems.
My bandwidth requirements will be low, but the site is completely database driven so I'm wondering if a VPS server account will suffice.
Any comments would be greatly appreciated!
Also, if anyone knows a cheap, reasonably reliable host that provides dedicated windows hosting for around $60.00? Can you please tell me who they are.
I have a customer who has a problem, today when he opened Outlook Express, it downloaded his new mails and deleted them automatically and also other mails, then when he clicked the "Trash" directory, it was empty. He checked if no one set rules, and the rules dialog is empty. He says his antivirus is up-to-date.
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?
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 am looking for a cheap sata controller that can do JBOD with a PCI Express interface(preferably low profile, 2U server) and proper driver support for linux and solaris. The cheapeast one I found is from supermicro but I don't think they can be used in non-supermicro servers. Any suggestions?
I was wondering if anyone know how the anon edition is suppose to look? Is it just like a regular edition? From what I read, it is an honor system where you trust the client not to break the license. Am I wrong here? Would there be anything built in to prevent a client from running authenticated softwares? built into the OS itself?
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
how can i make it work my pop3 and smtp in Express 2004?
The error messege is
Code: The host 'pop3.site.com' could not be found. Please verify that you have entered the server name correctly. Account: 'pop3.site.com', Server: 'pop3.site.com', Protocol: POP3, Port: 110, Secure(SSL): No, Socket Error: 11004, Error Number: 0x800CCC0D