Lynn Pettis (4/15/2013)

---

jasona.work (4/15/2013)

---

You want to use "With NoRecovery" not "With Standby."

Standby will roll back any uncommited transactions and put the DB in read-only. NoRecovery basically tells SQL Server...

You want to use "With NoRecovery" not "With Standby."

Standby will roll back any uncommited transactions and put the DB in read-only. NoRecovery basically tells SQL Server that there's more...

Webrunner, my home lab has been set up comparitively on the cheap, using VMs.

One Technet account (gives me both the OS and SQL) ~$350

One "home-brew" server (Xeon 55xx, 24GB RAM,...

Jack, I must apologize, as your answer was on the right track...

Turns out there's a few things I didn't know about the network here...

1. While *.domain.com is in the...

I hate Reporting Services in a locked down network...

That is all.

The security policies of the workplace don't allow users to add / remove entries from their Trusted Sites list. Also, the domain that the servers (both QA and prod...

Cool thanks!

I'll give it a go on Monday.

Jason

Won't that just create a new trace?

Or will it alter that setting for the existing trace?

Jason

You may still need to "re-associate" the SQL Login with the DB user.

I've found these two queries to do a bang-up job for finding and fixing orphaned users (and possibly...

Nope, IFI only affects the MDF / NDF, not the Transaction log.

A quote from Brad McGehee[/url]:

Instant file initialization only affects MDF and NDF files, not LDF files. In other words,...

Once again, thank you...

In the interests of paranioa, I ran log backups of the 6 biggest log files to disk on the server. Thanks to Enterprise Edition, the backups...

Everyone: Thank you for the ideas / suggestions

dan-572483 - Right now I'm not worrying about shrinking the files, that will come later. We're OK on disk space on...

Lynn Pettis (4/3/2013)

---

GilaMonster (4/3/2013)

---

jasona.work (4/3/2013)

---

So my worst-case solution to reduce the size of data in the TLogs is to do the following:

1. After-hours, switch all DBs from Full Recovery...

Depending on the time of day, either straight or filtered through ground-up and roasted Coffea...

You know, silly thing, but it'd be nice if you could specify credentials for a Windows Auth connection in SSMS...

I've got two logins, one for "normal" use which has no...