-
Guerrilla
MSSQL Mirror Backup
Hi,
I have setup B4A Pro to make a mirror backup on my MSSQL data folder. The backup works fine but I read the knowledge base article saying that I should stop the MSSQL service when taking a backup of it to avoid corrupting data. Do I have to do this or is the mirror backup I am taking fine without stopping the service?
Thanks
I have setup B4A Pro to make a mirror backup on my MSSQL data folder. The backup works fine but I read the knowledge base article saying that I should stop the MSSQL service when taking a backup of it to avoid corrupting data. Do I have to do this or is the mirror backup I am taking fine without stopping the service?
Thanks
-
Adrian (Softland)
- Posts: 1970
- Joined: Wed Dec 16, 2009 12:46 pm
Re: MSSQL Mirror Backup
Hi,
You need to stop the service even if using the Mirror backup type. This is how the files are released so you can copy them.
You need to stop the service even if using the Mirror backup type. This is how the files are released so you can copy them.
Do you know you can monitor your backups remotely with Backup4all Monitor? You can read more here: https://www.backup4all.com/backup4all-monitor.html