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…
-
-
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…
-
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…
-
SQL server could not start cannot find object or property (0x80092004)
SQL server could not start cannot find object or property (0x80092004) 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 to start the SQL server but it’s not started and its shows could not start the service. I went to the application log it has so many error messages. Event viewer Errors: Could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems. Could not start the network…
-
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 version. For more look the following links SQLOS Team’s post : SQL Server Memory Manager Changes in Denali http://sqlblog.com/blogs/sqlos_team/archive/2011/01/04/sql-server-memory-manager-changes-in-denali.aspx MS’s post : Features Not Supported in the Next Version of SQL Server http://msdn.microsoft.com/en-us/library/ms143729.aspx