Solved

Installing SQL Server

Posted on 2013-06-01
3
191 Views
Last Modified: 2016-02-18
Just a general question.

What are some considerations when installing SQL Server Enterprise 2008, if any?

(i know this is generic but just seeing if there are any tips or suggestions)

This is on a development box and would like to include SSRS and SSAS.
0
Comment
Question by:patriotpacer
3 Comments
 
LVL 22

Accepted Solution

by:
Haresh Nikumbh earned 200 total points
ID: 39213189
First of you need to check hardware and software requirement that can be verify from below link

http://technet.microsoft.com/en-us/library/ms143506%28v=sql.100%29.aspx

During installation Change default database path to other drive ( do not keep database files on Root (OS volume)

Database backup :- again that need to keep separate drive or network location
0
 
LVL 23

Assisted Solution

by:Racim BOUDJAKDJI
Racim BOUDJAKDJI earned 100 total points
ID: 39213269
Please make sure you have sufficient RAM and CPU to host all services.  Also make sure your IO subsystem can cope with all the services.
0
 
LVL 3

Assisted Solution

by:expert_dharam
expert_dharam earned 200 total points
ID: 39213557
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question