Restore Database(s) from backupfiles

The script restore the database backup (single or multiple) from the backup-file(s) stored at a location. The script only take backupfile path as a parameter , the database are restored with the same name as stored in the backupfiles EXEC [Usp_dba_RestoreDatabase] @BackupFilePath=’drive\foldername’ The database files will be restored at the same location as in the […]

MERGE RANGE PARTITION SQL SERVER 2005

Merging Partition states moving the data into an exiting partition or to new file group (Forward only means to next file group or Partition).   The merged partition resides in the filegroup that originally did not hold boundary_value. boundary_value is a constant expression that can reference variables (including user-defined type variables) or functions (including user-defined […]

Database SnapShot SQLServer 2008

Database snapshot feature is available in MS-SQLServer2005 and SQLServer2008.It is supported by all recovery models of SQL Server 2005 and SQL Server 2008. A Database snapshot is read-only, static view of a database (the source database). A Database snapshot captures the data and committed transitions of the OLTP Database. No uncommitted transactions are recorded in database […]

Install SQLServer2005 from Command Prompt

In this topic we focus on how to install SQLServer 2005 from Command Prompt with out user intervention. To install SQLServer 2005 copy the dump to a Location (Local or Remote).If u have WinXP SP2 installed or Win2003 SP1 unblock the dump as it will block the installation. Lets assume you are installaing SQLServer 2005 […]

Automating administration across multiple instances of SQL Server (MultiServer Administration)

Multiserver administration is the process of automating administration across multiple instances of Microsoft® SQL Server™. With multiserver administration, you must have at least one master server and at least one target server. A master server distributes jobs to and receives events from target servers. A master server stores the central copy of job definitions for […]

How to truncate Mirrored Database Log File

Mirroring is a new feature comes with SQLServer 2005. Mirroring provides High Availibity of databases without any dataloss. Mirroring Comes with three flavours (1) High Performance (asynchronous). (2) High safety without automatic failover (synchronous). (3) High safety with automatic failover(synchronous) need withness server. (Read more in BOL  Look For : mirroring databases [SQL Server]) This […]

How to create partitioned table and moving non-partitioned tables to partition schemes

 Tables Partitioning is a new feature available in SQL Server 2005, focusing on  improving performance of large database systems and Highly Transactional Databases. Partitioning feature is only available with SQLServer2005 EE and DE. This article focuses on how to create a partitioned table and moving non-partitioned tables to partition schemes. Steps: Creating the Partitioned Tables 1.Add FileGroups   USE [Database name] […]