question

MeongHo avatar image
MeongHo asked

Usage of MS VSS to backup the FCI MSSQL

Dear SqlServerCentral,

In my task I need to backup an instance of FCI database with VSS. The MSSQL is deployed in distributed environment across 2 data centers. It seems to be weird but instances have a shared NFS folder hosted by one of the datacenters. The database is not huge enough, its size is below 1TB. But the installation is very critical, the fact makes the management team very nervous about the data. FCI in our case is a very specific installation of MSSQL.

But still can I use VSS to backup the MSSQL that operates in FCI? <= I'm pretty sure it works... I believe I should use VSS instance which is located on the node that hosts Active MSSQL instance of FCI. The reason for that is very simple it seems, this is because the standby copy is not online anyway.

May I ask you to confirm my theory?

Thank you!

mssqlbackupsfailovercopy
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.