SQL SERVER – 32 Bit – 64 Bit – HTML5 – Database Backup Restore

During TechEd India I was attending HTML5 session along with regular Database sessions. Couple of attendees were discussing database there and I find the incidence very interesting.

Note: Please take the whole discussion keeping humor as primary. There is no incident to disrespect anybody.

Attendee1: I wonder if this HTML5 works on 64-bit machine – hopefully they support it?
Attendee2: I think they will create HTML5 such a way that it will work on 32-bit and 64-bit machine.
Attendee1: Yeah they should.
Attendee2: I wonder how much work the product team developer have to do – they have to create 32-bit browser which supports 32-bit and 64-bit HTML5 and on 64-bit browser support for 32-bit and 64-bit HTML5.

I could not stop myself from speaking as I was listening this loud conversation sitting behind them.

Pinal: Hey, I think HTML5 is markup language and it will work on 32-bit and 64-bit browser without any special requirement. Just like earlier version of HTML there is no different coding for 32-bit or 64-bit browser.

Attendee1: Really!
Attednee2: Are you web developer too?
Pinal: Yes, I am web developer but I love to work on database technology.
Attendee1: Are you sure regarding there is no specific HTML for 64-bit machine?
Attendee2: Yeah. Tell me. Does your database back up from 64-bit work on 32-bit machine?
Pinal: Yes. You can restore database backup from 64-bit to 32-bit machine without issue, or vice-a-versa. Database backup is just a file and it can work independent of the version. Just like TXT file or JPG file.

Both of the attendees got very quite. Finally they whispered.

Attendee1: (Whispering) Let us try out what he is suggesting.
Attendee2: (Nodding Yes)
Pinal: (Looking at them with Wide Open Eyes).

Reference: Pinal Dave (http://blog.SQLAuthority.com)

9 thoughts on “SQL SERVER – 32 Bit – 64 Bit – HTML5 – Database Backup Restore

  1. Hi Pinal, I saw your li’l cool presentation about the SQL Map which can be created using the general SQL Server Mgmt. Studio 2008 R2. and that was really cool! It was great in participating in TechEd 2011 @ Bangalore. The three unforgettable days in my life! That was AWESOMEEE! :-)


  2. @Kuraliniyan: As you know, there’s a Backward Compatability in SQL Server that ships in all the versions right after the SQL Server 2000. The Database Schema changes with respective to the version and features that it utilizes, so you can’t replace a higher version of the backup on a Lower Version or the previous version of the SQL Server.
    Eg. A SQL Server 2008 DB’s Backup cant be replaced on a SQL Server 2005 DB Engine.

    @Pinal: Correct Me if i was wrong! :-)


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s