SQLAgentMail: installation

Showing posts with label installation. Show all posts

Wednesday, March 28, 2012

Question regarding Instance

If I do a default SQL Server installation, and then find that I'd like to
have several instances installed after all, will I be stuck?
Thanks,
- Joe Geretz -
Hi,
When ever you do a new SQL server Installation after a default installation,
The Installation program will identify the old instance
and will create a NEW NAMED INSTANCE automatically.
All the subsequent installation after the default installation the server
name will be "MACHINENAME\<NAME YOU GIVE>"
So no worry, you will never get struck.
Thanks
Hari
MCDBA
"Joseph Geretz" <jgeretz@.nospam.com> wrote in message
news:#lMllL4FEHA.1396@.TK2MSFTNGP11.phx.gbl...
> If I do a default SQL Server installation, and then find that I'd like to
> have several instances installed after all, will I be stuck?
> Thanks,
> - Joe Geretz -
>

Question regarding Instance

If I do a default SQL Server installation, and then find that I'd like to
have several instances installed after all, will I be stuck?
Thanks,
- Joe Geretz -Hi,
When ever you do a new SQL server Installation after a default installation,
The Installation program will identify the old instance
and will create a NEW NAMED INSTANCE automatically.
All the subsequent installation after the default installation the server
name will be "MACHINENAME\<NAME YOU GIVE>"
So no worry, you will never get struck.
Thanks
Hari
MCDBA
"Joseph Geretz" <jgeretz@.nospam.com> wrote in message
news:#lMllL4FEHA.1396@.TK2MSFTNGP11.phx.gbl...
> If I do a default SQL Server installation, and then find that I'd like to
> have several instances installed after all, will I be stuck?
> Thanks,
> - Joe Geretz -
>

Wednesday, March 21, 2012

Question on SQL Server 2000 installation

I am trying to install on SQL Server 2000 on Windows server 2003, web
edition. When I click on autorun, then choose server tools and components and
choose Install Server, nothing happens.
I was wondering if it possible to install SQL Server 2000 on Windows Server
2003 web edition. Is this a compatibility issue'
Thank you.
VamsheeWindows Server 2003 Web Server Edition will not allow you to install SQL
Server 2000. It is not a licensed configuration.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Vamshee" <Vamshee@.discussions.microsoft.com> wrote in message
news:56A57D60-720F-4512-AA27-53045E73DD7C@.microsoft.com...
> I am trying to install on SQL Server 2000 on Windows server 2003, web
> edition. When I click on autorun, then choose server tools and components
and
> choose Install Server, nothing happens.
> I was wondering if it possible to install SQL Server 2000 on Windows
Server
> 2003 web edition. Is this a compatibility issue'
> Thank you.
> Vamshee|||Hi,
Organizations cannot use Windows Server 2003, Web Edition, to deploy
Microsoft SQL Server.
See the below link (Limitations paragraph):-
http://www.microsoft.com/windowsserver2003/evaluation/overview/web.mspx
Thanks
Hari
SQL Server MVP
"Geoff N. Hiten" wrote:
> Windows Server 2003 Web Server Edition will not allow you to install SQL
> Server 2000. It is not a licensed configuration.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Vamshee" <Vamshee@.discussions.microsoft.com> wrote in message
> news:56A57D60-720F-4512-AA27-53045E73DD7C@.microsoft.com...
> > I am trying to install on SQL Server 2000 on Windows server 2003, web
> > edition. When I click on autorun, then choose server tools and components
> and
> > choose Install Server, nothing happens.
> >
> > I was wondering if it possible to install SQL Server 2000 on Windows
> Server
> > 2003 web edition. Is this a compatibility issue'
> >
> > Thank you.
> > Vamshee
>
>|||Thanks for the information.
"Hari Prasad" wrote:
> Hi,
> Organizations cannot use Windows Server 2003, Web Edition, to deploy
> Microsoft SQL Server.
> See the below link (Limitations paragraph):-
> http://www.microsoft.com/windowsserver2003/evaluation/overview/web.mspx
> Thanks
> Hari
> SQL Server MVP
>
> "Geoff N. Hiten" wrote:
> > Windows Server 2003 Web Server Edition will not allow you to install SQL
> > Server 2000. It is not a licensed configuration.
> >
> > --
> > Geoff N. Hiten
> > Microsoft SQL Server MVP
> > Senior Database Administrator
> > Careerbuilder.com
> >
> > I support the Professional Association for SQL Server
> > www.sqlpass.org
> >
> > "Vamshee" <Vamshee@.discussions.microsoft.com> wrote in message
> > news:56A57D60-720F-4512-AA27-53045E73DD7C@.microsoft.com...
> > > I am trying to install on SQL Server 2000 on Windows server 2003, web
> > > edition. When I click on autorun, then choose server tools and components
> > and
> > > choose Install Server, nothing happens.
> > >
> > > I was wondering if it possible to install SQL Server 2000 on Windows
> > Server
> > > 2003 web edition. Is this a compatibility issue'
> > >
> > > Thank you.
> > > Vamshee
> >
> >
> >sql

Question on SQL Server 2000 - 2005

I am a DB2 DBA that has been asked to become familiar enough with SQL
Server in order to become actively involved in its installation,
implementation, and to review database backup/recovery procedures. SQL
Server will be used by a vendor packaged application.

