Articles
How to Set Up Maintenance to Reorganize Indexes
Setting up Maintenance to Reorganize Indexes for SQL customers: Log into SQL Management Studio Open Management>Right Click on Maintenance Plan>Choose Maintenance Plan Wizard Once the Maintenance Plan Wizard opens> Click Next, then enter a N...
Set Mirror with Alter Database Query
Principal:
ALTER DATABASE (database name)
set partner = 'Tcp://(principal server).(computer name):(port)
Example:
ALTER DATABASE SIMSData
set partner = 'Tcp://ACSQL.AlarmCentral.local:5022'
Mirror:
ALTER DATABASE (database name...