I'd agree with the whole "not moving your db's to the san" thing. The SAN is a real high performer, the NAS is not, especially when you start to factor...

Try this...

select ubirthdate from contact2

where dateadd(year, 16, ubirthdate)

 between convert(varchar(12), getdate()) and convert(varchar(12), dateadd(day, 7, getdate()))

You're trying to get the birthdates off all people who are 16 and who's birthdays are in the next week?

Can you provide a schema and data example?

If you're having trouble with the restore you could always do the db backup/copy/restore through the maintenance plan gui.

The other thing that can screw up logshipping is having more than...

Jeff,

given that the packages are stored within MSDB, preventing MSDB access will also prevent package access.

Are you using MS logshipping or a homegrown version?

The script you posted indicated that you were using a remote share to place the standby file, that's what had me confused. I didn't realise that share was on the...

I would always keep the undo file on the same server as you are restoring the database to. Not doing so could prevent you from recovering correctly when you really...

My guess would be a timeout or permissions issue related to the remote share (are you connecting using the same information for both restores?)

Is there a server related issue that makes you want to store that remotely?

I can't see the figure.

Let's just say though that you have step A and B and you want to add failures...

A --success--> B

|                     |

failure        failure      

|                     |

C                Copy of C

Don't have

A...

You didn't mention that you wanted the database in standby mode, so I thought you were adding options that you didn't need.

Are you actually creating the undo file on a...

Why are you attempting to create a standby file, especially on a remote server?

That's the dream of all DBA's everywhere....