Viewing 15 posts - 16 through 30 (of 149 total)
did you check database log size before the backup ?
instead of only once in day,you should configure log backup to execute frequently,say every hour depending of your database size
-----------------------------------------------------------------------------
संकेत कोकणे
December 9, 2012 at 10:41 pm
Clustered index defines physical order of your data .
Please go through the link I provided in last post .
SQL server do not give the estimated time required to complete this...
-----------------------------------------------------------------------------
संकेत कोकणे
December 7, 2012 at 5:52 am
Do you mean Clustered Index ?
http://www.sqlservercentral.com/stairway/72399/
-----------------------------------------------------------------------------
संकेत कोकणे
December 7, 2012 at 4:33 am
i'm still finding meaning of the status no,
Seems there is no information about it on Microsoft document
-----------------------------------------------------------------------------
संकेत कोकणे
December 7, 2012 at 2:15 am
I came to know that is_auto_close_on is set to 1 (True) that means it will try to get up automatically right ?
if Auto_close is False, Sql server just...
-----------------------------------------------------------------------------
संकेत कोकणे
December 7, 2012 at 12:56 am
did you try this ?
Alter database DB_Name set online
-----------------------------------------------------------------------------
संकेत कोकणे
December 7, 2012 at 12:35 am
did you try to make it online ?
Alter Database DBNAME set online
also what is the status of the DB
select * from sys.sysdatabases where name = 'DB NAME'
did you checked...
-----------------------------------------------------------------------------
संकेत कोकणे
December 7, 2012 at 12:02 am
sqlfriends (12/6/2012)
I suppose it will get bigger, although maybe the data entered is not many
It will not get bigger ,if you have maintenance plan for regular backup log.
but at least...
-----------------------------------------------------------------------------
संकेत कोकणे
December 6, 2012 at 11:52 pm
i'm Sure there must be something in error log or atleast in Event Viewer logs.
Reason may be any long transaction got interrupted due to network problem .
Also check ,Auto_close option...
-----------------------------------------------------------------------------
संकेत कोकणे
December 6, 2012 at 11:46 pm
marygrace_laurente23 (12/6/2012)
Hi Sanket,you mean it's the "maximum worker threads:"?
No, Please check the attachement
-----------------------------------------------------------------------------
संकेत कोकणे
December 6, 2012 at 11:23 pm
right click on server connection
>properties
>Processor
-----------------------------------------------------------------------------
संकेत कोकणे
December 6, 2012 at 10:13 pm
GilaMonster (10/23/2010)
It's trivial to test and, if you want, I can find a blog post from the former program manager of the Storage Engine stating and proving this.
Yes Please 🙂
-----------------------------------------------------------------------------
संकेत कोकणे
December 6, 2012 at 4:24 am
chetan.aegis (12/6/2012)
-----------------------------------------------------------------------------
संकेत कोकणे
December 6, 2012 at 2:02 am
did you check SQL server agent logs ?
check SQLAGENT.OUT files in your '\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log' directory
-----------------------------------------------------------------------------
संकेत कोकणे
December 6, 2012 at 12:28 am
what is their in Windows Event log ?
-----------------------------------------------------------------------------
संकेत कोकणे
December 6, 2012 at 12:14 am
Viewing 15 posts - 16 through 30 (of 149 total)