Tag Archives: SQL Server

SQL Server recovery using differential backup

One of my DBAs said while trying to restore differential backup he was getting  : Fix : Error : Msg 3117, Level 16, State 4 The log or differential backup cannot be restored because no files are ready to rollforward … Continue reading

Posted in database, how to, sql server | Tagged , , , , | Leave a comment

Denali is on its way !

Microsoft is coming out with a new version of SQL Server , codenamed ‘Denali’ a.k.a SQL Server 2012.  It boasts lot of new features.  I am not going to repeat all of them here now. Go to Microsoft to see all the … Continue reading

Posted in database, sql server | Tagged , , , , , | Leave a comment

Stored Proc for SQL Server and DB2 UDB

We often grant permissions against table for users. Some use the GUI, some just script it out. I wrote a quick stored procedure that will take couple of input parameter and run the grant against the tables.  Just for the … Continue reading

Posted in database, db2, sql server | Tagged , , , , , , , , , | Leave a comment

Setting up database mail in SQL server

Wouldn’t it be cool if your database server reached out to you when it wants to let you know something like a job that completed or failed and error messages its getting ? SQL Server has two built-in ways to … Continue reading

Posted in database, how to, internet, sql server | Tagged , , , , , , , , , , , , | Leave a comment