Mike,

Sorry, never have had occasion to work with a clustered SQL Server, so I'm not one who can help.

Vince

A quick note on that trailing comma. Instead of

select @col_list = @col_list + col + ', '

which leaves the trailing comma that must be taken off, you might...

Check the startup parameters for the SQL Server service, particularly the -m and -l parameters. See if they reference C: or D:. Change to D: if C: and...

Well, re-reading the script it tries to get the path of the executing batch file using this line:

set ScriptPath="%~dp0"

%0 is the full path of the currently executing batch file, and...

Thanks, Kevin Hards and t berry. Knowing I've helped you guys feels good.

Vince

Just to add another version - I used Jason's code and added a parm for number of days to add, plus or minus:

[font="Courier New"]

CREATE FUNCTION dbo.GetNextBusinessDay (@Date datetime,

...

I believe your stopping the other services manually is what made the difference. I should follow through by adding a check to stop all those services to the batch...

Jeff,

I believe the reference was to this article.

http://www.sqlservercentral.com/articles/Administering/moreintelligentbackupandrestore/2137/

Love your work by the way.

Vince

Clint,

Sorry, I haven't had time to convert it to SQL 2008. I've gotten "this close" to installing 2008 on a test box here, but other day-job priorities have...

Agreed this is a fascinating amount of quality work. I haven't had the time to review it, but I share the concerns of the author in moving DTS packages...

Sorry, much too long ago. I've not really worked much with SSIS since this post. But rereading my post seems like I provided detailed instructions. Have you...

I'd like to say you can run the script with no worries, but I can't. It usually works just fine, but if it doesn't work you might not be...

Did you mean for the first backslash to be doubled? Both your example and the error produced show a single leading backslash.

{UserDbs} will move through the user databases on...

I would suggest the following:

EXEC sp_ABRestoreDb '{UserDbs}', '\\remoteserver\backups\Databases\&\&_db_*'

& in the filename parameter is replaced by the current database name. You can use it as many times as you need...

Paul,

Backup History doesn't affect things at all, which sounds like what you want. I frequently use the routines to restore production to qa or development environments.

I'm not sure what...