MS SQL DBA Tools - Storage Manager
Provides manageability of the MS SQL database and datafiles. Allowing a user to visualize and maintain storage, databases and backup devices.
|
Toolbar Operations -
Refresh : Will refresh all tabs in the storage manager from the database
Expand All: Expands all tree nodes in the tree tab
Collapse All: Collapses all tree nodes in the tree tab
Create Database: Create a new database
Alter Database : Edit the selected database
Drop Database: Drop the selected database
Database Properties: View properties of selected database
Backup Database: Create a database backup of selected database
Restore Database: Restore selected database from a backup
Attach Database: Attach database to the server
Detach Database: Detach selected database from the server
DBCC: Run DBCC commands on selected database
Update Statistics: Update statistics on selected database
Checkpoint: Issue a checkpoint for selected database
Shrink Database: Shrink selected database
Set Online: Set selected database online/offline
Create Backup Device: Create a new backup device
Drop Backup Device: Drop selected backup device
Backup Device Properties: View properties of selected backup device
|
Tree Tab -
Hierarchical display of the databases and datafiles.
Name: Name of the database or datafile
Type: Datafile type (Data or Log)
Path: Path of the datafile
Status: Database status {ONLINE, OFFLINE, READ ONLY, SINGLE USER}
Total Size: Total allocated space for the database/datafile
Unreserved: Unreserved space in the database/datafile
Total Reserved (Percent): Percentage of reserved space in the database
Data Reserved (Percent): Percentqage of space reserved in the database for data
Log Reserved (Percent): Percentage of space reserved in the database for logs
Space Available: Total available space in the database
|
 MS SQL DBA Tools - Storage Manager - Tree Tab |
Databases Tab -
Provides a list of databases and detailed information on each database.
Name: Name of the database
Status: Database status {ONLINE, OFFLINE, READ ONLY, SINGLE USER}
Owner: Database owner
Date Created: Date when the database has been created
Total Size: Total allocated space for the database
Unreserved: Unreserved space in the database
Total Reserved (Percent): Percentage of reserved space in the database
Data Reserved (Percent): Percentqage of space reserved in the database for data
Log Reserved (Percent): Percentage of space reserved in the database for logs
Space Available: Total available space in the database
Data Size: Total size of space allocated for datafiles
Log Size: Total size of space allocated for logfiles
Data Used: Space used in the database by data
Index Used: Space used in the database by indexes
Unused: Total unused space in the database
Log Used: Space used in the database by logs
Data Used: Space used in the database by data
Index Used: Space used in the database by indexes
Unused: Total available (unused) space in the database
Log Used: Space used in the database by logs
|
 MS SQL DBA Tools - Storage Manager - Databases Tab |
Datafiles Tab -
Provides a list of datafiles and detailed information on each datafile.
Name: Name of the database file
Database: Name of the database
Path: Filesystem path of the database file
Type: Datafile type (Data or Log)
Size: Total allocated space for the datafile
Unreserved: Unreserved space in the datafile
Reserved (Percent): Percentage of reserved space in the datafile
File Group: File group the datafile belongs to
|
 MS SQL DBA Tools - Storage Manager - Datafiles Tab |
Backup Devices Tab -
Provides a list of backup devices and detailed information on each backup device.
Name: Name of the backup device
Type: Backup device type (disk or tape)
Physical Location : Physical location of the backup device
Clicking on a backup device provides information on backups stired on this device:
Name: Name of a backup
Server: Name of the server
Database: Name of the database
Type: Backup type (database, transaction log, file, differential database, differential file, partial, differential partial)
|
 MS SQL DBA Tools - Storage Manager - Backup Devices Tab |
