Apr 07, 2015 08:33 AM|jellyman|LINK
I'm wondering can you help me please? I have inherited an ASP.NET 3.5 application talking to a Sql Server 2005 database. Both application and database are on the same box. I do not believe the database is backed up regularly.
The application is not hugh and the writes to the database amount to about 10MB per day. Application stack is light enough with just a front-end that talks to the database. No web service for example.
Here are my questions:
Q1: Should I seperate the database from the application? If yes, what type of box/server should I deploy the Sql Server onto?
Q2: Should I make regular backups of the database? If yes, how do I do that? (pointers would be great)
Q3: Should I investigate failover and redundency of the application server? ie if the application server falls over I would like another server to kick in immediately? What is the easiest way to implement this? Any good experiences you would like ot share
or articles you know of?
Thanks in advance for any comments you would like to share.