Thank you. Sorry I did not answer before, but this colocation is driving me nuts! I spent the last two days there.

Yes I can use net use and map the...

Thanks Steve. We are doing it by IP.

Thank you.

The co-location servers are at a different location miles aay from the main office.

I can ping those servers without any problem.

I did send files from my main office...

Thanks Andy. I think that is the one.

Thanks again, I will work on that.

Thank you for reading this posting. I did figure it out. A good night sleep makes wonders, don't you think? The server where I have this grayout option was using...

Thank you for the info. I read about the sharing folder and play with it a little for the test. I will keep in mind the timing for the maintenace...

Thank you. I will see how can I get some space for this task. Thanks again

Swen,

I happened to have an issue with Veritas this week. Veritas does not like to restore to a different server. Software limitations? Maybe.

I spoke with Veritas and they gave...

Good to know. It sounds like a plan. Do you use any script to get rid of the disk backups after they are bakedup to tape? I have quite a...

Yes david, that's exactly what I did. I also used sp_helpdb to check that the db was in the the db catalog. It shows as a valid db. Veritas is...

David,

Yes Veritas. It shows restore successful 100%. I tried to detach and reattach but it did not work. It came back with

"db cannot be detach while there is an...

Use gatdate() instead. There is plenty of samples in books-on-line. but just in case here is one:

SELECT Getdate()

GO

Returns today's date and time

If the question is regarding a specific date field,...

Help again with this shirnk store proc. Please!!

I fixed the syntax and the store proc was created fine. I did not have the change to run it until today. When...

Thank you guys. As always great help. I figured out thta I had USE MASTER also in the wrong place and that was giving me another error. I corrected both...