SQL SERVER – Delete Backup History – Cleanup Backup History

SQL Server stores history of all the taken backup forever. History of all the backup is stored in msdb database. Many times older history is no more required. Following Stored Procedure can be executed with parameter which takes days of history to keep. In following example 30 is passed to…
Read More

SQLAuthority News – 5 Millions Visitors – 2 Anniversary – Authors Note on Economy Slow Down and Job Opportunity – SQL Server

I just received the following screen shot from one of the regular readers of the SQLAuthority.com blog. He pointed out important milestone for our blog. We have crossed 5 million visitors. In less than 2 years SQLAuthority.com blog has been visited by 5 million visitors. I even missed the anniversary our blog. On November 1st, 2008 SQLAuthority.com has completed 2 years of its existence and now continuing in 3rd year.

Read More