Page 1 of 1

should i stop the sql server before the backup?

Posted: 07 Aug 2022, 00:29
by fkbeys
Hello.
I have a backup task which copies microsoft sql database files ( ._MS , ldf ).
Today i realized that, the Cobian Reflector suprisingly, copies files without stoping the Sql Server.
anyone has tried it? is it a reliable way to backup or am i wrong?
thanks in advance.

Re: should i stop the sql server before the backup?

Posted: 07 Aug 2022, 03:08
by cobian
If you are using Volume Shadow Copy then yes, you should get a good snapshot.