Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Server Blog Forum

My name is Muthukkumaran Kaliyamoorthy and I am living in India (Chennai). I’m currently working as a SQL server DBA in one of the top MNC. I’m passionate about SQL Server, and I’m specialized in Administration and Performance tuning.

An application error occurred on the server running on SQL server

Recently one of my application website went down.

 

I checked all the basic connectivity troubleshooting and seem everything was looking and working fine. Finally, I found the problem with the browser service but that’s also in running state.

Error from the event viewer:

 

 

The quick solution is… Read more

0 comments, 205 reads

Posted in SQL Server Blog Forum on 25 November 2013

Create and setup a SQL clustering on your Desktop or Laptop

How to create and setup a SQL clustering on your Desktop or Laptop

 

I thought to write this post after I discussed in a forum. SQL clustering is a bit complicated one. I mean most of the DBAs are not configured or tested it, because we don’t get… Read more

9 comments, 833 reads

Posted in SQL Server Blog Forum on 26 September 2012

Login failed for [SQLSTATE 28000] (Error 18456) the step failed

Login failed for [SQLSTATE 28000] (Error 18456) the step failed

 

When you query the data from another SQL server (Linked server) and SQL server & agent service is run as a domain user. You may get the error following error message in your job history.

Error:

Executed as user:… Read more

1 comments, 4,355 reads

Posted in SQL Server Blog Forum on 18 June 2012

Find the database free space sql server The transaction log for database is full

The transaction log for database is full. To find out why space in the log cannot be reused

OR

Could not allocate space for object because the filegroup is full

Reema:

Hello DBA it seems our application not working today. We got some error it looks like some problem with… Read more

0 comments, 2,267 reads

Posted in SQL Server Blog Forum on 23 May 2012

SQL server failed to start the system cannot find the path specified

Recently one of our SQL server unable to start it. The problem with the storage LUNs.

 

 

Things you have to do: When you get this above message while starting SQL server service.

Check the event viewer both system and application log. There you will know the exact problem. Read more

0 comments, 932 reads

Posted in SQL Server Blog Forum on 9 April 2012

Find the latest databse backup SQL server

Use the simplest script to find the latest database backup and the location.

 

SELECT b.server_name ,b.database_name,b.user_name, f.physical_device_name,
b.backup_finish_date,b.backup_size /1024/1024 AS size_MB,b.type,b.recovery_model,
b.has_bulk_logged_data,b.is_copy_only,f.mirror
FROM MSDB.DBO.BACKUPMEDIAFAMILY F
JOIN MSDB.DBO.BACKUPSET B
ON (f.media_set_id=b.media_set_id)
WHERE database_name='test'
--AND B.type='L'
ORDER BY b.backup_finish_date DESC

 

You can add more conditions on where clause http://msdn.microsoft.com/en-us/library/ms186299.aspx. Read more

2 comments, 308 reads

Posted in SQL Server Blog Forum on 5 March 2012

SQL server the timeout period elapsed prior to completion of the operation

SQL server clustering the timeout period elapsed prior to completion of the operation

Recently I faced one of our application could not connect. It throws an error ” Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server, Error:… Read more

2 comments, 11,464 reads

Posted in SQL Server Blog Forum on 22 January 2012

SQL Server 2012 licensing details

Microsoft’s SQL Server 2012 (AKA SQL Server code-name ‘Denali’), new details have been released http://www.microsoft.com/sqlserver/en/us/future-editions/sql2012-licensing.aspx.

 

1.      What is new in SQL Server 2012?

SQL Server 2012 will provide Mission Critical Confidence with greater uptime, blazing-fast performance and enhanced security for mission critical workloads; Breakthrough Insight  with managed self-service…

Read more

2 comments, 1,162 reads

Posted in SQL Server Blog Forum on 24 November 2011

SQL server could not start cannot find object or property (0×80092004)

SQL server could not start cannot find object or property (0×80092004)

Recently I got a call from my team the users couldn’t connect the SQL server and it’s throwing error. As always, I checked the SQL server status via configuration manager and noticed the server 2008 r2 stopped.  I tried… Read more

0 comments, 681 reads

Posted in SQL Server Blog Forum on 7 November 2011

AWE has removed from SQL server 2012

AWE has removed from SQL server 2012

AWE has removed from SQL server Denali onwards. Say bye bye to 32 bit servers. To use more than 4GB memory you have to buy 64 bit servers.

 

A small organization may suffer because of this feature has removed from the next… Read more

4 comments, 418 reads

Posted in SQL Server Blog Forum on 18 October 2011

SQL server 2012 Denali not starting there is insufficient memory available in the buffer pool

SQL server 2012 does not start

Today is not a good day. Ha ha not like that

Usual I opened SQL server DENALI to play something it doesn’t open (start) it at all. It’s throwing error. Probably you know what I will do I went configuration manager checked the service… Read more

6 comments, 635 reads

Posted in SQL Server Blog Forum on 16 October 2011

Merge join Vs Hash join Vs Nested loop join

 

This month’s TSQL Tuesday party is being hosted by Stuart R Ainsworth (Blog| Twitter). I am very glad to write my first blog post as t-SQL Tuesday post on my newly designed website.

SQL server has three types of internal joins. I know most of folks never… Read more

25 comments, 559 reads

Posted in SQL Server Blog Forum on 4 October 2011

SQL Server 2008 SP2 cumulative update 9

SQL Server 2008 latest cumulative updates 9 build 10.50.1804 available now. You may download and test it Cumulative Update 9 for SQL Server 2008.

Read more

0 comments, 469 reads

Posted in SQL Server Blog Forum on 19 August 2011

SQL Server Denali CTP3 Download

Microsoft has given the SQL Server Denali CTP3 (Community Technology Preview)  for public preview. You can download the SQL Server Denali CTP3 here.

 

http://www.microsoft.com/betaexperience/pd/SQLDCTP3CTA/enus/default.aspx

I’m very interested to see the SQL Server Denali new Features.

Read more

0 comments, 324 reads

Posted in SQL Server Blog Forum on 21 July 2011

SQL Server 2008 SP2 cumulative update 5

SQL Server 2008 SP2 10.50.2418.0 latest cumulative update 5 available now. You may download and test it.

Cumulative Update 5 for SQL Server 2008 Service Pack 2

http://support.microsoft.com/kb/2555408

Read more

0 comments, 271 reads

Posted in SQL Server Blog Forum on 20 July 2011

T-SQL best practice SQL server

SQL server T-SQL best practice

This month’s TSQL Tuesday party is being hosted by Amit Banerjee (Blog | Twitter).

He is working with Microsoft and see here his online activities MSDN. The topic this month is T-SQL best practice. It’s the both DBA and developers Topic/Job.

Transact…

Read more

13 comments, 1,400 reads

Posted in SQL Server Blog Forum on 12 July 2011

SQL server Database backup restores Steps

SQL server Database restores sequence Steps

I have seen many people are still unclear about the database restoration sequence. Recently I have answered a number of database restoration questions SSC, MSDN… I got a comment from Anonymous user.

It’s a simple task to the experienced DBAs. However it’s…

Read more

15 comments, 719 reads

Posted in SQL Server Blog Forum on 6 July 2011

SQL server Disaster Recovery plan

SQL server Disaster Recovery Options

This month’s TSQL Tuesday party is being hosted by Allen Kinsel (Blog | Twitter) and the topic this month is disaster recovery. It’s a DBA Topic/Job.


The disaster recovery is really “It depends”.

What is disaster recovery?

Disaster recovery is called DR. Hmm…

Read more

28 comments, 639 reads

Posted in SQL Server Blog Forum on 14 June 2011

SQL server Recovery Models and Backup types

In this post I am going to explain the importance of recovery models and backup types.

Why I am writing this post ?

Because, when I was teaching about the topic to my PHP friend .He got doubts on bulk logged recovery model and differential backups. I have given some… Read more

27 comments, 543 reads

Posted in SQL Server Blog Forum on 7 June 2011

Restoring a database from higher version to lower version SQL server

Restoring a database from higher version to lower version SQL server

How to downgrade a database from higher version to lower version?

There is no direct way to do this like Backup/Restore. You can use an alternative ways.

The alternative ways are,

 

1. Generate Script

2. Import/Export

3. Transaction…

Read more

12 comments, 942 reads

Posted in SQL Server Blog Forum on 28 May 2011

Older posts