when you setup the central management server you can create a group and register instances. You may then execute a t-sql script against the group affecting all the registered instances

What is the app called

you can detach by all means.

EdVassie (1/3/2014)

---

running two simultaneously to the same physical disk may take 3 hours for them to complete, and running 3 simultaneously may take 6 hours to complete. If I...

the only time i would be shaky would be a major platform change, for instance in place upgrade from Windows 2003 Std to Windows 2008 R2 Std, etc

Try this

SELECTc.TABLE_SCHEMA

, c.TABLE_NAME

, c.COLUMN_NAME

FROM INFORMATION_SCHEMA.COLUMNS c

LEFT OUTER JOIN INFORMATION_SCHEMA.COLUMNS cd

ON c.TABLE_SCHEMA =...

sounds like you're hitting this from an Oracle terminology point, theyre different entirely.

Each instance will default to...

similar to HP Polyserve then by the sound of it.

Ginga (12/31/2013)

---

Hi,

We have a server that needs more memory but we've hit the 32GB limit imposed by Windows Server 2008 R2 Standard. We plan to perform an in place...

WebTechie38 (1/2/2014)

---

Hello,

I am trying to document the environment I am working at.

I want to document our clustered servers.

1) Server Name

2) Virtual Server Name

3) Primary node name

4) ...

So you're replicating the database storage drives at the storage level, no HA on the Windows or SQL level, correct?

For more on moving database files in SQL Server see my guide at this link[/url], now to the issue at hand

ramana3327 (1/2/2014)

---

I tried the following code

use test_copy

alter database test_copy

MODIFY FILE...

JimS-Indy (1/2/2014)

---

What I was looking for was "standard" practice. If you set up a SS in an AD environment, and SQL Server Agent will need to access a network share,...

niver (1/2/2014)

---

yes it is a FC connection, but what im looking for is an implementation that all the sysdatabases and production databases is located to the SAN and what is...

darklight_arizona (1/2/2014)

---

Thanks Perry Whittle

You mean to say we put all the system databases (like master, msdb, temdb etc)

on a shared disk and these databases are common to both the nodes.

Active...