Thanks.

Thanks.

If i set up the Trace flag, and leave it to running for a month , will be ok or it will fill up the size?

Thanks Gail.

Could you please guide me that how we can migrate replicated DB on another server as we are subscriber and we don't have access on publisher which host by...

option 1) I mean if I start to use TechNet for testing and then later upgrading license key to a production will work, right?

option 2) And I start to begin...

Thanks.

What about for no#2?

I have another question is that if I download from the technet for testing then if I have to upgrade it using production licensed key, can...

Ok, Then I will just leave the System DB on C and will change it to D drive for USer DBs when I will do the Migration/creation of new DB.

Thank...

Thanks Elliott once again.

I have already default instance and we called by ip or DEVDB then iinstalled sql 2005 and created another instance as named instance - STG so it's...

Thanks Elliott for quick response as i need to do it today.

1) When i install sql 2005 on same server, i can leave the default instalaltion, right?

2) We have only...

Thanks Gail once again.

I haven't tested yet. I haven't much used VM.

Thanks Gail.

I haven't tested but just from the various articles, it's conflicting that some of the people having concern about performance, as I know that scalability, restoring purpose it's very...

Thanks Gail.

We have one Replication DB which is big - 250 GB and others are smaller DB.

Replication runs every few minutes and few batch jobs we are running during day...

Hello,

Is it virtualization is good or stand alone server hardware is good?

Is it 8 core/CPU is enough?

Thanks and appreciate your response!

Thanks, I have downloaded the login script.

Thanks Alan.

Somehow we have every few minutes replication is running but sometimes it's locking and users have to wait and wait so sometimes we have to kill the session for...

We are migrating from Sql 2005 standard edition to Sql 2008 R2 enterprise edition.

From your experience, if you have any better tips, appreciate it.