As a lot of businesses use SQL databases for their CRM’s we are often faced with questions on how we handle SQL backups. Here is a question that has hit my inbox a few times this week:
How do we configure an SQL server to stop the database before performing a backup?
I’ll assume that if your business uses a database application that you perform daily/nightly backups of the core database to protect your business. For now I won’t assume how you perform those database backups but let me show you what I see on a regular basis.
As part of our data services we provide free on-site consultation and one common trend I’ve noticed is the hoops people need to jump through just to perform a nightly backup of their database.
