for a starter this query should help u.

select * from sys.sysprocesses where blocked0

your case statement looks incorrect. can you post table structure, sample data and expected output pls.

This URL will help you in posting these.

http://www.sqlservercentral.com/articles/Best+Practices/61537

your two statements are contradicting each other. can u explain more on what you're doing?

also...

Full backups are sent directly to the tape and the tran log backups are taken on disk and then copied to tape with retention period of a week i guess.

otherwise...

log_reuse_wait_descr column states what is preventing log truncation. In your case, its Replication which means there is a unfinished replication. This may happen if you've restored this database from a...

mmartin (7/15/2009)

---

One benefit of instances is that when you create a linked server connection to a database in another instance (of the same machine) then data does not have to...

I think i should delete more of it....

vinuvt (7/15/2009)

---

Our requirement is

1.Any database changes that happens in server 1 databases must be replicated to Server 2 and vice-versa.

2.People from L1 connect to Server 1 only...

yeah, i did delete data keeping only 3 months.. seems it's improved but still not accetable.. there are around 10 user databases and tran log backups happens every 10 mins.....

use network share.

copy/paste.

Sourav Mukherjee (7/14/2009)

---

Hello

What is the table or command I need to type (and where) to check for the number of transactions and the transaction related details are waiting to be...

Am glad it worked 🙂

because you havent mentioned your...

--1. create the table

create table customer

(

[zip and city] varchar (50)

)

--2. insert sample data

insert into customer

select '60601 Chicago'

union

select '60602 Chicago'

union

select '10292 New York'

--3. parse and insert data to new table

select...

Thanks for the feedback 🙂