I've emailed with Gail a little. She's busy with life, should be back soon.

Pradeep is correct. EVERY log backup needs to go to the secondary to be restored. If you keep the maintenance plan, you'll have to manually ensure those backups get moved...

No worries. If you're subscribed, the test is working 🙂

Henrico,

With that budget I'd suggest getting books and asking for an hour every other day to study. Then ask questions as you go. It's slower, but sometimes you trade time...

If you're in the UK, don't forget about SQL Bits (www.sqlbits.com) in Nov as well.

bpportman (9/17/2009)

---

We just had a major release and I renamed all the old objects with old_. It felt sooooo good. If no errors in a month, they'll...

Question reworded to better match the T/F answer

What do you mean by it's out of sync? Is there an error? Or is there something you notice?

You should run log backups to new files each time, without any...

The first part of the example would be placed in a text file. That's why the second part has the file name as "c:ameandpathofabovescript"

You create a text file that has...

Ronzo has the type fo example that I would have given you. You can look up SQLCMD in Books Online and see examples.

t-SQL works inside the server. It's not built...

you are welcome and good luck. Let us know if something changes. If you think it's something different, start a new thread and we'll try to help.

I think the guy doing the work can get a variety of rates.

I'd expect short term rates to be in the $75-150/hr range, depending on experience. Longer term rates would...

The free space should diminish, and Lynn has a good explanation.

I'd leave the 13GB and watch it. I wouldn't expect you'd have the file sizes grow in the short term.

An object can only be on one filegroup, so depending on what is where, it could be causing growth there. Also, maintenance operations, like index rebuilds, can require tremendous space,...

It could be blocking. That would explain the "not much happening"