• DBA,  Scripts

    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 the database. DBA: This error mostly occurs because of insufficient space on the drive. Have you checked the drive space? Reema: Yeah, I have checked the drive space in a server –> my computer. It looks I have plenty of space on the server. DBA: Can you check the database auto growth setting in the database? Reema: I have 30…

  • DBA

    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.     Error: SQL server failed to start the system cannot find the path specified First check the drives and drive letters in my computer. Then verify the SQL server installed drive is available in your server. Go to Start –> All programs –> Microsoft SQL server 2008 –> configuration tools –> SQL server configuration manager –> Right click the…

  • Scripts

    Find the latest databse backup SQL server

    Use the simplest script to find the latest database backup and the location.   -- To get the backup history SELECT top 100 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.is_copy_only--,compressed_backup_size/1024/1024 AS C_size_MB 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='d' --and b.backup_finish_date >='2018-08-02 22:37:50.000' ORDER BY b.backup_finish_date DESC   -- To get the backup type size based on the date select sum(size_mb )from ( SELECT sum(b.backup_size /1024/1024)as size_mb,b.database_name,b.backup_finish_date FROM MSDB.DBO.BACKUPMEDIAFAMILY F JOIN MSDB.DBO.BACKUPSET B ON (f.media_set_id=b.media_set_id) WHERE b.backup_finish_date between '2012-04-25'and '2012-04-26' AND B.type='D' group by b.database_name,b.backup_finish_date --ORDER BY b.backup_finish_date DESC )as ab   You can add more conditions on where clause http://msdn.microsoft.com/en-us/library/ms186299.aspx. Like backup Type…

  • DBA

    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: -2) ” I found the problem. It’s because of firewall. SQL Cluster error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server, Error: -2)   We are using SQL server failover clustering on our application, after a failover occurred the application could not connect it. It’s used a…

  • Microsoft

    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 data exploration and stunning interactive data visualization capabilities; Cloud On Your Terms by enabling the creation and extension of solutions across on-premises and public cloud.   The main editions of SQL Server 2012 with licensing & pricing model are: Enterprise – $ 6,874 (Per core) Business Intelligence – $ 8,592 (Per server) Standard – $ 6,874 (Per core) $ 898 (Per…