Here is the sql that I ran (doctored up for company privacy)

DECLARE @BakDate as datetime

SET @bak1 = '\etworkserver\backup\bak\mydata\mydata.bak'

RESTORE DATABASE [MyData]

FROM

DISK = @bak1

WITH FILE = 1,...

Chuck,

That looks like an awesome script. I need to study it some more.

Thanks.

Tony

Awesome!!

That is what I needed to know. I have a script already.

Thanks.

Thanks everyone! I appreciate pointing me in the right direction!

Tony

Thanks Guys for the help.

I didn't realize how complex the query would be figuring upcoming birthdays.

I found this late night and used it. It worked great.

Thanks again.

SELECT

...

Problem solved.

Someone had turned off the maintenance plan and also turned off DTC. This produced a SQL Server log with no database backup and a log full of the...

I continually am so thankful for this forum.

You were right. I had one variable that was null. I went through each variable and found it. I corrected...

Yes, I agree. That is my normal troubleshooting.

I used print (@SQL) to make sure allthe variables get initialized. I can take the output of print (@SQL) and run...

I've tried both.

With the parentheses:

EXEC @sql

Msg 2812, Level 16, State 62, Line 127

Could not find stored procedure ''.

With the parenteses:

Command(s) completed successfully.

I would like the actual rows returned.

Thanks,

Tony

Thanks Steve. This looks like it will be an interesting project.

Thanks Steve for helping.

I guess, based on your answser, I am referring to documenting.

My boss said, "Put them all in the same format and load them in our version control...

Thank you for your advice!:-D

Finally was able to get the error message and post it:

Executing the query "BACKUP LOG [Kronos] TO DISK = N'\\\\myserver" failed with the following error: "BACKUP LOG cannot be...

Wow,

Now that is embarrassing. I said incremental?! This problem is truly driving me crazy. Sorry about that. My manager said, "Find out how to associate the...

Hello everyone,

Thanks for the great feedback.

I had a talk with my manager and he let me know that I have to implement some clever scripting. The politics with the...