Backup-Restore
msdb..sp_delete_backuphistory
'1-Jan-2005'
|
msdb..logmarkhistory
|
msdb..backupset
|
|
msdb..backupfile
|
msdb..backupmediaset
|
msdb..backupmediafamily
|
|
msdb..restorefile
|
msdb..restorefilegroup
|
msdb..restorehistory
|
Index Related
sys.indexes
|
sys.dm_db_index_usag
|
sys.Indexes
|
sys.dm_db_index_physical_stats
|
sys.dm_db_index_usage_stats
|
sys.index_columns
|
SQL Server Operating System
sys.dm_os_sys_info
|
sys.dm_os_performance_counters
|
sys.dm_exec_requests
|
|
sys.dm_exec_sessions
|
Master..sysprocesses
|
sys.dm_exec_connections
|
|
sys.dm_os_waiting_tasks
|
sys.dm_os_wait_stats
|
sys.dm_os_nodes
|
SQL Server Agent Tables
dbo.sysjobactivity
|
dbo.sysjobhistory
|
dbo.sysjobs
|
dbo.sysjobschedules
|
dbo.sysjobservers
|
dbo.sysjobsteps
|
dbo.sysjobstepslogs
|
dbo.sysoperators
|
dbo.sysproxies
|
dbo.sysschedules
|
dbo.syssessions
|
Database Development, Management & Maintenance
Related
sys.columns
|
sys.check_constraints
|
sys.filegroups
|
sys.linked_logins
|
sys.master_files
|
sys.backup_devices
|
sys.configurations
|
sys.database_files
|
sys.databases
|
sys.default_constraints
|
sys.dm_tran_locks
|
sys.dm_tran_locks
|
sys.foreign_key_columns
|
sys.foreign_keys
|
sys.foreign_keys
|
sys.indexes
|
sys.key_constraints
|
sys.objects
|
sys.partitions
|
sys.remote_logins
|
sys.server_principals
|
sys.servers
|
sys.sql_logins
|
sys.syscharsets
|
sys.syslanguages
|
sys.types
|
sys.dm_db_file_space_usage
|
Security Related DMVs
sys.certificates
|
sys.credentials
|
sys.database_permissions
|
sys.database_principals
|
sys.securable_classes
|
sys.server_permissions
|
sys.server_principals
|
sys.server_role_members
|
sys.sql_logins
|
sys.symmetric_keys
|
sys.user_token
|
Log shipping Related DMVs
use msdb
log_shipping_monitor_alert
|
log_shipping_monitor_error_detail
|
log_shipping_monitor_history_detail
|
log_shipping_monitor_primary
|
log_shipping_monitor_secondary
|
Mirroring - Working with Mirroring Related DMVs
sys.database_mirroring
|
sys.database_mirroring_endpoints
|
sys.database_mirroring_witnesses
|
sys.dm_db_mirroring_connections
|
Sys.databases
|
Replication Tables in the Distribution Database
MSarticles
|
MSreplication_objects
|
MScached_peer_lsns
|
MSreplication_subscriptions
|
MSdistpublishers
|
MSrepl_commands
|
MSdistribution_agents
|
MSrepl_errors
|
MSdistribution_history
|
MSrepl_originators
|
MSdistributiondbs
|
MSrepl_transactions
|
MSdistributor
|
MSrepl_version
|
MSlogreader_agents
|
MSsnapshot_agents
|
MSlogreader_history
|
MSsnapshot_history
|
MSmerge_agents
|
MSsubscriber_info
|
MSmerge_history
|
MSsubscriber_schedule
|
MSmerge_sessions
|
MSsubscriptions
|
MSpublications
|
MStracer_tokens
|
Replication
Tables in the Publication Database
MSpeer_response
|
MSmerge_contents
|
MSpub_identity_range
|
MSmerge_current_partition_mappings
|
sysarticlecolumns
|
MSmerge_dynamic_snapshots
|
sysarticles
|
MSmerge_errorlineage
|
sysarticleupdates
|
MSmerge_generation_partition_mappings
|
sysmergearticlecolumns
|
MSmerge_genhistory
|
sysmergepublications
|
MSmerge_partition_groups
|
sysmergeschemaarticles
|
MSmerge_past_partition_mappings
|
sysschemaarticles
|
MSpeer_conflictdetectionconfigresponse
|
syssubscriptions
|
MSpeer_lsns
|
systranschemas
|
Replication Tables in the Subscription Database
MSdynamicsnapshotjobs
|
MSmerge_settingshistory
|
MSdynamicsnapshotviews
|
MSsnapshotdeliveryprogress
|
MSmerge_current_partition_mappings
|
MSsubscription_properties
|
sysmergearticles
|
MSmerge_generation_partition_mappings
|
sysmergepartitioninfo
|
MSmerge_genhistory
|
sysmergepublications
|
MSmerge_identity_range
|
sys.dm_repl_articles
|
sys.dm_repl_schemas
|
sys.dm_repl_tranhash
|
sys.dm_repl_traninfo
|
I don't even know how I ended up right here, however I thought this publish used
ReplyDeleteto be great. I do not realize who you are however definitely you're going to a well-known blogger
should you aren't already. Cheers!
I really like it whenever people get together and share thoughts.
ReplyDeleteGreat website, keep it up!