you have Database Mail configured?

if yes,then might be automatic cleanup proccess going for DB Mail is going on

run dbcc inputbuffer (spid)

http://www.sqlservercentral.com/Forums/Topic401784-562-3.aspx#bm1171799

@OP ,please do check Gail's post for managing log file

http://www.sqlservercentral.com/articles/Administration/64582/

and how does it will help to manage the log space ?

you are just adding trouble to existing issues

to get file create date

xp_cmdshell 'dir <your Datafile Path> /tc'

or

right click on data file at physical location and check create time

let the the Sql server do its work itself , if you are not worry about Space.

Resizing (Shrinking) database ,can create performance problem.

1)Are the hardware,memory configuration of the both the servers are same ?

2)do you have same copy of databases on each server.

may be more information needed

what is the the output of the

Use YourDb

sp_helpfile

ramyours2003 (12/3/2012)

---

i need to upgrade SQL 2005 to sql 2008 r2 where the db's are configured transactional replication .

can any one send the step by step approach who...

check your SQL server error logs

Thanks Gail.

thanks for clearing out 🙂

any other good link/eBook related to architecture other than MSDN ?

anthony.green (11/30/2012)

---

No as it has to be the row which overflows, not the page. The row is not overflowing as its 4100 bytes, for row overflow to occur the...

anthony.green (11/30/2012)

---

sanket kokane (11/30/2012)

---

ScottPletcher (11/29/2012)

---

Depends on how many bytes in table, and how long a row is.

A SQL page is 8K, with 8060 total bytes available for data. Each...

ScottPletcher (11/29/2012)

---

Depends on how many bytes in table, and how long a row is.

A SQL page is 8K, with 8060 total bytes available for data. Each row resides on...