Viewing 15 posts - 631 through 645 (of 860 total)
prvreddy (3/3/2009)
Hi,Recently i faced a question "how do we know database damage/crash happened in sql server?" and
Can anybody give answer to this question!
Thanks in Advance
Vijaya Reddy
You would not really know,...
March 4, 2009 at 1:43 am
TRACEY (2/13/2009)
Sorry Mode X Lock Type is KEY, STATUS GRANTSQL 2005
KEY RANGE locks, are you updating or inserting any new rows?
Do you face any problem with them or is...
March 4, 2009 at 1:39 am
its a bit tough to analyse this using the graph. Put Trace flag 1222 ON which gives you a c more clear picture with the SP's and the TSQL...
March 4, 2009 at 1:33 am
prvreddy (3/3/2009)
Hi,Recently i faced a question "how do we know database damage/crash happened in sql server?" and
Can anybody give answer to this question!
Thanks in Advance
Vijaya Reddy
Above suggestions are good
check this...
March 4, 2009 at 12:52 am
ansar.vma (3/3/2009)
When i am trying to access maintenance plan in SQL Server 2005, I am getting the following error message
"Agent Xp component is turned off as part of the...
March 3, 2009 at 7:09 am
vijaysingh (3/3/2009)
Hi Krishna,I am unable to execute logshipping monitor tables and my setup is in restore mode.
You should query them on against your primary server, all the log shipping information...
March 3, 2009 at 6:45 am
vijaysingh (3/3/2009)
Hi Krishna,In my case i have not used monitor instance.
No, Vijay this is a system table to monitor the log shipping instance. it does not matter whether you have...
March 3, 2009 at 6:30 am
vijaysingh (3/3/2009)
Below is the information what i got when i checked the error log of LS_Alert Job
Date3/3/2009 4:58:00 PM
LogJob History (LSAlert_DEEPAKA\SQL2005)
Step ID0
ServerDEEPAKA\SQL2005
Job NameLSAlert_DEEPAKA\SQL2005
Step Name(Job outcome)
Duration00:00:01
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net...
March 3, 2009 at 5:37 am
vijaysingh (3/3/2009)
I tried to run the query like " Select * from [DB_NAME].[SCHEMA_NAME].[TABLENAME]"
Its giving the below error
Msg 927, Level 14, State 2, Line 1
Database 'MANAGEMENTNEW' cannot be opened....
March 3, 2009 at 4:17 am
Perry Whittle (3/1/2009)
Krishna (3/1/2009)
Index Rebuilding etc..you probably don't want to be\shouldn't nedd to be doing this daily
oops my mistake:P....meant to say maintenance tasks not daily, sometimes you would have to...
March 1, 2009 at 5:28 am
and also Set your transaction log file size to the maximum value that it can grow. I would advise you to monitor the Tlog growth/day basis.
I would also recommend you...
March 1, 2009 at 12:00 am
peace2007 (2/25/2009)
Hi,in one of our servers, when we try a select query on a table, which has 5700 rows, it takes around 20 seconds to return the result.
post...
February 25, 2009 at 3:31 am
Specifically for this one:
MS Press Kit
Tata McGraw Hill- All in One
CBT 70-431 back
and our good old friend BOL
Should be enough for this exam
All the best 🙂
February 24, 2009 at 5:33 pm
mikeg (2/24/2009)
Krishna (2/19/2009)
lavani.sari (2/19/2009)
2. The MCTS self paced training kit from microsoft ---Is this a good one to rely on and break through the exam?
Nope, Be preapred to cover...
February 24, 2009 at 5:10 pm
Magy (2/24/2009)
No, I never did find a backup. It wasn't too terrible because the system was only a development system. But it definitely taught me a lesson!
Follow this...
February 24, 2009 at 8:19 am
Viewing 15 posts - 631 through 645 (of 860 total)