Friday, July 19, 2013

[MS SQL Server] How to apply patches one and more sql at same tme

[MS SQL Server] How to apply patches one and more sql at same tme

How to apply patches one and more sql at same tme

Posted: 19 Jul 2013 02:29 AM PDT

one of the our client ask to me ,300 sql servers need to apply patches same time ?how to do ? Any vb cript or batch command..Plz anyone help on thisThanks,jery

SQL server Service pack Installation

Posted: 19 Jul 2013 04:04 AM PDT

Hi,In our environment ,we are planning on applying service packs to all the sql instances which were old and we have 2005/2008/2008R2.I have searched online but i dont find any particular document for service packs or patches.Can anyone please send me a document or link that shows step by step process for applying the SP's ?I'm looking for the pre-reqs, installation process and post installation with all the details...Also , my main concern is i'm preparing a document with list of sql servers in my environment ( i believe there are around 100 servers ), version,current service pack, latest service pack to apply ...Please help me on finding a script to get all these details at once...like any powershell or cmd script ?Thanks in advance...

Central Management Server left out in the cold

Posted: 18 Jul 2013 01:46 PM PDT

I just set up a Central Management Server and can now check my policies against a whole group of SQL Server instances. This is great! However, it seems the instance that is designated as the Central Management Server is not checked when policies are evaluated. Is there any way to include this instance or do all policies need to be checked twice: once for the central server, and again on the target group?

SQL 2008 cluster installation failed

Posted: 19 Jul 2013 01:25 AM PDT

Today we tried installing SQL 2008 cluster. It failed with error "[b]Wait on the database engine recovery handle failed[/b]". We tried uninstalling it to do a fresh install but uninstall also failed with error "[b]Object reference not set to an instance of an object[/b]". Has anyone came across this? Any suggestion how can we resolve it.Regardssqldba4u

Does a deadlock get recorded in the log without trace flags?

Posted: 19 Jul 2013 12:03 AM PDT

Not the entire deadlock information that's returned when you enable a trace flag (1204 or 1222,) but at least something like "deadlock occurred between SPID X and Y?" Something I can quickly find in the logs?Based on this: [url=http://www.brentozar.com/archive/2011/07/difficulty-deadlocks/]http://www.brentozar.com/archive/2011/07/difficulty-deadlocks/[/url]It sounds like the answer is yes.I'm asking, as I've got one server which was experiencing LOTS of deadlocks, I did have the trace flag 1222 enabled for a time and was using this: [url=http://blogs.msdn.com/b/bartd/archive/tags/sql+deadlocks/default.aspx]http://blogs.msdn.com/b/bartd/archive/tags/sql+deadlocks/default.aspx[/url] to troubleshoot. Since then (and updating statistics, which I should've done sooner seeing as said DBs were migrated from an old server...) the number of deadlocks has fallen precipitously (as in I haven't seen one in a week) so I've turned off the trace flag.I've been checking using XEs but I'd like to double check myself, and the SQL Log would be ideal...Thanks,Jason

Discrepancy between recent activity and transaction log file

Posted: 19 Jul 2013 12:06 AM PDT

Hello --I am monitoring our database server using dbWarden and ApexSQL log viewer. The dbWarden utility reported activity within the past twenty-four hours to a particular database's mdf and ldf files. I opened the latter application to investigate. When I opened ApexSQL viewer, without any filters, the last entry that was displayed was from the July 9 date. Hence there is a discrepancy of ten days between what was supposedly written last night, and what was recorded to the database. To add to the confusion, I checked the directory where the ldf file is located, and according to the details of the file, the last modification date was the July 3 date. What would cause the discrepancy that I described, and what can I do to correct it?Thanks.

Restore SQL Server 2008 R2 database on SQL Server 2008

Posted: 18 Jul 2013 11:03 PM PDT

How can I (if it is possible to) restore SQL Server 2008 R2 database on SQL Server 2008?

alert or trigger on create login

Posted: 18 Jul 2013 08:16 PM PDT

hello,is it possible to have an alert on a create login?with a trigger, an SQL Alert or ...Thank you.

Backup has corrupted .. need to get full recovery for the database

Posted: 18 Jul 2013 05:27 PM PDT

I am taking backups regularly without any issue, suddenly I noticed backup is failed in one day and checked DBCC executed on database. I got result as fatal corruption in the database. In this situation i went for previous day backup to restore the database ( as per the MS recommendation... we will try to restore the DB from the previous good backups.. ) but unfortunately the backup found having issues and its not avalid backup to restore. So i checked before the previous day backup ( 2 days back) is available but don't have t-log backups after this full backups.Can some body please advise what is best options to recovery my database as full recovery...

System-health extended-event session does not capture latest deadlocks

Posted: 20 Dec 2012 08:04 PM PST

While running the following query to capture the latest deadlocks recorded in the default system-health extended-event session, I noticed that the latest deadlock captured was 3 days ago. However, in the SQL ERRORLOG I see that several deadlocks have occurred as recently as today.Has anyone else noticed this issue?[code="sql"]--http://www.quest.com/whitepaper/how-to-use-sql-servers-extended-events-and-notifications816315.aspx;WITH SystemHealthAS ( SELECT CAST ( target_data AS xml ) AS SessionXML FROM sys.dm_xe_session_targets st INNER JOIN sys.dm_xe_sessions s ON s.[address] = st.event_session_address WHERE name = 'system_health')SELECT Deadlock.value ( '@timestamp', 'datetime' ) AS DeadlockDateTime, CAST ( Deadlock.value ( '(data/value)[1]', 'Nvarchar(max)' ) AS XML ) AS DeadlockGraphFROM SystemHealth sCROSS APPLY SessionXML.nodes ( '//RingBufferTarget/event' ) AS t (Deadlock)WHERE Deadlock.value ( '@name', 'nvarchar(128)' ) = N'xml_deadlock_report'ORDER BY Deadlock.value ( '@timestamp', 'datetime' );[/code]
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog