How to create and setup a SQL clustering on your Desktop or Laptop
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 run as a domain user. You may get the error following error message in your job history.
Executed as user: Domain\XXX.Service. Login failed… Read more
The transaction log for database is full. To find out why space in the log cannot be reused
Could not allocate space for object because the filegroup is full
Hello DBA it seems our application not working today. We got some error it looks like some problem with… Read more
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
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
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
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…
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
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
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
SQL server has three types of internal joins. I know most of folks never… Read more
Microsoft has given the SQL Server Denali CTP3 (Community Technology Preview) for public preview. You can download the SQL Server Denali CTP3 here.
I’m very interested to see the SQL Server Denali new Features.
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
SQL server T-SQL best practice
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.
SQL server Database restores sequence Steps
It’s a simple task to the experienced DBAs. However it’s…
SQL server Disaster Recovery Options
The disaster recovery is really “It depends”.
What is disaster recovery?
Disaster recovery is called DR. Hmm…
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
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
Microsoft SQL Server 2008 R2 SP1 CTP
SQL Server 2008 R2 SP1 10.50.2418.0 CTP is available now. You may download and test it.