Useful information about available Database Snapshots in SQL Server

Hi All, Once I had to find out few details of available database snapshots in SQL Server. I wrote following script which helped me to find out following: how many database-snapshots are available & live whats the size1 of database snapshot as well as the allotted size2 for database snapshot What collation is assigned to [...]

February 20, 2012 · bigator Khilitchandra Prajapati · bigator No Comments
bigator Tags: Database Snapshot, SQL Server · Posted in: Database Snapshot, SQL Server

Browse Posts
May 2013

M T W T F S S

« Feb

1 2 3 4 5

6 7 8 9 10 11 12

13 14 15 16 17 18 19

20 21 22 23 24 25 26

27 28 29 30 31
Categories Basket
- Business Intelligence (32)
  - Visio (2)
- General (46)
  - E-Book (3)
  - Excel (2)
  - Free (8)
  - Funny (1)
  - Microsoft Connect (1)
  - Microsoft Event (5)
  - New Features (10)
  - Quick Fix (9)
  - Training (3)
  - VB Script (1)
  - Windows (2)
- Interview QA (51)
  - Quick Tips (24)
  - Script (5)
  - Suggestion (8)
  - Tutorial (33)
- SharePoint (4)
  - SharePoint List Adapter (1)
- SQL Azure (2)
- SQL Server (60)
  - Database Diagram (1)
  - Database Snapshot (1)
  - Dynamic Management Views (2)
  - File Stream (1)
  - File Tables (1)
  - T-SQL (8)
- SQL Server 2012 (17)
  - Virtualization (1)
- SQLServerPedia (4)
- SSAS (15)
  - Data Mining (3)
  - DMX (4)
  - MDX (6)
  - Pivot Table (4)
  - Power Pivot (1)
  - Query Tuning (2)
- SSIS (19)
  - Default Logging (1)
  - DTEXEC (2)
  - Merge Join (1)
  - XP_CmdShell (1)
- SSRS (14)
  - Report Builder 3.0 (1)
  - SparkLines (1)
- Uncategorized (4)
- Video (1)