Ran a Job yesterday to check how the SQL agent Handles the DayLight Savings Created the following Table Created the Following procedure to enter the current Date and Ran the Job every minute from March 28th 2009 22:50 to Mar 29th 2009 3:00 AM Results: There was no 01:00 AM on March 29th !!!!. So [...]
The Following Script will output the List of Databases in the SQL server and gets the Last Date the Databases were backed up select Convert(Varchar(25),server_name) as ‘Server Name’ ,convert(varchar(25),database_name) as ‘Database’ ,max(backup_finish_date) as ‘Last_backup_date’ from msdb..backupset Where database_name in (select name from master..sysdatabases) and server_name = @@servername group by server_name,database_name order by Last_backup_date DESC
Problem: I was trying to configure the backups on Sql Server using the Maintenace Plan. When I opened it . I got the following error TITLE: Microsoft SQL Server Management Studio —————————— Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 —————————— ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement [...]
Policy-Based Management(PBM) is the expansion of advanced DDL trigger mechanisms on the Server. Think of the following things a. How do I allow the users to create the table in specific naming conditions like starting only with ‘T’? b. How about checking the availability of the latest Sql Server backups? c. How about limiting the [...]
