you can restart sql server agent during business hours, but make sure that it won’t be stopped when a scheduled job is set to run.
Category: sql server administration
instructions to setup database mail and job notification emails also, if you want to use your companies exchange server, then you need to make sure that smtp is enabled for the server that you want to send email from.
run first: sp_configure ‘show advanced options’, 1; RECONFIGURE; then this: sp_configure ‘Ad Hoc Distributed Queries’, 1; RECONFIGURE; ad hoc opens security issues – use very carefully!! only supposed to use ad hoc if there is infrequent access to the data for any data sources that…
in order to set: sp_configure ‘Ole Automation Procedures’, 1; GO you need to run this first: sp_configure ‘show advanced options’, 1; GO
when restoring the database backup you want to choose to leave the database non-operational (so that transaction logs can be restored) after the database restore is complete -to restore all transaction logs associated with the restored database choose “from previous backups of database” -to restore…
SQL Server Management Studio – right click on the Server – Properties – Database settings – Database default location
It is “normal” for LDF filesize to be about 120% of the MDF filesize – less than that there is no point shrinking the Log File as it will most likely grow back up to 120%
to find the log name – select name from sys.database_files where type = 1 to shrink to a specified target size – DBCC SHRINKFILE (DataFile1, 7); –where 7 = 7MB
Setup has detected a non canonical discretionary access control list (DACL) on directory ‘c:Program FilesMicrosoft SQL Server100DTS’. Please veirfy your security settings and make corrections if needed. Its ultimately a security issue that seems to result from having 1 version of SQL Server installed (in…