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.

The stored procedure msdb.dbo.sp_start_job, starts the job and then returns.  If it returns 0, then the job was successfully started, else it failed to start.  If you want to know...

I have an idea how to do this, but I need a little more information.  What do your product values look like, and how do they increment?

Start here:

http://www.microsoft.com/sql/howtobuy/default.mspx

You can achieve HA using clustering or mirroring.  It is possible to use both, I guess, if you weren't planning on shifting the databases between clustered servers.  I think I...

Personally, I would think that you'd want to do the partitioning first.  I think it will involve more work to accomplish successfully, then do the HA project.  I would not...

Okay, but if things change, please keep me in mind.  I'd be more than happy to send you my resume.