Same filegroup --> primary

doug.brown (6/11/2014)

---

It sounds like the password might have been changed for the user whose credentials are used for the data source. I would start by checking the data source...

eyespi20 (6/24/2014)

---

Here are three links to PowerShell scripts that do this work in various methods. A Google search of "powershell sql server inventory" brings up quite a few links. Do...

tripleAxe (6/19/2014)

---

Hi Anoop,

I've set something like this up a couple of times now. I've set up a Central Management Server on a SQL Server and used that to do...

Grant Fritchey (6/19/2014)

---

If you're going to set this up yourself, then I agree, Central Management Server is the way to go. There's plenty of documentation on that in the Books...

eyespi20 (6/19/2014)

---

There are some powershell scripts out there that can be used to do this kind of thing. They can be coded to produce very pretty excel spreadsheet type reports....

Grant Fritchey (6/18/2014)

---

There are a ton of mechanisms built...

GilaMonster (11/10/2013)

---

Possible, yes, but a really bad idea. Failover would work, providing you have no Enterprise-only features but you wouldn't be able to fail back.

DR should be the same version,...

Perry Whittle (11/6/2013)

---

A port in the high end range is usually good, say 50000 - 60000.

Where firewalls are in place and you wish to connect via the instance name you'll...

dwilander (10/22/2013)

---

Are you talking about application access to a database, an agent job, or ??? We generally create windows service accounts for both unless an application vendor has a...

Grant Fritchey (10/7/2013)

---

What Gail said.

But, if you really want to avoid adding too much additional overhead to the system, then instead of a trace, I'd look at extended events. They're...

Grant Fritchey (10/5/2013)

---

I would not suggest turning it off, no. You can add additional traces if you need them, but the default trace captures a basic set of information about...

I know its my report and client wants to know about total memory utilization by sql server.I...

Hi gila thanks for your reply

now i wanted to know whether i can...

GilaMonster (9/26/2013)

---

Where ever you choose to put the log backups that you take. Mirroring doesn't use log backups, so where they go is...