Tag Archives: Database Snapshot

Database snapshot, SSIS, SQL Server Integration Services, SQL Server, Databases, Business Intelligence

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 it
  • where it is physically located in my hard-drive

1. Size of database snapshot = Actual Size in query results
2. Size allotted for database snapshot = File Size in query results

Read the rest of this entry »


Tags: ,