Not sure if this thread is still going but I find myself in a similar situation.

Server maxdop = 0, It's a small 8 core box with 16gb ram

I've got a...

Hi

This is quite tricky. Here is some reasons why.

Assume the setup, Server Pub (publisher), sub (subscriber) and dist (remote distribution) and DR Dist for the DR distribution

If you backup your...

I think I just answered my own question but it would be helpful if someone could verify.

It would appear that the waiting I'm seeing is for SQL to return the...

Hi

You can do a shrinkfile with emptyfile.

It will move the data in your file two the other two files and mark it as read only.

Depending on your kit it will...

In Win 2008 you can check the counter databases and maybe monitor the last active trans.

However you might need to do some exceptions for dormant db's

Or shoot off a powershell...

Hi

If you replicate a view replication is automatically going to add the underlying dependant objects.

So in terms of volumne there is no difference.

If you want to publish specific columns you...

Hi

What you can do is use perfmon (or your powershell) to get data.

15 seconds interval is a bit much, most of the counters can fluctuate, so you don't want a...

yes, you have to check the box though.

Hi

What version of SQL are you running?

http://www.sqlskills.com/BLOGS/PAUL/category/LOB-data.aspx

Cheers

Jannie

Hi

I actually had to some of this today.

The restore didn't work due to above mentioned schema changes.

You can do the in place upgrade and the backup \ restore.

For now, edit...

Hi Krishna

Someone won't be able to write a query for you as your system is most likely unique.

But what you can do is goto query analyzer, type backup, highlight it...

Hi

Your question is much like asking to summarize this entire forum into a few lines limited to that of a post.

However, a good start is understanding a query plan. Since...

Hi

In summary

1 -telnet from SQL host node(1) to VIP

2- telnet from SQL host to cluster name

3-check for host entries etc.

4-telnet from DMZ client to SQL (1433) .

You saying 4...

Hi

Given the price / GB . I think it's better to keep it local.

You are not going to use local space for much else.

I haven't run into specific performance problems...

Hi

It also depends on the recovery model of your databases when the log will get truncated.Lol @ name

Cheers

Jannie