Solved

Installing SQL Server

Posted on 2013-06-01
3
192 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

766 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