TechOnTip Weblog

Run book for Technocrats

Archive for the ‘Database’ Category

Install SQL 2008 on a Windows 2008 Server from Commad Line & Answer File

Posted by Brajesh Panda on January 6, 2010

I have two methods for you;

  1. Silent Installation from Command Prompt
  • Using command syntaxes
  • Using Answer File

2.         GUI Based Installation

 I will be covering small step to uninstall process using command line at the end of the post. Don’t forget to install SQL Server 2008 SP1 after you install the RTM.

 1st time I have followed GUI Method but found little time consuming. Hence built my small script to do the same from command line. MSDN website has a fantastic page regarding “How to: Install SQL Server 2008 from Command Prompt” . Take your time & do your research on all parameters from that page.

 Let me give you post about Command line Installation of SQL Server

 Install SQL Server 2008 on a Windows 2008 Server Using Command Line Syntaxes
Read the rest of this entry »

Posted in Database, SQL 2008 | Tagged: , , , | 5 Comments »

Rename SQL Server 2008 – Single Server Senario

Posted by Brajesh Panda on January 5, 2010

Have you ever changed SQL server name? I frequently do the same in my LAB because I use “Sysprep” OS image for my lab deployment. Read my other posting to know about how to Sysprep Windows 2008 R2 Server?

SQL Infrastructure architecture can be created in multiple ways;

– All SQL Roles are running on the same single server

– SQL Roles are in different servers i.e. Database Services, Reporting Services etc are running on different servers

– Clustered SQL Instances

There are numbers of articles are available over internet. However I will recommend to visit Microsoft TechNet to find the official supported article; Over here I am going to state some simple steps for the 1st scenario. So I have to deal with SQL Database Server renaming & Re-configuration of Report Server; Over here I am using SQL 2008 with SP1.

Let’s start operation “RE-BIRTH” of my SQL Instance. Open SQL Query Manager & do some trick to rename our SQL DB Instance;
Read the rest of this entry »

Posted in Database, SQL 2008 | Tagged: , , , | 5 Comments »

 
%d bloggers like this: