Category Archives: Tutorials

How to backup SQL table ?

Backup SQL table, have you ever tried to backup a single SQL table inside a database? Let’s see How to backup SQL table | SQL Table Backup Restore DOES SQL Server supports table level backups ? Backup Types are dependent on SQL Server Recovery Model. Every recovery model lets you back up whole or partial [...]

SHRINK LOG File SQL

SQL Server Database Log File has grown exponentially over a period of time and now causing DISK space issue, how to reduce | Shrink Log file SQL Database (.ldf) size? Steps to truncating log files and shrinking your database Get logical / physical name of your database log file (LDF) Truncate LOG File Shrink LOG [...]

Sample SQL Server database for 2012 Adventure Works Download

As I said, my virtual environment was expired so I need to rebuild that all over again. So here is STEP BY STEP Guide for Downloading and Attaching SQL Server 2012 Sample Database STEP 1 – DOWNLOAD AdventureWorks2008R2 Data File  **This is approx 188 MB of file might take couple of second STEP 2 – [...]

USE Database Recovery Advisory | TIMELINE Restore SQL Server

What is Database Recovery Advisor ? Database Recovery Advisor is newly introduced in SQL Server 2012 which simplifies database restore operations and allows administrators to quickly and easily restore database to a point in time from an existing backup set using a visual timeline of the backup chain. In short, Database Recovery Advisor is Graphical [...]

SQL For ANDROID – Video Tutorial

Do We have SQL Server for Android Operating System ? YES, we do have a product named “SQLite”, a open Source Database, which is inbuilt in the SQL Android based systems. That means there is no centralized database server, every Android based tablet / cell phone do have a built in database services named “SQLite” [...]

10 SQL Server Disaster Recovery Solutions

What is SQL Server Disaster? Disaster is an event that makes continuation of normal functions impossible. In business terms, any incident which result affects business or stops business transactions is a disaster for example Orders can not be placed, think about Amazon where every business transaction is online and customer is unable to place an [...]

SQL Server Recovery Model affect Performance ?

What is SQL Server Recovery model ? SQL Server Database recovery models allow you to specify the way SQL Server manages transactions and how much data can be recovered in case of disaster. There are three type of recovery models are available in SQL Server and each of these models represents a different approach to [...]