Ummmm. Ya. That's kind of a lot.

...and I've only been corrected by Gail 403...

Jack Corbett (6/13/2011)

---

I'll be traveling the rest of the week so probably won't be online much for a couple of weeks as I'll need to get internet service to my...

The system tables directly.

From Dave P. about the system tables, along with a free script:

http://blog.sqlauthority.com/2010/02/08/sql-server-find-the-size-of-database-file-find-the-size-of-log-file/

From Jeff...

There is no SQL server provided job to do this for you. You can easily make your own job to get the file sizes for the databases and log...

Going from 90% full to 1% full would have to be a huge growth, depending on the size of the log file.

More likely, the transaction log was backed up instead...

GilaMonster (6/9/2011)

---

Not really... They won't match if auto-created, but they're not unique to a server.

You can create the logins on the second server and specify the SID (there are scripts...

SVR (6/9/2011)

---

Hi,

Problem: Restore a db on dev and qa from prod db backup without wipingout permissions. But restored without noting the permissions. All the permissions got wipedout....

GilaMonster (6/9/2011)

---

SQLRNNR (6/9/2011)

---

Steve Jones - SSC Editor (6/9/2011)

---

Just an FYI, those of you that posted in the "real world financial problem", I whacked the thread. No replies or discussion seemed...

SQLRNNR (6/9/2011)

---

Brandie Tarvin (6/9/2011)

---

jcrawf02 (6/9/2011)

---

Jim Murphy (6/9/2011)

---

Congrats Gail! That's awesome.

The best part is that your posts are not useless point-getting restatements. Grrrr, I hate...

Congrats Gail! That's awesome.

The best part is that your posts are not useless point-getting restatements. Grrrr, I hate those. You post consistent quality.

Phew. I did it.

The good news is: I'm alive. The bad news: I'm alive. For every perspective on this thread.

1.1 miles down. Ran slow. Still had to walk...

GilaMonster (6/8/2011)

---

Jim Murphy (6/8/2011)

---

I'm not much of a runner. Uh, at all. But with all of this...

I'm not much of a runner. Uh, at all. But with all of this peer pressure, I'll...

GSquared (6/7/2011)

---

GilaMonster (6/7/2011)

---

Now I can look forward to working on fun, interesting, complex stuff (like automating an entire SQL environment from scratch, designing nasty-complex systems for forecasting) rather than producing...

Grant Fritchey (6/7/2011)

---

WayneS (6/6/2011)

---

Jim,

If I've read things right, you're going to the Summit? Do you know that Thursdays up there is "Kilt Day"? Grant started it... he can fill you...