Resource Database in SQL Server 2008

Posted on by
Reply

If you have been worked with SQL Server 2005 and SQL Server 2008, you must aware of the new system database called System Resource (aka Resource) database. It is a different type of system database when compared to other system databases in SQL Server such as Master, Msdb, Model and TempDB. All the system information pertaining to that specific instance is stored in the Resource database. When a service pack / hot fix is installed the resource database is updated.

There are some interesting points to be noted with respect to Resource Database.

  • It cannot be backed up / restored  using general backup / restore procedures from inside SQL Server. It has to be manually backed up similar to a file backup on a windows server.
  • It has to be placed in the same directory where Master Database was placed, so when moving the system databases, Master in particular, the Resource Database has to be moved on to that location manually to have SQL Server start.

The following image displays the Resource database (actually mssqlsystemresource database) along with other system databases in a SQL Server 2005 installation.

With this piece of information, when you look for the same database in a SQL Server 2008 installation, you would be surprised that it does not exist anymore with the other system databases. In SQL Server 2008 the location of the Resource database has been changed to the Binary directory Binn. Due to this, when the master database is moved to a different location, there is no additional tasks related to resource database in SQL Server 2008.

The picture below displays the location of the resource database in a SQL Server 2008 installation.

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

–Bru Medishetty

PASS European Conference

Posted on by
Reply

PASS European Conference is taking place this week, between April 21-23 at Neuss, Germany. This conference is one of the largest gathering of top Microsoft Experts, MVPs, BI Experts taking part in this 3 day conference. What makes this conference more special is, Microsoft is conducting a full-day Microsoft SQL Server 2008 R2 Launch Event on April 21 followed by PASS European Conference on 22nd and 23rd April. There are more than 45 Technical Sessions on SQL Server and Microsoft BI from the subject experts.

I am not going for the event (though I really wanted to attend), I would following the events happening thru SQLPASS website, twitter and other social networking channels.  For those readers who do not want to really miss this opportunity, it is not too late (may be if you are outside Europe). Register for the conference here http://www.sqlpass.org/summit/eu2010/Registration.aspx

–Bru Medishetty

Meeting Pete Sampras is a dream come true !

Posted on by
4

Last weekend I traveled to Atlantic City, NJ to watch Pete Sampras playing an exhibition match. I was very much excited and was looking forward to watch Pete live for the first time in my life. Never before had I watched a Tennis match featuring Pete Sampras live in a Stadium, I was very happy that my dream of watching the Great Champion is going to be a reality.

The match was on Saturday evening and was eagerly waiting for that occasion. I had no idea that Pete was making an appearance for fans at 12:30 noon that day at the tennis village. I was passing by the tennis village and saw on display that Pete was there between 12:30 and 1:00 PM. Thinking that I missed a once in a life time opportunity to meet Pete, I was going  to shopping center and in the middle of nowhere I saw Pete Sampras coming in the opposite direction. I could not believe my luck and without wasting a moment went to him greeted and spoke for a couple of minutes, took his autograph on his autobiography – A Champion’s Mind (Picture 3rd in this blog). It has been my dream for nearly 20 years to meet Pistol Pete and finally that became true on that afternoon of April 10th 2010 at 1:26 PM.

You can see how much excited I was when I met him in this picture.

That was Pete talking to me.

Pete’s Autobiography A Champion’s Mind signed by him on that day.

One more souvenir from Atlantic City, this one too signed by Pete when I met him in person.

Later that evening, I watched all the matches and enjoyed every moment of it. I recorded few minutes of the match between Sampras and Safin watch it below.

YouTube Preview Image

Had it not been my brother, who informed me that Pete Sampras is visiting Atlantic City, NJ and arranged my trip, I would have missed the opportunity of meeting my favorite Tennis Star.

–Bru Medishetty