September 25, 2015 at 7:33 am
Hi All,
I need backup script to take all the database backups and we have the maintenance plan but our database character size is 98 and when we are taking the backups through maintenance plan while storing the backup history information it is adding the date and timezone information and exceeding the length to 128 so it is not writing the information on MSDB.
So we want to take the backup using the script and it has to create sub folder for each database. Also if any of the database fails it should continue with others.
September 25, 2015 at 7:47 am
THe scripts for backup - and also general maintenance here https://ola.hallengren.com are very well regarded indeed.
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
September 25, 2015 at 7:53 am
andrew gothard (9/25/2015)
THe scripts for backup - and also general maintenance here https://ola.hallengren.com are very well regarded indeed.
+1
Love Ola's scripts, no need to reinvent the wheel when you have a perfectly good wheel
September 25, 2015 at 8:20 am
Thanks for your information.
We have this script. when we are configuring the server first time this script is excellent to use. But for existing one if we are executing the script it will change the server level configuration settings. we have share point databases placed in this server so we can't execute this script. Please provide some other solutions.
September 25, 2015 at 8:21 am
Where does it change the server level settings?
I run this script across the environment which includes SharePoint with no issue at all.
September 25, 2015 at 9:00 am
Thanks you very much it is working fine without an issue. Thanks to who developed such beautiful script.
September 25, 2015 at 11:50 am
Minion Backup might be an alternative to Ola's scripts.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply