Luis, Thank You!! 😀

I should explain myself a little better, I have 4 SQL jobs which do the following.

1. Check DB integrity and backup database on server.

2. Copy SQL BAK files...

I am not sure if I understood you correctly, I removed the DISTINCT clause and ran the script. When I ran the script like this I get 31 rows, which...

Unfortunately I can't use powershell, I am trying to set this up to run as a bat file. Would you know if it is possible to do this with...

Thanks that worked.

Hello Ajay,

The path is accessible, also when I run the following I do see all the files in the query results window.

exec xp_dirtree '\\Nas2\sqlbackups\SQL2012TEST\SQL2012TEST\ASBUILTS\FULL',1,1

However I am not clear on what...

Hello,

I tried to run the script with the following edits, however nothing happened.

--1) Specify existing backup path

SET @BasePath = '\Nas2\sqlbackups\SQL2012TEST\SQL2012TEST\ASBUILTS\FULL';

--2) Specify new backup path

SET @BasePath_Target = 'I:\SQLBackups';

--3) Specify no...

Thanks everyone!:-D

I just wanted to make sure.

Hi Shawn, there is no way to restore a record directly from the transaction log? That is too bad, I have a huge database and I do not have...

I am getting the following error when I try to run the usp_help_job_status stored procedure.

Msg 208, Level 16, State 1, Procedure usp_help_job_status, Line 17

Invalid object name 'mondb.dbo.job_status'.

What am I...