TechNet Magazine does this now with Paul Randal

New code formatting engine: http://www.sqlservercentral.com/Forums/Topic794401-83-1.aspx

You are welcome. I'm in the opposite mode. Leaving for a couple days holiday in hours!

You don't move system dbs. The logins/jobs/etc scripts will move the data as do the restores.

Jobs - I believe you script these and run the script. If they don't work,...

I wasn't really trying to offend, but offer my opinion. I've seen so many of the Gen Y, younger generation that tend to act the way I described it. It's...

You have missed something. The backup contains all tables and I have never seen or heard of a table being missing. If it happens consistently, you are missing something with...

The job status is in msdb, as mentioned above. If you have rights to read those tables, then you can query for status.

You would not start a job, or get...

The cause of this problem is people with nothing better to do than deface others' property.

It's a SQL Injection issue. You need to make sure you are not allowing SQL...

What are the errors?

A few things to check:

- Are the files written correctly to the different folders? Meaning they look like the correct log backups from the source systems

-...

Most software, or services, cost some decent $$. If you can get by with less features, OSTRESS (http://support.microsoft.com/kb/887057) might owrk for you.

In T-SQL, you'd have to import the data into a table.

In SSIS, there might be a way, but you'd have to read the text file and check each row for...

Naming conflict somewhere? maybe with the job names? I assume the dbs are differently named?

I'll add in, what is the amount of data you can lose? Or can deal with a loss? how quickly do you need to recover?

I use diffs to keep daily,...

I'd agree that you want to do it in both places. However, I'd load the validation domains, list of choices, from the db into the middle layer. Find a way...

Usually you do not want to do things in a looping manner in SQL Server. The db engine is optimized to do things with sets of data.

If you don't know...