November 25, 2014 at 10:35 pm
Hi,
We do our own backups using sql command "BACKUP DATABASE ".
We have observed sql writer is running backgroud and eating up more memory.
So, can i just uninstall Microsoft sql Vss writer program from server?Or is there a way to stop the service without effecting any thing else?
If i need to uninstall, will there be any consequences?
Please guide me.
Thanks.
November 26, 2014 at 3:21 am
If you know for certain that you're using no other mechanisms that need the SQL Writer service, it can be disabled. That's from the Books Online.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 26, 2014 at 4:21 pm
HI Thanks for replying.So can i just disable the Microsoft Volume Shadow copy service from Services? or do i need to go through programs and uninstall the Feature to get rid of eating the memory?
Thanks.
November 27, 2014 at 5:22 am
Just disable the service. It's the kind of thing you may want to reenable in the future. Plus, it won't save memory, just storage.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply