Ask the vendor to write up in detail exactly how they would do a database recovery to a specific point in time to a new database without disturbing the old...

We run *almost* everything off of an Enterprise SAN, and we still do SQL backups.

Since this is an ASP/hosted deal I would make SURE that if you can't get SQL...

Something I haven't seen anyone discuss is do you need to put each of these on a separate drive or do you still get the performance increase if you keep...

My first question is why are you wanting to shrink the database?

The second question is can you provide the commands you are using to try and shrink the database?

Fraggle

That is an awfully general question. Which one is better completely depends upon what you are trying to accomplish, distance between the servers, data being transfered, and numerous other...

Interesting SilverFox. I have never heard that. What is the purpose of that? What type of performance improvements do you see when you do that? Are...

Without looking, I believe you will have to use the Convert Task, and then use the built in function to pull year() and Month() from the date column.

Fraggle.

It completely depends upon your system and how much information is being passed through the tempdb. Generally I would say you are ok with them on the same drive.

As...

First,

Not sure how your question is in anyway related to backups or replication.

In answer to your question, here are two links. One is a video and one...

No worries Jeff.

Fraggle

I am very interested as well to see the difference Jeff.

Fraggle

:ermm: Sigh.We can argue all day. Fact is fact. At a minimum, you only need 33,000 people in one strait line to break the recursion. Yes, that...

My company deals with network marketing/direct sales/mulitlevel marking companies on an international level. These are true hierarchies that extend well beyond 100 levels in many cases depending upon the...

1) So Sad

2) I am very interested in this. Do you have any reference or example that you would be willing to show as an example?

3) In general, it...

I believe that the question that everyone who is reading this post is asking themselve right now is