How can my user use MSSQL management studio to restore the DB? Whenever my user try to browse for the db file, he can't browse to his own web folder due to permission error.
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 restored some some databases outside of Plesk in a MSSQL 2008 instance. Plesk knows about the MSSQL intance but is not aware of the databases. I want to add them to Plesk so they will be backed up.
I have read about people wanting to change their database from MSSQL to MySQL. I however am wanting to change from MySQL to Microsoft SQL in our Plesk panel.
I have vps server with win server 2008 and Plesk 11.5.30. when i am trying to copy Mssql Database trough the panel i have an error: " Unable to copy database ". In the %plesk_dir%adminlogs under the php-error.log i have this error:
Logged into my panel today to run a database backup on a site I'm working on to be confronted with the following:
Unable to backup database 'XXXXXXXXXX' Cannot open backup device 'C:Program Files (x86)ParallelsPleskBackupXXXXXXXXX.co.nzdatabasesXXXXXXXXX-29 est'. Operating system error 5(Access is denied.). BACKUP DATABASE is terminating abnormally.
(Error code 21)
I'm not sure why permissions would change on their own, I'm also not sure how to fix the permissions error. I get the same error on all databases.
PrivateTemp folder appears to have write permissions for Group MSSQLSERVER
what level of hardware/hosting plan I need for one of my clients.
Current stats: ~65 ecommerce orders per week ~5000 unique visitors per day
Requirements: Win2k3 ASP.NET 3.5 MSSQL 2005
My first recommendation to them was RackSpace due their good reputation, but they were not able to pay for the plan suggested to them by RackSpace.
My other question is what type of plan do you guys recommend based on the above stats/requirements (managed/VPS/dedicated/etc.)? VPS is what came to mind for me since we'll probably end up using this setup for more than one website/domain and since they are so price sensitive.
I'm fairly comfortable setting up and administering Win2k3 and MSSQL. I'm sure that plays into the choices a little.
I know there is probably some information I have left out that would help you guys make a recommendation. Please just let me know what else would help.
Does anyone know any shared hosting or semi-private VPS hosting for a site with large MS SQL2005 DB? Our DB is currently 1GB already but could get up to 5-10GB when all is said and done. The site is a B2B networking platform with many users, company profiles, products, etc.
i am finding a MSSQL 2005 server for one of my application for my client.
Actually, it is a small business program. It will not have a heavy load on the server.
Do any hosting packages company for that with reasonable price? It is not a website. It is a C# software application. So the port will not be 21 or some web port.
I need a hosting with .net 3.5 support. Prefer 1G MS sql server space. traffic 10-20G is ok. need a stable hosting with good & capable technical support.
anyone can recommend one? I plan to use discountasp, but their sql is too small, 500M only.
Since about 2002 I have constantly had my own co-located and then dedicated box. Before that, the only paid host I ever used was verio.net. Now that I sold off most of my sites, it is time to move to a smaller, shared hosting plan.
My question is can anyone suggest a good hosting plan? I do not need a lot of space or bandwidth, but I do require a few things:
- ASP.net 3.5 is a huge plus, but 2.0 is do-able
- At least one msSQL database
- Daily backups is also a huge plus. I don't need this second, but eventually I will want it.
- Good technical support is a must. I have dealt with to many companies even with my dedicated hosting that offered horrible tech support. A three day wait on a question is not acceptable. Phone support is a plus, but a 24 hour reply on an email is enough.
- ISAPI-Rewrite, or an equivalent is a must. I rewrite my URL's for SE rankings, as I believe everyone should, so the ability to host a rewrite script is a must. Though I use ISAPI-Rewrite, if their is an equivalent that is do-able.
- Need to be able to run at least (2) domains. My main company domain and then a second domain which is basically a landing page. In future I need a 3rd domain added, so ability to upgrade or add on a domain cheaply is a must too.
If you own a hosting company that matches this, or can suggest any please do so. If you suggest and they offer a referral program feel free to let me know your referral code as you obviously deserve the credit for suggesting the company.
I'm working on a new project that involves some heavy data processing in the preparation stage. As an example, one of the setup jobs is now running on a P4-3.0HT desktop at 100% CPU and I estimate it'll be finished in just under a week! Memory and i/o usage are minimal but it's extremely CPU-hungry.
There are other similar jobs to follow and some correlation between the number of cpu cycles and the quality of results so I foresee an ongoing need for computing power for at least a few months.
Viable options are to continue running my own hardware (probably supplementing the P4 with something a bit newer), Amazon EC2 or a cheap dedicated server - I can get a good handle on the cost and performance of each of these.
But I wonder if I'd get more bang per buck from a few VPSs? Some of the VPS benchmark results are spectacular so I suspect the answer could be yes, in the short term anyway. But I don't want to hog the host-node's CPU to the point where it degrades other users' performance or gets my account shut down... Then again, judging by the performance of the VPSs I've used for hosting the node seems to have a lot of spare CPU available...
So (finally) to the questions: Am I crazy to even consider this? If not, which technology would be most suitable? (I'm thinking Xen because of its reputation for better isolation.) Has anyone else done anything similar?
I have two VPS's which run a single MySQL intensive site. The first VPS runs cPanel and has about 50 databases, 200mb each. Second has another 30 databases, of the same size.
What would be the best method to backup this website daily?
At Current; I use automysqlbackup to backup all the databases at midnight (this crashes the VPS's for about 10 minutes each night). This dumps each one into a zipped file.
Then the rsync copies the changed files (forum attachmenets, cpanel changes etc(whole server)) to an off site location.
Are there any easier ways to do this? The databases are most important!
Calling on all hosting and server experts here. (If you're not an expert, still feel free to take an educated stab at this. But please leave out total made up answers or foolish answers like "Have LittleJoeShmoe Hosting services do it all for $9.99/month".)
Scenario: If you knew or were planning on developing a site that you knew would generate millions to tens of millions of page views a day, how would you go about supporting a site of such traffic? The site would not serve up videos, but the average page size would contain up to 75-100kB. It would incorporate databases (user logins, accounts, user submitted content, server side scripting, CMS, etc.)
Don't assume anything. Don't assume you have too little or too much money. Just, what would you plan out to accomodate such a scenario?
What hosting companies would you use? Would you do it in-house and build your own datacenter? Farm out the server management? How much would it cost to implement your plan? What platform would you recommend for a site to handle this much traffic?
I have a friend who has a dedicated server right now that uses a good 4GB for all his website content. (not streaming media but just a whole bunch of scripts and etc. well thats what he tells me). And so anyways, his SQL database is about 1-2GB. And he is not too sure about his monthly traffic but its a social networking site with a good amount of users (so its actively used by many users). Would it be necessary for him to have a dedicated server or do you think he could cut costs with a shared hosting account at like host gator or some other shared hosting service like that? I guess my biggest concern is his current database. A lot of shared hosting companies (from what i saw) offer unlimited Mysql Tables do they have size limits? And does a bigger sql database drastically effect the performance of the overall server?
I'm currently working for a company who are looking to migrate there current business system and also create an e-commerce website.
The company (Company A) who were doing the migration were also going to originally take care of the e-commerce side of things aswell, but after looking at the website solution they have now decided to give it to another company (Company B) to deal with. But seem to be sticking with the original company to do the business system migration.
Now this has created a bit of a problem with regards to the hosting side of things (amongst other things ). Originally this was all going to be hosted by Company A. This would keep it all nicely integrated. But now Company B are doing the e-commerce side of things it needs to somehow integrate with the business database.
And now for the question (about time i hear you ask ). Can you give me the pros and cons of the following scenarios:
Scenario A: We host both business system (database) and webservers onsite.
Scenario B: Company A hosts business (database) solution. We host webserver.
Scenario C: Company A hosts business (database) system. Company B hosts webserver.
I am developer and I ahve done web-site development and database development but it was for other companies where everything was already available.
I was not sure if this was the right place for the post, but I thought I would atleast start here, if I should post this in some other category please let me know.
I am satrting work on a Database driven web-site. I say database driven, becuase the web-site copares prices for multiple products. By some worst case scenarios(explained later) I need a database to easily acoomadate more than 1000 GB of data. I can definitely try cutting this down, but my question is what type of hosting should I choose and how when the web-site is completely relying on data that is updated on a weekly basis.
The reason to keep old data is to use that to show a Price history and forecasting on future Prices. The thought of storing this data locally and just creating a summary has crossed my mind.
The Data Scenario: Price of Products per store: 50,000 Approximate size for the table per store: 3 MB
Number of stores: 500 Avg Size: 1500 MB
This is the bare minimum 1500 MB + other tables + overhead
Other tables: Forum data, Reviewes, User Favorite Products, etc.
Number of weeks: 52 Avg Size: 78 GB
Howevere the table with the most data and the table that would be changing the most is the Price table. So I am approximating the minimum requirement for the Databse to be atleast 2GB.
My question now is:
To be cost effective I can store the history on my personal desktop. But I still need something that allows me to have 2 GB of Database space. What is my best solution?
I have no strict rules about platform or langauge, to get started I am just trying to be cheap but still find a decent web-hosting solution so that by getting started small I have hopes of going big.
if there are any recommendations on managed database hosting services. This will be used for a fairly large project running on Mysql DB. Due to the size and complexity of the database a lot of resources are being used, so I prefer to find a company which specializes in dB hosting.
I'm wondering if someone can recommend a host to me. I know that researching a host before I go with it is important, this is part of my research.
I would like to make a site with ASP.NET 2.0 and a database (MS SQL preferred).
I'm just starting, so I don't have any traffic, but I don't want to rule out the possibility in the future.
I'd like a host that has no lock-in (Does not own my domain name, lets me backup and download my own database files) to a host that scales (allows me to upgrade plans easily, or purchase add-on space and bandwidth), although both are useful, I really don't want to be locked-in.
The site is not for profit (personal) and budget is a concern.
Right now Lunarpages Windows plan is looking good, it does give me a ‘free domain’, but specifies that they do not own it. Does anyone know how easy it is to transfer a free domain from lunarpages to godaddy or another registry? Has anyone had experience with this host for asp.net?
I'm also interested in finding a unbiased, legitimate host searching site that allows me to search hosts by features, with no affiliate links to the hosts reviewed, that do not sell hosting, etc.
I created a database for my site and then a subdomain.
The subdomain is already working but the database still shows pending setup. Normally, the database setup is much faster than the subdomain setup.
I'm not sure what's going on. Their email support sucks. They don't even reply on time. I can't call them because I'm overseas. It would be a very expensive phone call.
This is my first week with them. Do you guys experience this with Godaddy?
I created a SQL Server database that need sto be setup for the customer on their hosting account. The hosting company wanted the sql statemens, ok so I gave it to them to setup my tables and stored procedures. I also mentioned that if they gave me a username and password with database location and catalog name for the connection string and as long as I had create rights for that database I could run my own sql statements via SQL Server Enterprise Manager to set it up. They sent an excuse about how insecure that wasy and that they couldn't send any usernames or passwords for the database to me t set this up.
They also said it's becomming more common for Hosting Companies to not allow access to the databases for thatpurpose. Ok... uh how in the world do they expect to have a programmer create and run their data driven website without that information? I'm confused on what these guys are doing.
So.. is this true? Are more hosting companies hording their database infromation and customer usernames and passwords from the developers?