Have you tried IP address?

Thanks Gift Peddie, I am already...

Sudiendra (3/19/2009)

---

I cannot give point to point answer with my expertise. But here are few i know

Create a scheduled task using task scheduler and take backup of your sites...

Tony (3/19/2009)

---

Hi,

We have to reboot all of our sql servers once a month. It does help with tempdb size but give it more space initially.

I have a script...

Gila,

thank you so much for the article. I already have update statistics and create updates, I just added DBCC in maintenance plan wizard set to run for Sunday morning in...

Tony,

thanks for all the information. how often do you reboot your clusters? Does that help the tempdb (s) size?

Also, do you do Re-index for the databases and if so can...

all the pervious posts are great. Also, you simply use the script for export in steps of SSIS and schedule it to run on re-occurance.

hope that helps

Ellie

Can you tell me why you had issues with evault? You are the first one I came across on this board that have had evault experience. We currently have tape,...

With respect to previous post, backing up to local is INDEED preferred method and you would benefit more to backup to local nad then either make a copy of local...

Wonderful points, as usual THNAKS Gail! exactly to the point and useful

Ellie

Thanks both Jack and Gail.

Also, Jack, I hope this is the right place to post for this thread.

Thank you,

So we are OK with the flush even if auto close is set to false?

Thanks Gila

All the other scripts and commands seems good (single_user),

I have this command before restore command and it works:

ALTER DATABASE [Database_Name]

SET OFFLINE

WITH ROLLBACK IMMEDIATE

Hope That Helps

Thank you so much Lowell, do we call this procedure before restore command in another SSIS step or cna we just incorporate it in the same?

thanks a lot for the...

Thanks Gila, I DID IT! Now I remember you or someone else had already helped me with another script and had the set off command

Thanks:)