Tag Info

New answers tagged

1

I too am not a fan of the SQL Server maintenance plans -- used them long ago and had flaky bugs here and there and I too have to maintain and support multiple DB FULL and TRANSACTIONAL log backups for several instances of SQL Server. For DBA backup operations simplification, it may be best to take a look into using PowerShell. You may have to test and learn ...


1

I am not that huge fan of Maintenance plans to use such strategy for Backups. What suits the best to our environment is using ola.hallengren Backup scripts. It backups by taking the initial folder as the location define by the user and later it itself identifies the instance that it is backing up and thereafter creates the folder respectively: Give it a ...


0

Had a similar issue: changed the hostname of a computer where SQL Server and SQL Server Agent is running. Jobs were assigned to . After creating a temp user / logon to SSMS using this new temp user / drop and create the login name (public and sysadmin privs!) / re-assign the jobs to this re-created Login everything was fine. Maybe you could manipulate a ...



Top 50 recent answers are included