SIMS Backup

[itgeek]

Hi,

 

We backup our sims server via veeam. I would like to backup the sims database independently to another location using DBattach cmd. Can this be run during the day or is it best to schedule this after the veeam back has completed.

 

Thanks in advance

[jthompson]

I expect you're better off scheduling db backups for either before or after the school day (to avoid any affect on performance and to give more distinct restore points in terms of school business).

 

I'd also recommend looking at doing this using a SQL Server maintenance plan, rather than DBattach. You could also have a maintenance plan that clears out db backups older than X days.

 

https://www.sqlshack.com/automate-sql-database-backups-using-maintenance-plans/

[Esteban_Child_of_the_Sun]

If you do use an SQL maintenance plan, remember to transfer the usernames and passwords (via a stored procedure int he SIMS database) from the system database in to the SIMS database before you back it up otherwise you may lose some passwords.