Complete or Full Backup/Restore

• Creating Backup

BACKUP DATABASE [database_name]
TO DISK = 'path\backup_filename_full.bkp'
WITH INIT

• Restoring Backup

RESTORE DATABASE [existing_database_name]
FROM DISK = 'path\backup_filename_full.bkp'

RESTORE DATABASE [new_database_name]
FROM DISK ='path\backup_filename_full.bkp'
WITH MOVE 'database_name TO 'path\new_database_name.mdf'
         MOVE 'database_name_log' TO 'path\new_datanase_name.ldf'
 

Differential Backup/Restore

• Creating Backup

BACKUP DATABASE [database_name]
TO DISK ='path\backup_filename_diff.bkp'
WITH INIT, DIFFERENTIAL

• Restoring Backup

As we know the Differential contains only the modified since last full backup, so we have to RESTORE the full backup first with NORECOVERY and then differential with RECOVERY statement.

RESTORE DATABASE [database_name]
FROM DISK 'path\backup_filename.bkp'
WITH NORECOVERY

RESTORE DATABASE [database_name]
FROM DISK 'path\backup_filename_diff.bkp'
WITH RECOVERY

What am I doing, would you like to know

• I am writing a tutorial which covers almost every single basic query usage in SQL Server (Soon publising)
• Preparing to attend upcoming TechEd 2007 sessions
• Preparing to organize coming .NetFoundry community event.

All these with the help of Allah.

Bandagi.

Compartive features of VS.Net 2005 between different editions can be found on http://msdn2.microsoft.com/en-us/vstudio/aa700921.aspx, quite usefull.

Bandagi!

Today "<<.NetFoundry moments>>" - .NetFoundry's community magazine was launched

I will wait for your feedbacks.

Enjoy reading!

Bandagi!

The CTP will aid in learning the new capabilities of SQL Server 2008, read more https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5470

Bandagi!

Topic: SharePoint Server 2007 - Developer Platform Integration
Speaker: Danish Sami - MVP, Windows Server System - SQL Server
Dated: 02-08-2007
Location: Babbage Theatre, Mercator, AlFattan Plaza
Expected Participant: 20+
Actual Participant: 15

Link to Photos: http://yukonizer.com/Web/photos/2226300707/default.aspx 

AGENDA - Day3

• Content Development 
  • Demo
• Administration
• Content Deployment 
  • Demo

The following is a list of publications and links to related sites.

Writing Managed Stored Procedures with CLR code
Publisher: SSWUG
Link: http://www.sswug.org/seeauthor.asp?aid=17763
With the integration of Common Language Runtime and SQL Server 2005 now its possible to manage stored procedures, trigges and user defined functions using .Net compliant language.

Resource Governor – Administrator’s Choice
Publisher: Innovation-HUT
Link: http://www.innovation-hut.com/Articles/Sql/resourcegovernor.aspx
Resource Governor or RG is SQL Server 2008's new feature through which one can easily manage system resources like CPU, I/O. With RG you can define resource limits, priorities and enable consistent performance.

C# Help
http://www.csharphelp.com/archives2/archive309.html

Topic: SharePoint Server 2007 - Developer Platform Integration
Speaker: Danish Sami - MVP, Windows Server System - SQL Server
Dated: 26-07-2007
Location: Babbage Theatre, Mercator, AlFattan Plaza
Expected Participant: 37+
Actual Participant: 25

AGENDA - Day2

• Custom Page Layout
  • Demo
• Team Development
• Workflow 
  • Demo

Topic: SharePoint Server 2007 - Developer Platform Integration
Speaker: Danish Sami - MVP, Windows Server System - SQL Server
Dated: 22-07-2007
Location: Babbage Theatre, Mercator, AlFattan Plaza
Expected Participant: 33+
Actual Participant: 20

AGENDA - Day1

• Product architecture
• Understanding installation options
  • Pre-requisites
  • Step by Step – Installation and Configuration
• ASP. Net Web Parts
  • Demo