ya .i have checked in alllogs and i have seen sp_readerrorlog info.there is no failure mesages.

through jobs ....

through jobs.job have alerts

tlogbackup-everyday except sunday

full backup-sunday

select name,recovery_model_desc,log_reuse_wait_dec from sysdatabases

log_reuse_wait_dec gives the status of perticular log:ACTIVE_transaction,logback_up,nothing ...etc

which database u have to find the status of logback_up immediately u take the log backup.

then u go for shrink...

In replication we dont have a automatic failover.we have automatic failover in mirroring and clustering.

Clustering nedds more inputs and budjet will be more.so you can choose mirroring.

Dmvs are introduced in sql server 2005

backup and restore is always best approach.

can u please provide solution. i dont know where i have to provide the solution.

Hi,

First manuvally copy the transaction logs from primary server to secondary server.and apply the transactions logs using restore commands.......

now u can check it ......

Hi ,

I dont have experience in this.

But in business inteligence tool direly one option is there na .....

Go to that perticular packages:right click

...

Hi J,

First its depends upon your type of applications like banking,telecom etc

for banking,telecom replication is better one.

Only reporting purpose Just u have to take a snapshot of perticular...

Hi

using sql profiler to run the trace for select database.trace file is look like a text file.so u can see it.

with these trace files u have to find the...

Hi

Upgradation will do in two ways:IN_PLACE,Side-by-Side.choose any one.but side-by-side is beter one.this case two editions are working fine.

steps:

-> take the backup of all databases,logins,users

->install...

Hi

In this case First u run this command

select spid,blocked from sysprocesses where blocked>o

it will give the information of which ids r cause of this blocking.

after that use this...