smitty-1088185 (1/3/2012)

---

I have a database in recovery mode that was part of a mirroring test. I dropped the mirror on the principal and deleted the mirroring endpoints.

The db still...

Hmm, this doesnt really address the issue I was asking about- indefinite retention and the pitfalls of such. I have...

Typically, in a configuration like the one you describe, one would use a single login to authenticate from web to database server. If you require the ability to distinguish...

Phil Melling (12/20/2011)

---

Really good article Warren!

I, like you, have recently discovered the joys of Powershell and how it can make the life of a DBA easier by automating daily checks....

Thanks for that jberg. Not sure how...

VanishingW (12/20/2011)

---

I am getting these same errors. I have tried to resolve the problems without success. If anyone has a solution, let me know. Thanks. I am using Windows 2008...

When i created the script initially, i had hardcoded msdb. When i thought about publication, i figured you might choose differently, so went back, created the db variable, and...

kunalpiyush (12/20/2011)

---

Hi

I see that the script is using invoke-sqlcmd/sqlcmd to output results to a txt file. I am inquisitive to know as to why we can't save the results in...

My pleasure sir.

NJ-DBA (12/19/2011)

---

richard.bothma (12/19/2011)

---

Hi,

I am also struggling with the same issue that was mentioned above, when I try execute the powershell script, on the line:

"Backup Status" -Head $a -Body "<H2> ERRORSLIST...

richard.bothma (12/19/2011)

---

Hi,

I am also struggling with the same issue that was mentioned above, when I try execute the powershell script, on the line:

"Backup Status" -Head $a -Body "<H2> ERRORSLIST </H2>"|out-file...

NJ-DBA (12/16/2011)

---

okbangas (12/16/2011)

---

If I understand your scenario right. First of all, have you checked the link I posted? Secondy, SQL Server does not know what files or filegroups were in...

okbangas (12/16/2011)

---

If I understand your scenario right. First of all, have you checked the link I posted? Secondy, SQL Server does not know what files or filegroups were in the...

NJ-DBA (12/16/2011)

---

NJ-DBA (12/16/2011)

---

Let's say for example, I have a staging database which I intend to refresh from a production backup. In this staging database, I have recently made some...

NJ-DBA (12/16/2011)

---

Let's say for example, I have a staging database which I intend to refresh from a production backup. In this staging database, I have recently made some modifications...