Could you expand on the benefit of this in relation to online indexing?

Thanks,

Mark

Would you be able to let me know what you did to fix this?

I have implemented log shipping and now they want me to add a new sql...

I thought you did post it, Steve. But, unfortunately I haven't had a chance to get back to it.

Thanks!

Ok, great. Thanks for the update, Steve.

Same here! I rushed out for some to-go lunch, only to get back 5min before start and see that it's over. Bummer!

Yes, thank you much!

Thank you all again for your assistance. I wanted to post a reply so other DBA's know what fixed this problem for me.

Looks like BJ was right on the...

Thank you both for your help.

I don't really need to remove the original primary data file, but rather reduce the unused space after moving the data into the two other...

It is showing the following, which most of the first one is empty space.

Data 105000

Log 8

Data2 20000

Data3 20000

I worked from home for seven years with no one in the house and was perfect for me to be most productive. I don't like to work from home...

I agree. I'm more comfortable with using jobs to create backups and then back those up to tape because it just makes my life easier.

I've never did any homework...

I was under the impression that CA BrightStor backed up live somehow.

Ah, got ya Steve. I understand.

Since we're on that subject...

Do you all think it's better to backup the actual data files, or do you prefer to create jobs to...

Yes I apologize for that, I jumped the gun a bit. After reading edogg's a bit more carefully I believe it pretty much works the same way as if...

Thanks All!!!

I see, so you can't do a backup on the cluster and access that backup from a remote server to restore it on that remote server; correct?

Rather, back up...