The Business Intelligence Blog

February 27, 2010

BACKUP LOG WITH TRUNCATE_ONLY in SQL Server 2008

This blog post has been moved to http://shahfaisalmuhammed.blogspot.com/2011/09/backup-log-with-truncateonly-in-sql.html

February 25, 2010

Managing Analysis Services Deployment

Once you have finished the development of Analysis Services project, there are several methods available for deploying analysis services objects from one server to other server. In this series, we will discuss the most commonly used deployment methods one by one. The entire series covers deployment using:

* BIDS
* Analysis services Deployment Wizard
* Backup and Restore
* The Synchronize Database Wizard

February 23, 2010

Tuning Your SQL Server Database

Filed under: SQL Server webcasts — Tags: , , , , , , — Shahfaisal @ 12:33 pm

MSDN Webcast: SQL Server MasterClass: Tuning Your SQL Server 2005 Database (Level 200)

February 22, 2010

SQL Server 2008 Evaluation Edition Upgrade

This blog post has been moved to http://shahfaisalmuhammed.blogspot.com/2011/09/sql-server-2008-evaluation-edition.html

February 21, 2010

How to find Database Snapshots associated with a Database

Filed under: SQL Server Database — Tags: , , , , — Shahfaisal @ 6:33 am

Often times, you might want to find out a list of all the existing database snapshots. Here is a simple script that will return each database and the associated snapshots.

          USE MASTER
          SELECT  SourceDB.[name] AS SourceDatabase,
                  SnapshotDB.[name] AS SnapshotDatabase,
                  SnapshotDB.Create_Date AS DateOfCreation
          FROM sys.databases SourceDB
          INNER JOIN sys.databases SnapshotDB
          ON SourceDB.database_id = SnapshotDB.source_database_id

I have two database snapshots on my SQL Server, so the above script will return two rows as shown in the figure below.

Older Posts »

Blog at WordPress.com.