The problem is that we are awaiting word on whether it will be SQL
Server 2000 or 2005 we will be working with. I have been told that
there are considerable differences between the two versions.

There is an upcoming local 5 day class on Administering SQL Server 2000
that I would like to take. (outline below)

Question is, are the differences between the two versions so drastic as
to render this class less than useful, especially in terms of
installation and basic db maintenance functions?

Many thanks in advance.
Gerry

Course Outline: 2072 Administering a Microsoft SQL Server 2000 Database

Lesson 1: SQL Server Overview

What Is SQL Server
SQL Server Integration
SQL Server Databases
SQL Server Security
Working with SQL Server

Top

Lesson 2: Planning to Install SQL Server

Hardware Installation Considerations
SQL Server 2000 Editions
Software Installation Considerations
Methods of Installing SQL Server
Verifying the Installation
Configuring SQL Server Enterprise Manager
Troubleshooting

Lesson 3: Managing Database Files

Introduction to Data Structures
Creating Databases
Managing Databases
Placing Database Files and Logs
Optimizing the Database Using Hardware-based RAID
Optimizing the Database Using Filegroups
Optimizing the Database Using Filegroups with Hardware-based
RAID
Capacity Planning
Performance Considerations

Lesson 4: Managing Security

Implementing an Authentication Mode
Assigning Logins to Users and Roles
Assigning Permissions to Users and Roles
Managing Security Within SQL Server
Managing Application Security
Managing SQL Server Security in the Enterprise

Lesson 5: Performing Administrative Tasks

Configuration Tasks
Routine SQL Server Administrative Tasks
Automating Routine Maintenance Tasks
Creating Alerts
Troubleshooting SQL Server Automation
Automating Multiserver Jobs

Top

Lesson 6: Backing Up Databases

Preventing Data Loss
Setting and Changing a Database Recovery Model
SQL Server Backup
When to Back Up Databases
Performing Backups
Types of Backup Methods
Planning a Backup Strategy
Performance Considerations

Lesson 7: Restoring Databases

SQL Server Recovery Process
Preparing to Restore a Database
Restoring Backups
Restoring Databases from Different Backup Types
Restoring Damaged System Databases

Lesson 8: Monitoring SQL Server for Performance

Why to Monitor SQL Server
Performance Monitoring and Tuning
Tools for Monitoring SQL Server
Common Monitoring and Tuning Tasks

Lesson 9: Transferring Data

Introduction to Transferring Data
Tools for Importing and Exporting Data in SQL Server
Introduction to DTS
Transforming Data with DTS

Top

Lesson 10: Maintaining High Availability

Introduction to Availability
Increasing Availability Using Failover Clustering
Standby Servers and Log Shipping

Lesson 11: Introducing Replication

Introduction to Distributed Data
Introduction to SQL Server Replication
SQL Server Replication Agents
SQL Server Replication Types
Physical Replication ModelsIn my humble opinion you better get training on SQL 2005. But knowledge
of SQL 2000 will add on to SQL 2005|||(datapro01@.yahoo.com) writes:
> Question is, are the differences between the two versions so drastic as
> to render this class less than useful, especially in terms of
> installation and basic db maintenance functions?

Everything that works in SQL 2000 works in SQL 2005, at least almost. But
SQL 2005 may offer new and better ways that what you learn on the SQL 2000
class.

The one area where the SQL 2000 class may be more confusing than helpful
if you settle on SQL 2005, is installation. The setup program is different,
there are different configuration issues etc.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Thanks for the replies and the info. New Horizons is telling me that
the training materials for 2005 have not yet been released. At least to
them.

I will certainly do my best to understand the installation differences
between the versions.

Question on SQL Installation

Hello,

Is it possible to install "SQL 2000 Server 1CPU" on a dual processor machine
and make SQL use only one CPU?

ThanxYes, regardless...

But - what version are you talking about?

a.. SQL Server 2000 Enterprise Edition (64-bit)
a.. SQL Server 2000 Enterprise Edition
a.. SQL Server 2000 Standard Edition
a.. SQL Server 2000 Developer Edition
a.. SQL Server 2000 Personal Edition
a.. SQL Server 2000 Desktop Engine (MSDE)
a.. SQL Server 2000 Windows CE Edition (SQL Server CE)

--
Jerry Boone
Analytical Technologies, Inc.
http://www.antech.biz
Secure Hosting and Development Solutions for ASP, ASP.NET, SQL Server, and
Access

"Chicken'n Toast" <chicken@.n.toast> wrote in message
news:btf0iu$sml$1@.dns3.cae.ca...
> Hello,
> Is it possible to install "SQL 2000 Server 1CPU" on a dual processor
machine
> and make SQL use only one CPU?
> Thanx|||"Chicken'n Toast" <chicken@.n.toast> wrote in message
news:btf0iu$sml$1@.dns3.cae.ca...
> Hello,
> Is it possible to install "SQL 2000 Server 1CPU" on a dual processor
machine
> and make SQL use only one CPU?

Yes. Look at affinity mask.

Note however this does NOT allow you to purchase just one CPU license if you
go that route for licensing.

> Thanx

Wednesday, March 28, 2012

Question regarding Instance

Question regarding Instance

Wednesday, March 21, 2012

Question on SQL Server 2000 installation

Question on SQL Server 2000 installation

Question on SQL Server 2000 installation

Question on SQL Server 2000 - 2005

Question on SQL Installation

SQLAgentMail

Blog Archive

About Me