Actually, two questions, after looking closer at the procedure, are you sure it works?  Looks like the set and select for Result_Code are outside the procedure to me.

I have a question, why?

Create the indexes with the data in place.  It would take longer to reload the data to the tables if you created the indexes on empty tables, as it would...

I believe that SP2 was also released for Windows Server 2003 R2 Enterprise x64 Edition.  This is the version of the OS we are running for our Data Warehouse development...

Cursors are not bad, you just have to use them appropriately.

Check BOL, CAST AND CONVERT.  You will find the different format codes for converting dates to character strings there.

Okay, I guess I am getting confused.  If you are looking for a code with '12%', how can you get a code like 'AB12'?  Still need to know what is...

John, True.  Like I said, wrote it off the top of my head.  At least I was trying to get read of the space in the datetime stamp.  I don't...

But good questions.

David,

I'd be interested in learning more about this wrapper you use.  What, where, how much, are the basic questions, plus where can I learn more.

declare @backupfile nvarchar(2000)

set @backupfile = N'C:\TESTDB\TESTDB_db_' + replace(convert(nvarchar(50), getdate(), 120), ' ',':') + N'.BAK'

BACKUP DATABASE [TESTDB] TO DISK = @backupfile ...

I think.  Give it a try, I wrote this off...

Feels good when you figure something out on your own, doesn't it?  Now, if someone else has a similiar problem, you are in a position to help out.

Here is where you need to start, BOL.  Lookup the tables sysjobs and sysjobhistory.  After your stored procedure starts the job, it needs to loop while waiting for the job...

It could also depend on high large your database is expected to get.  Using filegroups can speed up backup processes by allowing you to backup only the filegroups where data...

The N in front of a string constant, like N'false', simply indicates that the string is converted into Unicode (nchar or nvarchar data types.