I know this is a bit off topic, but somehow relates..

Except for Gail's workshops every now and then, are there any other and more regular events in South Africa for...

1. create new job, with t-sql statement to back your DB's, schedule to run every 3 hours.

2....

Let me get this... You want the same DB...

Backup the original, and restore with a different name.

What does your error log show?

There...

Hi, read up on it first:

http://www.lazydba.com/sql/1__1624.html

http://sql-server-performance.com/Community/forums/p/4085/27763.aspx#27763

http://www.principiaprogramatica.com/?p=5

Basically, you are querying between 2 different instances, or 2 different SQL servers.

http://msdn.microsoft.com/en-us/library/ms345146(SQL.90).aspx

http://blogs.msdn.com/menzos/archive/2008/06/25/table-partitioning-in-sql-2008.aspx

http://sqlfool.com/2008/11/102/

http://msdn.microsoft.com/en-us/library/ms979196.aspx

http://www.sql-server-performance.com/

and the list can go on....

KB refers to Knowledge Base - http://www.microsoft.com/protect/computer/updates/bulletins/number.mspx

MSDE refers to Microsoft SQL Server Desktop Engine - http://en.wikipedia.org/wiki/MSDE

http://www.sqlservercentral.com/tags/Excel/Extract,+Transform,+Load+(ETL)/Integration+Services+(SSIS)/

http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1282913,00.html

http://msdn.microsoft.com/en-us/library/ms141026.aspx

Your question cannot be answered in one sentence..except one long sentence.

Read up on some of the above links..

Schedule Enabled?

Step in job enabled?

Job Enabled?

SQL Agent running?

Thank you.

Well, firstly, NO BRAINDUMPS - they wont help you. You dont learn anything from them.

I used BOL alot, realy, alot.

The Real MCTS 70-432 Exam Guide - that book is...

Microsoft decided to change this part in 2k8.

Right Click on your instance, and you'll find "Activity Monitor" in the list.

use the "Resource Waits" drop down (may I say tab?)

alternatively, just...

Taken from: http://technet.microsoft.com/en-us/library/cc966534.aspx

Best practises suggest you:

Consider configuration of TEMPDB database

Make sure to move TEMPDB to adequate storage and pre-size after installing SQL Server.

Performance may benefit if TEMPDB...

Remember - sheat sheets and quick fix info will only get you so far.

Rather invest in the books suggested, and familiarise yourself.

This will also make you more confident in your...