Hi,

Yes it will look in the very first thing based on the heartbit signals then only it will take a decision to move the resources.

Regards

Raju

Hi,

We have DMV's available in SQL Server 2005 & 2008 for long running queries you can use the below :

SELECT DISTINCT TOP 10

t.TEXT QueryName,

s.execution_count AS ExecutionCount,

s.max_elapsed_time AS MaxElapsedTime,

ISNULL(s.total_elapsed_time /...

Hi,

What is your database size ? please check where is the delay ? publisher to distributer or dictributor to subscriper ? what kind of replication are you using ? if...

Hi,

In your publisher for any table is there any column having indentiy value ? if yes when you replicating the same have you marked that intentity column not for replication...

DELETE is a logged operation on a per row basis. This means

that the deletion of each row gets logged and physically deleted.

You can DELETE any row that will not...

Hi,

You can do this , better you can create your custom scripts for backup and restore instead of MS standard log shipping. this makes you job easier.Just backup the logs...

Hi,

You can do this , better you can create your custom scripts for backup and restore instead of MS standard log shipping. this makes you job easier.Just backup the logs...

Hi,

There are few things you have to decide before creating the database, if the log is not that much important for you then you can put your DB in simple...

Hi,

MSSQL & MySQL both are different, also Mysql is open source, so you cant restore directly, for dong this your work you have to create the new database in Mysql...