SQL server 2008
Posted on 2013-01-02
I would appreaciate if someone could comprehensively enlighten me on this.
Can anyone answer the following terms in context of installation of SQL 2008 database server.
What is the recommendation for SQL Compatibility Level requirement (80, 90 or 100)?
while installation of the database for an application,if the application documentation does not mention it at all.
What is recovery model (simple & full). what should be the model if the application does not mention it at all.what is "point in time restore" needs?
What should be the Autogrowth recommendations for db. should the autogrowth turned on or off. if the application does not mention it at all.the application only mentions that you can add filegroups later using application interface when required.
· what should be the sql user for database access. Application documentation mentions about sa user. what privileges does this user has and is it Ok to use this one.