SQL server 2008: Extended events

In this video, you will learn about how to extended events are configured and how they work:  Presented By: Bryan Von Axelson  

1

SQL server 2008 clustering using Hyper-V-Video

In this video you will learn about how to configure SQL 2008 Cluster using hyper-v on windows 2008. To watch the video in high quality please check the link :-https://channel9.msdn.com/posts/SQL-2008-Clustering-using-Hyper-V Presented By : – Balmukund Lakhani    

1

PRB: SQL Backups to a UNC path fail with OS Error 1 (Incorrect Function)

Symptoms When you try to take a SQL Server database backup to a UNC path (\\server\folder\), you get this error,   Msg 3201, Level 16, State 1, Line 1   Cannot open backup device ‘\\server\folder\db.bak’. Operating system error 1(Incorrect function.).   Msg 3013, Level 16, State 1, Line 1   BACKUP DATABASE is terminating abnormally….

1

Case Study: Troubleshooting a Slow Log Shipping Restore job

Scenario Consider a scenario where you have a Log shipping setup with a STANDY secondary database and things are working just fine. One fine day you notice that the secondary database is not in sync with the primary. The seasoned DBA that you are, you go ahead and looked at the log shipping jobs and…

16

Using Bulk Logged recovery model for Bulk Operations will reduce the size of Transaction log backups – Myths and Truths

It’s has been couple of years for me working on SQL Server and I keep coming across various SQL Server misconceptions (or say a DBA Myth). In this specific post I’ll demystify a common DBA myth around log-shipping: "In a log shipping setup, to have smaller size T-log log backups being shipped to secondary, switch…

18