It might take some time. In any event you will need to come to US first. I doubt that someone would hire a person without seeing him first.

I know a...

Do you have a job offer or you are waiting for a job offer?

Are you using snapshot isolation level?

Back to the original question by OP. We used to experience similar issue a while ago when the jobs were simply skipped. No failures. That happened when the service account...

You may also try to run a query with a huge IN clause....

Maybe you can create a 'flag' table in your prod database and insert some meaningful values, like daystamp for example, say, every 15 minutes in it thru the job.

And then...

Try incremental updates

DECLARE @SomeString VARCHAR(20)

SET @SomeString = 'ServerName\Instance'

If (SELECT LEN(@SomeString) - LEN(REPLACE( @SomeString,'\','')))>0

SELECT LEFT(@SomeString,CHARINDEX('\',@SomeString)-1), right(@SomeString, len(@SomeString) - charindex('\', @SomeString));

ELSE

SELECT @SomeString

I don't know if it is on your plate, but working for a small company is quite different from working for a Large Corporation. About 10 years ago, when I...

It happned to me once in a while when there are lot of other activity ( including other multiple backups and\or restores) on a server. Did it finally restored?

Can you do BCP, where you can save time and space?

Each system is build differenly, expecially when it comes to SSAS. We also got rid of VM for SSAS. So you might want to check how systems for your cubes...

Thank you guys,

I am using that purely for the Admin support, when 'unknown' number of jobs of a certain type are running during maint window.

Those jobs were created...

Just curious. You are doing backup(s) to a ceratin location(s)?

Can't you just get the latest backup from this location(s) and restore it?

In Financial industry I typically work 12 hours Mon-Fri, plus Wknds when you are on-call, so wknd can easily add another 10 hours...