MSQL Service Writer .vs. VSS

Question

Post reply

MSQL Service Writer .vs. VSS

kflannigan

SSC Rookie

Points: 33
More actions
June 2, 2020 at 6:22 pm

#3759546

Quick question: on backups of SQL DB using VSS .vs. VDI.
VSS using MSQL Writer Service - can the logon account be different from the VSS logon account and how will this impact VSS or MSQL server?

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Site Owners SSC Guru Points: 80381 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

Steve Jones - SSC Editor SSC Guru Points: 738713 More actions · Answer 2

I thought VDI was the interface by which backups are made? VSS is what pauses transactions so you can get a consistent view.

I have no idea on the accounts. Can I ask what you're trying to do here?

kflannigan SSC Rookie Points: 33 More actions · Answer 3

Hi Steve -

VSS uses a local NT SYSTEM account -

MSQL Writer is part of VSS -- can the MSQL Writer Service use a different account name than VSS account name?

I'm just trying to understand how VSS would behave on a MSQL backup if we changed the MSQL Writer Service name from a local NT account to a domain account.

Steve Jones - SSC Editor SSC Guru Points: 738713 More actions · Answer 4

No idea. I can ask the question, but why would you change this? Domain accounts are used often when you need to control security and access outside of the host. For VSS, not sure this would be needed in any way.