That has to be an application message. SQL Server doesn't notify you of a lock. It just tries to wait until a timeout elapses, or the lock clears.

Applications sometimes raise...

If you want to do a maintenance task, I'd check integrity first (if you have time), then backup, then maintenance cleanup, then history cleanup.

If you can't do integrity every night,...

Downgrade rights are here: http://www.microsoft.com/sqlserver/2008/en/us/licensing-faq.aspx

If you have a new question, please start your own thread rather than piggy backing.

The installation steps for the cluster are on the Windows and SQL Server sites at Microsoft.

http://technet.microsoft.com/en-us/library/aa996568.aspx

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=490420

Blandry has a great point. You definitely should be aware of retention of data that's needed, especially for legal reasons. That's one reason I'd like a backup of any items...

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...