Viewing 15 posts - 31 through 45 (of 149 total)
you have Database Mail configured?
if yes,then might be automatic cleanup proccess going for DB Mail is going on
run dbcc inputbuffer (spid)
-----------------------------------------------------------------------------
संकेत कोकणे
December 6, 2012 at 12:12 am
http://www.sqlservercentral.com/Forums/Topic401784-562-3.aspx#bm1171799
-----------------------------------------------------------------------------
संकेत कोकणे
December 5, 2012 at 11:06 pm
@OP ,please do check Gail's post for managing log file
http://www.sqlservercentral.com/articles/Administration/64582/
-----------------------------------------------------------------------------
संकेत कोकणे
December 4, 2012 at 7:00 am
arunyadav007 (12/3/2012)
USE MASTER
GO
DBCC FREESESSIONCACHE WITH NO_INFOMSGS
GO
DBCC FREESYSTEMCACHE 'ALL'
GO
and how does it will help to manage the log space ?
you are just adding trouble to existing issues
-----------------------------------------------------------------------------
संकेत कोकणे
December 4, 2012 at 6:57 am
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
-----------------------------------------------------------------------------
संकेत कोकणे
December 4, 2012 at 6:17 am
let the the Sql server do its work itself , if you are not worry about Space.
Resizing (Shrinking) database ,can create performance problem.
-----------------------------------------------------------------------------
संकेत कोकणे
December 4, 2012 at 5:56 am
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
-----------------------------------------------------------------------------
संकेत कोकणे
December 4, 2012 at 5:50 am
what is the the output of the
Use YourDb
sp_helpfile
-----------------------------------------------------------------------------
संकेत कोकणे
December 4, 2012 at 4:26 am
ramyours2003 (12/3/2012)
can any one send the step by step approach who...
-----------------------------------------------------------------------------
संकेत कोकणे
December 4, 2012 at 12:05 am
ravi@sql (12/3/2012)
no actually i closed sql server and opened am able to see other databases except which i wanted to connect.
check your SQL server error logs
-----------------------------------------------------------------------------
संकेत कोकणे
December 3, 2012 at 10:18 pm
anthony.green (11/30/2012)
sanket kokane (11/30/2012)
ScottPletcher (11/29/2012)
A SQL page is 8K, with 8060 total bytes available for data. Each...
-----------------------------------------------------------------------------
संकेत कोकणे
November 30, 2012 at 4:58 am
ScottPletcher (11/29/2012)
A SQL page is 8K, with 8060 total bytes available for data. Each row resides on...
-----------------------------------------------------------------------------
संकेत कोकणे
November 30, 2012 at 4:34 am
Viewing 15 posts - 31 through 45 (of 149 total)