Start server with no debug mode

If Windows was started in debug mode on the system.
This stops the Visual Studio .NET debugger from debugging managed applications

To determine if a Windows-based computer is started in Debug mode, verify the computer's startup options in the registry:
Start Registry Editor.
Locate the following registry key:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control
In the Control key, locate the SystemStartOptions string value. If the computer is in Debug mode, one or more of the debug switches are displayed in the string (for example, /debug, /crashdebug, /debugport, or /baudrate). Any combination of one or more of these switches indicates that the computer is currently in Debug mode.


Remove all of the following switches
/debug
/debugport
/baudrate
in boot.ini file and then restart the server then it will come up in no-debug mode.

Logshipping systemtables

Below system tables in msdb database are used to capture the logshipping related information in Primary,secondary and monitor servers.

msdb..logshipping_primary_databases
msdb..log_shipping_secondary_databases
msdb..logshipping_secondary
msdb..log_shipping_primary_secondaries->Maps Each Primary database to its secondary database
msdb..log_shipping_monitor_primary
msdb..log_shipping_monitor_secondary-
msdb..log_shipping_monitor_history_detail->History of logshipping jobs
msdb..log_shipping_monitor_error_detail->error details of Logshipping jobs
msdb..log_shipping_monitor_alert->Alert Job ID

Backup and restore system tables

For every database backup/Restore,SQl server mantains the track of it's history in msdb database.

Backup related system tables:
msdb..backupmediafamily
msdb..backupfilefroup
msdb..backupfile
msdb..backupmediaset
msdb..logmarkhistory

Restore Database related System tables:
msdb..restorefile
msdb..restorefilegroup
msdb..restorehistory
msdb..suspect_pages
master..sysopentapes


To reduce the number of rows in the restore history table and in other backup and history tables, execute the sp_delete_backuphistory stored procedure.