if you are trying to restore a database from a backup file that is on a network server… the sql server service needs to be running under a domain account that has privileges to the network share you are trying to retrieve the backup file…
Author: Josephine
–date conversion methods: also 127 in ics file select convert(varchar, GetDate(), 100) as ‘100 Conversion’, — Dec 21 2010 3:13PM convert(varchar, GetDate(), 101) as ‘101 Conversion’, — 12/21/2010 convert(varchar, GetDate(), 102) as ‘102 Conversion’, — 2010.12.21 convert(varchar, GetDate(), 103) as ‘103 Conversion’, — 21/12/2010 convert(varchar,…
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.
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
exec sp_dboption dbname, ‘select into/bulkcopy’, ‘TRUE’ exec SP_dboption dbname,’trunc. log on chkpt.’,’true’